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

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'm going to reestablish my default template.
>
> Thanks,
> Andreas

You may be able to check/modify the
~/.libreoffice/3/user/registrymodifications.xcu file. From my testing
yesterday I see the changes in mine that refer to the Date test:

oor:name="CaseSensitive"
oor:op="fuse"><value>true</value></prop></item><item
oor:path="/org.openoffice.Office.Calc/Calculate/Other/Date"><prop
oor:name="DD" oor:op="fuse"><value>30</value></prop></item><item
oor:path="/org.openoffice.Office.Calc/Calculate/Other/Date"><prop
oor:name="MM" oor:op="fuse"><value>12</value></prop></item><item
oor:path="/org.openoffice.Office.Calc/Calculate/Other/Date"><prop
oor:name="YY" oor:op="fuse"><value>1899</value></prop></item><item
oor:path="/org.openoffice.Office.Calc/Calculate/Other"><prop

Note the "name="YY" oor:op="fuse"><value>1899</value>" - this value
changes when I make the changes (1904) in Tools|Options.

The file does not open well in gedit, so I used (U)OOo to open to view &
then used gvim to modify. I changed the 1899 value to 1904, saved, and
then opened Calc - the date value was then set to 1904 in the spreadsheet.

The usual warnings apply (backup, use at your own risk, etc) :-)

Gary



-- 
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 ***