On 02/27/2011 03:48 PM, Andreas Säger wrote:
> Am 28.02.2011 00:25, NoOp wrote:
>
>
>> You might try renaming ~/.libreoffice.org and let LO build a new profile
>> to see if that makes any difference.
>>
>
> Resetting the profile cures the problem. No, I don't want to reset my
> user profile. I'
From: Andreas Säger
To: users@libreoffice.org
Sent: Sun, 27 February, 2011 23:48:01
Subject: [libreoffice-users] Re: Day zero is 1904-01-01 for new spreadsheets
Am 28.02.2011 00:25, NoOp wrote:
> You might try renaming ~/.libreoffice.org and let LO buil
Am 28.02.2011 00:25, NoOp wrote:
You might try renaming ~/.libreoffice.org and let LO build a new profile
to see if that makes any difference.
Resetting the profile cures the problem. No, I don't want to reset my
user profile. I'm going to reestablish my default template.
Thanks,
Andreas
On 02/27/2011 12:02 PM, Andreas Säger wrote:
> Am 27.02.2011 19:18, NoOp wrote:
>
>> What are you showing for:
>> Tools|Options|LibreOffice Calc|Calculate|Date
>> The default should be 12/30/1899 (or in your case 1899-12-30).
>>
>>
>
> No, the default for all brand new documents (not from templat
On 27 February 2011 14:04, Andreas Säger wrote:
> As already mentioned that I use to use my own default template. This occured
> to me during a test with a brand new document.
> Nevertheless, day zero must not be 1904-01-01 for brand new documents. I
> consider this to be a bug.
I believe it is t
Am 27.02.2011 19:14, Guy Voets wrote:
When you make your template, you can choose your start date here.
HTH
As already mentioned that I use to use my own default template. This
occured to me during a test with a brand new document.
Nevertheless, day zero must not be 1904-01-01 for brand new
Am 27.02.2011 19:18, NoOp wrote:
What are you showing for:
Tools|Options|LibreOffice Calc|Calculate|Date
The default should be 12/30/1899 (or in your case 1899-12-30).
No, the default for all brand new documents (not from template) is
1904-01-01 which causes a lot of trouble when you copy&p
Very interesting, Andreas.
Today I learned something about leap years thanks to you ;)
http://kalender-365.de/leap-years.php
I'm glad I don't have any time series of data going back to the 19th century
:)
--
View this message in context:
http://nabble.documentfoundation.org/Day-zero-is-1904-0
Am 27.02.2011 20:02, plino wrote:
This is puzzling:
if day Zero is 0-Jan-1900 and day 1 is 1-Jan-1900 for Excel and day Zero is
30-12-1899 and day 1 is 31-12-1899 for both LibO 3.3.1 and OOo Dev101, how
come =now() returns the same value in both spreadsheets?
Because of the day with no sun
This is puzzling:
if day Zero is 0-Jan-1900 and day 1 is 1-Jan-1900 for Excel and day Zero is
30-12-1899 and day 1 is 31-12-1899 for both LibO 3.3.1 and OOo Dev101, how
come =now() returns the same value in both spreadsheets?
--
View this message in context:
http://nabble.documentfoundation
On 02/27/2011 05:05 AM, Andreas Säger wrote:
> 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 i
11 matches
Mail list logo