Re: [libreoffice-users] I have to ask (four qustions)

2011/5/28 Nuzhna Pomoshch <nuzhna_pomoshch@yahoo.com>:
> 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).

I agree, it doesn't seem to be changeable. If it is, I want to know how…

> 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.

Tools → Options… → LibreOffice Calc → General

> 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)?

On my system they appear.

At Tools → Options → LibreOffice → General, the option ”☐ Use
LibreOffice dialogue boxes” (or something like that; I run LibreOffice
in Swedish) is unchecked. I don't remember if I unchecked it or if
it's unchecked by default, though.

> 4. Why is it so !@#$%^&*

You forgot the ☠ symbol… ☺

> 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).

Works for me. I did exactly like you described above. Here is the result:
http://ubuntuone.com/p/w5e/ (it's a video file, 3 942 058 bytes,
Theora format, recorded from my desktop)
Isn't this the same way as you are doing it?

> 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.

Well, I had no struggle, or maybe I totally misunderstood what you
were trying to do.
> Nuzhna

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
Unsubscribe instructions: E-mail to users+help@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