Dotan Cohen wrote:
2009/12/13 Andreas Saeger <[email protected]>:
Dotan Cohen wrote:
Thanks, Andreas, but Hebrew support is far different than yyyy-mm-dd
support! yyyy-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 yyyy-mm-dd is among the predefined date
formats in any locales.
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 format your cells or not.
2005-9-2, 2.9.05 or the "true" value 37504 makes no difference at all.
It is really the same value. No formula result nor filter nor sort order
depends on the number format.
My default template contains a set of styles. Style "ISODate" (Default
number format locale) has a child style "ISODate+" (weekday appended),
another child style "ISODateTime" and one for time only.
I never care about the number format as long as I get the right values
(well, like you, I don't like reading US style MDY-dates).
Depending on the kind of document, I apply my prefered cell styles
beforehand or when I'm done.
This has nothing to do with styles.
Yes, sure. These are the styles I defined for myself and a consistently
formatted spreadsheet is a matter of seconds.
Quite often I used to debug other people's sheets. The first step is to
remove all formatting from all cells: Select all [Ctrl+A], double-click
style "Default", menu:Format>Default (remove hard attributes). Quite often
people are so obsessed with appearence that they forget about the validity
of their data.
I find that hard to believe. If one applies the Default formatting to
a date-formatted cell, the result is not a comprehensible date.
If you see a "comprehensible date" after removing all formatting, it is
a text actually.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
