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

--- On Sat, 5/28/11, Johnny Rosenberg <gurus.knugum@gmail.com> wrote:

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

Missed that (I don't know how). Thank you.


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

I don't have any option like that at all. Just
a few things (under LibreOffice / General) for
"help" (enabling tips and help agent), "document
status" (whether printing sets the "document
modified" status), and how to handle a two digit
year.


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

That is basically it (I don't have the "standard
formatting" on my context menu, though). I was
trying to specifically select "general" after
pulling up the "format cells" mutlti-tabbed
dialog box. I have played with this some more,
and it seems that using "default formatting"
(from the top menu) works, as does changing the
format to something else. It only doesn't work
when trying to change back to the "general"
format, apparently because the dialog box sets
that as the "current" format when all of the
selected cells do not have the same format.

A bit esoteric, but it still should be fixed.



--- On Sat, 5/28/11, planas <jslozier@gmail.com> wrote:

> > 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)?
>
> This is an OS controlled option in Windows and
> Linux. You have to check the correct setting in
> the OS folder display control to see the hidden
> files.

It's not the OS, it is the file manager, and the
file manager DOES display dot files for every
application under the sun, EXCEPT LibreOffice.



--- On Sun, 5/29/11, planas <jslozier@gmail.com> wrote:

> On Sat, 2011-05-28 at 20:10 -0400, Gene Young wrote:

> > On 5/28/2011 5:56 PM, planas wrote:
> > > I have no idea why that size was chosen but
> > > you can change by FORMAT>>COLUMN>>COLUMN
> > > WIDTH. A dialog box should open and you
> > > change the value to what you want to use.
> > > For it to be the default make sure the
> > > check box "Default Value" is checked.

> > Checking the "Default Value" check box does
> > not set the default value, it selects the
> > default value, over-riding what ever value
> > you may have typed into the selection box.

> My error, if you want to permanently change
> the default setting you must overwrite the
> default Calc blank spreadsheet.

That changes the width of columns in a new
spreadsheet, but clicking on "default value"
will set it right back to 2.27 cm despite the
change. It seems that the "default value" is
immutable.



--- On Sun, 5/29/11, ApinderSingh <as.nv.del@gmail.com> wrote:

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

> CTRL+H
> you need to press this key combo(GNOME) when
> open/save dialog box is opened everytime.

Uh, no. That cleverly connects me to the online
help (which doesn't mention anything about how
to display dot directories). I don't use gnome
(maybe it works fine there), but that keystroke
combination is not a standard.

> Works with all applications. For permanently
> setting that behavior, change settings of your
> file manager.

The file manager most certainly has that option
enabled (it works in every other application).
No, the Alt+. key combination does not work in
the LibreOffice dialog boxes, either).



--- On Wed, 6/1/11, toki <toki.kantoor@gmail.com> wrote:

> > 1. Why is the default column width in Calc
> > 2.27 cm? Where does that number come from?

> That is supposed to be one inch wide. (I know
> that one inch is 25.4mm, but the conversion
> was incorrectly done, and hasn't been changed
> since then.)

That is so bizarre, it must be true. I still
believe the user should be able to change that
(without having to change the default template).


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

> This depends upon the file manager that is used.

Can anyone tell me how to enable this in Dolphin
then? Again in the View menu, "Show Hidden Files"
is checked (and they get displayed in every other
application I have ever seen).


> > 4. Why is it so !@#$%^&* hard to format cells
> > (this has continued from OpenOffice)?

> You have to use cell styles.
> Cell styles are neither difficult, nor
> complicated to use.  However, for reasons I
> don't understand, people are reluctant to use
> them.

Another layer of complexity I would rather avoid
(meaning one more opportunity for me to screw
something up). When I select a range and hit the
"OK" button in the format dialog box, it should
work.



Apologies for the Yahoo mailer. One USED to be
able to set the width of the compose window, but
that option is no longer available. :(

Nuzhna

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.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