Difference between revisions of "Calc/CellWrapping"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Affected Issues)
(problem+solution)
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
 
==Problem==
 
==Problem==
  
 
There are some problems between the edit view and print preview respectively PDF.
 
There are some problems between the edit view and print preview respectively PDF.
  
It seems that both precesses use different font typefaces.
+
As of today Calc's view always formats as if the setting
 +
"Tools->Options->Calc->General->UsePrinterMetrics"
 +
was enabled ignoring the actual preference.
  
e.g times New Roman Ps instead of Times new Roman
+
The PDF-export respects that setting and either layouts for an abstract printer (default) or it formats for the requested printer.
  
 
==Affected Issues==
 
==Affected Issues==
  
 
<pre>
 
<pre>
80773 DEFECT P3 All spreadsheet NEW --- differences between ods and created pdf (linebreak, words di
+
80773 DEFECT P3 All spreadsheet NEW differences between ods and created pdf (linebreak, words di
81636 DEFECT P3 PC tl NEW OOo 3.x oooqa the text from different cells is overlapped
+
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
+
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
+
88864 DEFECT P3 All spreadsheet NEW oooqa Print preview different from edit mode
94387 DEFECT P3 Macintos spreadsheet NEW --- needhelp, oooqa last line of wrapped text in cell is not printed
+
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
+
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
+
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
+
102293 DEFECT P3 All spreadsheet NEW oooqa Line breaks differ between Linux and Windows
107388 DEFECT P3 PC spreadsheet NEW --- oooqa Wrap Text Automatically
+
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
+
107600 DEFECT P3 PC spreadsheet NEW needhelp, oooqa cell prints over other cell, on print-preview and on paper
 +
</pre>
  
10 issues found
+
==Workaround==
  
</pre>
+
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 ([http://www.openoffice.org/issues/show_bug.cgi?id=96397 issue 96397]).
  
 
[[Category:Calc]]
 
[[Category:Calc]]

Latest revision as of 12:31, 25 June 2010

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).

Personal tools