Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.