Calc/CellWrapping

Problem

There are some problems between the edit view and print preview respectively PDF.

As of today Calc's view always formats as if the setting "Tools->Options->Calc->General->UsePrinterMetrics" was enabled ignoring the actual preference.

The PDF-export respects that setting and either layouts for an abstract printer (default) or it formats for the requested printer.

Affected Issues

80773 	DEFECT 	P3 	All 	spreadsheet 	NEW 	differences between ods and created pdf (linebreak, words di
81636 	DEFECT 	P3 	PC 	tl 	NEW 		oooqa 	the text from different cells is overlapped
85342 	DEFECT 	P3 	All 	spreadsheet 	NEW 	oooqa 	problem with text wrap in Calc cell
88864 	DEFECT 	P3 	All 	spreadsheet 	NEW 	oooqa 	Print preview different from edit mode
94387 	DEFECT 	P3 	Mac 	spreadsheet 	NEW 	needhelp, oooqa 	last line of wrapped text in cell is not printed
96397 	DEFECT 	P3 	PC 	spreadsheet 	NEW 	oooqa 	Cell text mangled in print/PDF
102231 	DEFECT 	P3 	PC 	spreadsheet 	NEW 	oooqa 	Word wrapping in "Page Preview" different from in Spreadshee
102293 	DEFECT 	P3 	All 	spreadsheet 	NEW 	oooqa 	Line breaks differ between Linux and Windows
107388 	DEFECT 	P3 	PC 	spreadsheet 	NEW 	oooqa 	Wrap Text Automatically
107600 	DEFECT 	P3 	PC 	spreadsheet 	NEW 	needhelp, oooqa 	cell prints over other cell, on print-preview and on paper

Workaround

The function " Use printer metrics for text formatting" you can find under

"Tools -> Options -> OpenOffice.org Calc-> General"

You have to activate this.

Possible Solution

Calc's view must not ignore the "Tools->Options->Calc->General->UsePrinterMetrics" setting (issue 96397).