Re: [libreoffice-users] Day zero is 1904-01-01 for new spreadsheets

2011/2/27 Andreas Säger <villeroy@t-online.de>:
> Ubuntu 10.4, LibO 3.3.1.
> Since many years I use some default template for new Calc documents. Today I
> reset this default template in the templates organizer.
> Now every new document gets 1904-01-01 as day zero.
>
> This is the respective entry in content.xml:
> <table:null-date table:date-value="1904-01-01"/>
>
> This does not happen in OOo 3.3. where I performed the same steps.
> The new document from scratch does not have any table:null-date which
> defaults to 1899-12-30.
> Could not find bugs with Null-Date nor "1904".
>
> Hope it's not a new feature.
>
> Andreas

I remember I used to import dates of birth in Excel files made in
Windows, and on my Mac everybody got 4 years minus one day younger -
or somthing like that. Excel on Windows used another 'null date' than
Excel for Mac. There was an option in the preferences to choose
between 01-01-1904 and the Windows date (01-01-1900 or 31 / 31-12-1899
- that I don't remember).
The problem you found seems similar to this.

Looking a bit further, I found in LibO's Prefs: LibO Calc > Calculate
> Date the three possibilities (Standard, StarOffice Calc 1.0
(01-01-1900), 1-1-1904). By default, the date is set to 31-12-1899.

When you make your template, you can choose your start date here.

HTH
-- 
Guy
using LibO 3.3.1 on a iMac Intel DualCore Snow Leopard
-- please reply only to users@libreoffice.org --
Dodoes can't afford to have headaches

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***