Robin Laing wrote:
Robert Horvat wrote:
1. Cell value A1=1
set format to date and you get 31.12.99 this is WRONG, right is 1.1.
This is one of the options in
Tools > Options > OOo Calc > Calculate.
Change the Date setting and this will change.
No. The selected date in the options dialog is represented as value 0,
not 1. The option 1900-01-01 is for compatibility with the old StarCalc
1.0 application (we can still read files from StarCalc 1.0).
The default setting differs from what might be expected because we
didn't want to include the bogus day 1900-02-29, which exists in some
other spreadsheets, like Excel. For dates after that day, the value
representation is the same. For dates before it, our representation is
different, but consistent. As Excel doesn't allow negative date values,
compatibility issues are limited to January and February of 1900. In
return, we get sane semantics for date values (for example, someone
writing an add-in doesn't have to worry about this).
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
