Using LibreOffice 3.3.1 (Linux). 1. Why is the default column width in Calc 2.27 cm? Where does that number come from? How do I change it? I haven't used Excel in years, but I believe that is easy to set in the options. Even resetting the column width in the default style doesn't change the "default value" (and when I did that, the columns in the template I saved were wider than the columns in a new spreadsheet based on that same template, even though both of them showed the exact same column width when examined).
2. I sometimes need to work in cm, and sometimes in inches. How do I change from one to the other? Again, I recall that this was easy to set in Excel. 3. How do I get hidden ("dot" directories) to appear in the open and save dialog boxes (they appear in all of the window manager dialog boxes)? 4. Why is it so !@#$%^&* hard to format cells (this has continued from OpenOffice)? I was trying to set up a spreadsheet so that all cells displayed two decimal places, except for the top row and column (headers, which should display no decimal places). Click the upper left corner and change to two decimal places. Good. Click column A and change to General. Good. Click row 1 and change to general. DOESN'T WORK. It SAYS General, but I still see two decimal places (it seems to only look at cell A1). Tried selecting and tabbing to a different cell in the row. Still doesn't work. Didn't anyone ever consider the possibility that a user might want to set the same format for a range of cells that currently have different formats. Automatic in Excel (I remember that one for sure). Things like this should be the easiest things in the world to do, instead of such a massive struggle. Nuzhna -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted