Apache OpenOffice (AOO) Bugzilla – Issue 7217
Grid hight resizes to 1 pixel - sheet cannot be viewed
Last modified: 2013-08-07 15:15:02 UTC
The URL is a reference to a screenshot. This is the first time the problem happened to the entire file (all sheets). The screenshot shows what the page looks like when I resized the 4'th row to show the data in that row. An error happened when cutting and pasting. When I reloaded the file, all sheets had the grid resizes such that I could not see the data. The data is in the file, just not visable. I cannot send the file as it has confidential business information within it.
Further investigation. I installed OpenOffice.org 1.0.1 (in case that will make a difference). If I go to Format-->Row-->Height and then select "Default value" it becomes: 0.01" Where is this "Default value" set? I assume this is some default setting that is unique to my environment (IE: saved on disk).
Russell, thanks for posting. Can you reproduce this problem repeatedly, or is this a one time occurrence? You should also search the mailing list for some potential solutions. http://www.openoffice.org/servlets/ReadMsgmsgId=230034&listName=users http://www.openoffice.org/servlets/ReadMsgmsgId=252764&listName=users
Here's another suggestion from the mailing list. http://www.openoffice.org/servlets/ReadMsg?msgId=253243&listName=users If this works, please let us know so we can close this case.
Yes, the problem can be reproduced. The row-->Height being 0.01" is now stored somewhere as the default, and is the setting if I simply open OpenOffice.org and fo File->New->Spreadsheet. Where does this value come from? If we can determine this, we will know where to look for the problem. I don't know exactly where OpenOffice.org stores configuration, and don't know of a menu item that will allow me to correct this setting. I did install and upgrade to OpenOffice 1.0.1 , which created a new /home/russell/OpenOffice.org1.0.1 directory (I had assumed the /user/ directory is where config is). I logged in as a different user, installed OpenOffice (workstation - just the symbolic links to my network install) and saw the identical problem. Wherever the config problem is, it is global to all accounts. The font server and number of fonts installed hasn't changed for months. This problem is recent, and did not happen when I first installed OpenOffice.org If it is useful, my /etc/X11/fs/config is the one that came with RedHat in the RPM XFree86-xfs-4.1.0-15 . If this were a bug in the font server that was returning invalid height for fonts, I would expect other programs to have a similar problem which is not observed.
Thanks for your comments Russell. I just noticed that I messed up 2 of the mailing list links. The following link answers your question. http://www.openoffice.org/servlets/ReadMsg?msgId=252764&listName=users In the above message Niklas Nebel from Sun writes: "The default row height is calculated dynamically during startup from the height of the default cell font. If this doesn't work on your system, probably something's wrong with your font setup. See the thread at http://www.openoffice.org/servlets/ReadMsg?msgId=230034&listName=users for possible solutions.
Thanks for the links. Rather than fiddling, I upgraded to RedHat 7.3 which also fixed the problem. Is it not possible to detect an unusually small default row height and pop up a warning? This would avoid people having problems like this an assuming that the problem is in OpenOffice.org itself.
Good to hear things work out Russell. I'm going to change this ticket to an enhancement request. Perhaps OO should check to see the default row height. If it is extremely small, perhaps it should use some default value. I'm not sure if this is technically feasible though.
Hi Falko, enhancement is your buisness. Peter
Sorry, but we already have more than enough pop-ups. I do understand your pain but we also do not warn people about hidden rows or hidden columns. If one formats his data to extremes we must assume that this is done on purpose otherwise we would just annoy users who actually _want_ such formatting on purpose.
closed