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.
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
The function " Use printer metrics for text formatting" you can find under
"Tools -> Options -> OpenOffice.org Calc-> General"
You have to activate this.
Calc's view must not ignore the "Tools->Options->Calc->General->UsePrinterMetrics" setting (issue 96397).