Apache OpenOffice (AOO) Bugzilla – Issue 76881
Column width changed on switching printer type and saving as xls
Last modified: 2013-08-07 15:12:27 UTC
Column width changed when spreadsheet of type xls is printed to a non-default printer that is not the same type as the default (e.g. default of matrix, printer used laserjet). This happens in the background and is only seen if the file is saved and re-open. Environment: Hardware : Windows XP pc Printer Epson EPL6100L (LaserJet) HP Laserjet 1200 (Laserjet) Wincor Nixdorf teller printer (Matrix) *** default printer Epson LQ matrix printer Software : Openoffice. No Microsoft office is installed. Detail steps Using only OO calc - create a spreadsheet with one column width 2" - save as file aa type xls. - open spreadsheet aa.xls and check column (it will show 2") - print spreadsheet using default printer (Wincor matrix printer) - check column width (it will show 2") - save as aa1.xls - open spreadsheet aa1.xls, column will show 2" width - send for printing to Epson laserjet - check column and it will show 2" - save as aa2.xls - check column width and it will show 2" - close aa2.xls - open aa2.xls and column width will NOT show 2". This happens on version 2.0.2, 2.0.3, 2.2 and Staroffice 8. The if the spreadsheet is saved as native ods this behavior is not displayed. This happens as long the default printer and the output printer is different (laserjet to matrix or matrix to laserjet). Switching between same type of printer (laserjet or matrix) does not have this behavior. Transporting the file from one PC having default matrix to another PC having default Laserjet also changes the column width. I use a new file name for testing. I cannot save a file without changes to the same file name. It will happen if you save it after changing and printing to a non-default printer of a different type. Protecting/locking/passwording everything does not help. It will still happen as long as the file is printed to another type of printer and saved. I do not have any other type to try.
Hi, please have a look at Tools-Options-OpenOffice.org Calc-General-Use Printermetrics for textformatting. Frank
Hi Frank, Tested. Other than being able to physically measure the difference (when the 'Printermetric is checked) all other behavior are as described. (Checking width with right-click still show 2"). Same behavior with "Printermetric" check and uncheck.
Please attach sample file, that exhibits this behavior.
Created attachment 45711 [details] original file
Created attachment 45712 [details] file after printing to another printer
Created attachment 45713 [details] picture of original file
Created attachment 45714 [details] image of file after print-close-open
Created attachment 45715 [details] image of printers in PC
Confirm with own test files and HO oj6110 / FritzFax for "2.2.1 Multilingual German version WIN XP: [680m18(Build9161)]"
Hi Daniel, please have a look at this one. frank
I also stumbled upon this issue... Using Calc on a portable to convert loads of old Excel sheets. Everything was OK, until another totally unrelated application was complaining about a missing printer - the PC has never used a printer. I was adviced to just install the 'builtin' generic/text printer. This solved the problem for the other application, but it causes the column widths of old Excel files to increase by a factor 2.4 (and more in another case) - uninstalling the driver will resolve the problem, but it's totally unacceptable that OO does something like this! Robert
Not trying to be pushy here, just hoping for some update. Would there be any movement for this issue? All my users are holding OO because of this issue(excuses to go MS Excel. Please correct me if this comment is inappropriate here.