GNOME Bugzilla – Bug 79376
Printing Displays ######## When GUI Shows Correct Value
Last modified: 2004-12-22 21:47:04 UTC
A simple demonstration may help: Put the number 44626 in A1. Format Cell to be Currency with negative numbers in red parensthesis. If cell is big enough, GUI will display number. If it is too small, you will see ########. If you double-click on column edge (to autosize), the GUI will display the correct value; however, printing (and print preview) will display ########. There seems to be a small discrepancy between what the GUI feels is an acceptable size before it displays hashmarks and what the print module feels is an acceptable size. For the GUI, its 65 pixels but the print module won't be happy until about 67 pixels. This can be annoying once you have created a large sheet only to click print preview and see hashes everywhere. Not to mention figuring out why the GUI is fine and printing not. This also effectively limits the largest number you can put in a cell that will print correctly if you use autosize. If autosize would pad few pixels more, it would probably be fixed. Of course, it would be nice if the two agreed.
*** This bug has been marked as a duplicate of 62210 ***