Modify the number format _locale_ only, so you can enter d/m/y dates rather
than m/d/y.
That formats all Categories and Formats, so I get stuck with the comma
as a decimal.
Rosh ha-shanna,
Thanks! Actually, Rosh ha-shana just means New Year, (Rosh: head ;
Ha: the ; Shana: year ; the of' is
Sorry for the delay, I have been swamped.
As already stated, OOo uses the Hebrew locale with UK style dates when
started with a he_IL environment.
What are UK style dates? -mm-dd?
Stop insisting on modified defaults. It is not possible.
Why7 should I stop insisting on a critical
2009/12/22 Andreas Saeger saege...@onlinehome.de:
NoOp wrote:
I did find that if I set the Default style (in OOo Calc) to Swedish
(Sweden) and then the Date format to -MM-DD, the numbers displayed
in the cell and in the formula bar are 2009-12-13. So that may be worth
experimenting with
Dotan Cohen wrote:
Sorry for the delay, I have been swamped.
As already stated, OOo uses the Hebrew locale with UK style dates when
started with a he_IL environment.
What are UK style dates? -mm-dd?
dd/mm/
Stop insisting on modified defaults. It is not possible.
Why7 should I
NoOp wrote:
Option Decimal separator key refers to the decimal key on the num-pad.
You can (and should) force that key to send a comma or a dot to
OpenOffice.org, according to the set locale.
Without this option, the application receives the same character as any
other application.
Do you
My test reveals the same as it ever did since version 1.
Ooo3.1.1, LANG=de_DE (comma decimals)
Num pad's decimal key on is comma in some text editor
Locale Default (German), option checked
Input Result Comment
3.1401.03.14Number
On 12/23/2009 01:41 PM, Andreas Saeger wrote:
My test reveals the same as it ever did since version 1.
...
Option Decimal separator key same as locale has no effect on the
actually used decimal separator. It controls if the num pad's decimal
separator is adjusted to the application
NoOp wrote:
I did find that if I set the Default style (in OOo Calc) to Swedish
(Sweden) and then the Date format to -MM-DD, the numbers displayed
in the cell and in the formula bar are 2009-12-13. So that may be worth
experimenting with also.
Hi,
Allow me to abstract the discussion
On 12/22/2009 12:49 AM, Andreas Saeger wrote:
NoOp wrote:
I did find that if I set the Default style (in OOo Calc) to Swedish
(Sweden) and then the Date format to -MM-DD, the numbers displayed
in the cell and in the formula bar are 2009-12-13. So that may be worth
experimenting with
NoOp wrote:
quote NoOp
So, set up Tools|Options|Lang...|Languages|Locale Setting|Swedish
(Sweden) and adjust the *Decimal*, Currency, Language, etc for your liking.
/quote NoOp
Emphasis added to adjust the *Decimal*. Does this not work for you?
Works for me. Here, let me explain how to adjust
On 12/22/2009 12:39 PM, Andreas Saeger wrote:
NoOp wrote:
quote NoOp
So, set up Tools|Options|Lang...|Languages|Locale Setting|Swedish
(Sweden) and adjust the *Decimal*, Currency, Language, etc for your liking.
/quote NoOp
Emphasis added to adjust the *Decimal*. Does this not work for
Let me state it another way:
A user opens Calc and creates a new spreadsheet. He enters
2009-12-13 into cell A1. He expects that text to remain 2009-12-13
when he presses Tab. What must I configure beforehand to ensure that
he gets what he expects?
No spreadsheet I'm aware of implements
Anything preventing the user from:
Format|Cells|Date|1999-12-31
?
Or am I confusing Date formating with Text formating?
In the latter case, the user should enter
'2009-12-13
and then press Tab.
I need this to be the default, Gary. The users could just go to any
cell and type in their
Dotan Cohen wrote:
You might be used to OOo Calc changing your date formats for you on
the fly, but I enter dates in the format that I would like to use
them.
That's exactly what Calc does *not* do. It applies the format *you* have
set or some default which depends on it's own locale (Hebrew,
Dotan Cohen wrote:
Anything preventing the user from:
Format|Cells|Date|1999-12-31
?
Or am I confusing Date formating with Text formating?
In the latter case, the user should enter
'2009-12-13
and then press Tab.
I need this to be the default, Gary. The users could just go to any
cell and
You might be used to OOo Calc changing your date formats for you on
the fly, but I enter dates in the format that I would like to use
them.
That's exactly what Calc does *not* do. It applies the format *you* have set
or some default which depends on it's own locale (Hebrew, German, UK
As already stated, OOo uses the Hebrew locale with UK style dates when
started with a he_IL environment.
Stop insisting on modified defaults. It is not possible.
All of my own spreadsheets use no dates other than ISO dates. I never
see any US style since I use either one of explicitly set
On 12/21/2009 11:09 AM, Dotan Cohen wrote:
You might be used to OOo Calc changing your date formats for you on
the fly, but I enter dates in the format that I would like to use
them.
That's exactly what Calc does *not* do. It applies the format *you* have set
or some default which depends on
On 12/21/2009 10:43 AM, Dotan Cohen wrote:
Anything preventing the user from:
Format|Cells|Date|1999-12-31
?
Or am I confusing Date formating with Text formating?
In the latter case, the user should enter
'2009-12-13
and then press Tab.
I need this to be the default, Gary. The users
Where is there an outline of which locales provide which formatting? I
have gone through quite a bit of the docs as support.openoffice.org
but I find nothing.
Any number format dialog in this office suite shows all the built-in
formattings with format codes for all the built-in locales and
20091212.1714, or
2009-12-12.17:14, or
2009.12.12, 1714h, or
2009/12/12; whatever,
Akron, Ohio, US;
You and I are not going back to pencil and paper. I say to configure it
the universal way our tools will sort. This [should be] the end, my
friend, of obsolescent convention.
I think
Dotan Cohen wrote:
Thanks, Andreas, but Hebrew support is far different than -mm-dd
support! -mm-dd is not the default date format for Israel, rather,
I think it is the British yy/mm/dd as you are familiar with.
As far as I can see, ISO date -mm-dd is among the predefined date
2009/12/13 Andreas Saeger saege...@onlinehome.de:
Dotan Cohen wrote:
Thanks, Andreas, but Hebrew support is far different than -mm-dd
support! -mm-dd is not the default date format for Israel, rather,
I think it is the British yy/mm/dd as you are familiar with.
As far as I can
Dotan Cohen wrote:
2009/12/13 Andreas Saeger saege...@onlinehome.de:
Dotan Cohen wrote:
Thanks, Andreas, but Hebrew support is far different than -mm-dd
support! -mm-dd is not the default date format for Israel, rather,
I think it is the British yy/mm/dd as you are familiar with.
Yes, but it is not the default locale in any but Hungarian and
Latvian. I need it to be my default date format, so when an
unformatted cell gets 2005-9-2 Calc doesn't mangle it into something
else.
This can not work with unformatted cells (you mean number format
General). You are the one to
Dotan Cohen wrote:
Yes, but it is not the default locale in any but Hungarian and
Latvian. I need it to be my default date format, so when an
unformatted cell gets 2005-9-2 Calc doesn't mangle it into something
else.
This can not work with unformatted cells (you mean number format
General).
On 12/13/2009 02:11 PM, Dotan Cohen wrote:
Yes, but it is not the default locale in any but Hungarian and
Latvian. I need it to be my default date format, so when an
unformatted cell gets 2005-9-2 Calc doesn't mangle it into something
else.
This can not work with unformatted cells (you mean
On 12/13/2009 03:51 PM, NoOp wrote:
On 12/13/2009 02:11 PM, Dotan Cohen wrote:
Yes, but it is not the default locale in any but Hungarian and
Latvian. I need it to be my default date format, so when an
unformatted cell gets 2005-9-2 Calc doesn't mangle it into something
else.
This can not
Dotan Cohen wrote:
No, my locale is not US English:
$ locale
LANG=he_IL.utf8
This is the only relevant setting which is read from the OS when a
default locale has to be evaluated.
I figured that I could get away with not posting that as I posted this:
$ date +%x
2009-12-08
The program
No, my locale is not US English:
$ locale
LANG=he_IL.utf8
This is the only relevant setting which is read from the OS when a default
locale has to be evaluated.
Really? In my opinion it is wrong behaviour to ignore the user's
specifically-set Time and other settings. Is there a place where
Dotan Cohen wrote:
Where is there an outline of which locales provide which formatting? I
have gone through quite a bit of the docs as support.openoffice.org
but I find nothing.
Any number format dialog in this office suite shows all the built-in
formattings with format codes for all the
20091212.1714, or
2009-12-12.17:14, or
2009.12.12, 1714h, or
2009/12/12; whatever,
Akron, Ohio, US;
You and I are not going back to pencil and paper. I say to configure it
the universal way our tools will sort. This [should be] the end, my
friend, of obsolescent convention.
James Liebert
Dotan Cohen wrote:
Please, please, this is killing me.
$ date +%x
2009-12-08
However, Calc insists on using the mm/dd/yy year format in new
documents. The settings under Language are all Default. What must I do
to have OOo respect the locale settings?
I know that this issue has been addressed
2009/12/11 Andreas Saeger saege...@onlinehome.de:
Dotan Cohen wrote:
Please, please, this is killing me.
$ date +%x
2009-12-08
However, Calc insists on using the mm/dd/yy year format in new
documents. The settings under Language are all Default. What must I do
to have OOo respect the
Johnny Rosenberg wrote:
2009/12/11 Andreas Saeger saege...@onlinehome.de:
Dotan Cohen wrote:
Please, please, this is killing me.
$ date +%x
2009-12-08
However, Calc insists on using the mm/dd/yy year format in new
documents. The settings under Language are all Default. What must I do
to have
-Original Message-
From: Johnny Rosenberg [mailto:gurus.knu...@gmail.com]
Sent: December 11, 2009 10:13 AM
To: users@openoffice.org
Subject: Re: [users] Re: Who do I have to strangle to get OOo to respect locale
settings in Linux?
2009/12/11 Andreas Saeger saege...@onlinehome.de:
2009/12/11 Andreas Saeger saege...@onlinehome.de:
Dotan Cohen wrote:
Please, please, this is killing me.
$ date +%x
2009-12-08
However, Calc insists on using the mm/dd/yy year format in new
documents. The settings under Language are all Default. What must I do
to have OOo respect the
37 matches
Mail list logo