Issue 76881 - Column width changed on switching printer type and saving as xls
Summary: Column width changed on switching printer type and saving as xls
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.2
Hardware: All Windows XP
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-05-03 03:34 UTC by tkj
Modified: 2013-08-07 15:12 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

original file (62.50 KB, text/plain)
2007-06-07 09:33 UTC, tkj
no flags Details
file after printing to another printer (64.50 KB, text/plain)
2007-06-07 09:34 UTC, tkj
no flags Details
picture of original file (119.03 KB, text/plain)
2007-06-07 09:35 UTC, tkj
no flags Details
image of file after print-close-open (110.93 KB, text/plain)
2007-06-07 09:35 UTC, tkj
no flags Details
image of printers in PC (68.24 KB, text/plain)
2007-06-07 09:36 UTC, tkj
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description tkj 2007-05-03 03:34:49 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. 

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
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.
Comment 1 frank 2007-05-03 10:13:55 UTC

please have a look at Calc-General-Use
Printermetrics for textformatting.

Comment 2 tkj 2007-05-03 11:47:15 UTC
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
Comment 3 kpalagin 2007-06-04 15:09:33 UTC
Please attach sample file, that exhibits this behavior.
Comment 4 tkj 2007-06-07 09:33:38 UTC
Created attachment 45711 [details]
original file
Comment 5 tkj 2007-06-07 09:34:16 UTC
Created attachment 45712 [details]
file after printing to another printer
Comment 6 tkj 2007-06-07 09:35:04 UTC
Created attachment 45713 [details]
picture of original file
Comment 7 tkj 2007-06-07 09:35:44 UTC
Created attachment 45714 [details]
image of file after print-close-open
Comment 8 tkj 2007-06-07 09:36:12 UTC
Created attachment 45715 [details]
image of printers in PC
Comment 9 Rainer Bielefeld 2007-07-11 13:32:11 UTC
Confirm with own test files and HO oj6110 / FritzFax for "2.2.1  Multilingual
German version WIN XP: [680m18(Build9161)]" 
Comment 10 frank 2007-07-11 14:42:26 UTC
Hi Daniel,

please have a look at this one.

Comment 11 prino 2007-08-01 11:49:59 UTC
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!

Comment 12 tkj 2008-01-23 05:45:17 UTC
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