https://bugs.freedesktop.org/show_bug.cgi?id=42607
--- Comment #17 from Mike Finch <[email protected]> 2011-11-23 15:01:04 PST --- Hallelujah! As simple as that, but still a tricky one. I suppose I'll have to check on what the various spreadsheets I've been using are set at. I've just set my finance spreadsheet from 1904 to 1899 (the default) and all the "errors" come back to the correct data!! Much thanks for your help - must confess I didn't think it was a manual enquiry, just a bug. I was wrong! It looks as if my Mageia installation (automatic) of LO was set at 1904 instead of the default. I really don't know, but the important thing is "It is solved"!! (I think you meant : "Menu 'Tools -> Options -> Calc -> Calculate - Date':) [email protected] wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=42607 > > Rainer Bielefeld<[email protected]> changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > Status|REOPENED |NEEDINFO > > --- Comment #15 from Rainer Bielefeld<[email protected]> > 2011-11-23 07:40:55 PST --- > The documents are not matching with the report, but let's see ;-) > > Both Cells mentioned in latest comment show number value 40407, the difference > is caused by different settings in the documents in Menu 'Tools -> Options -> > Calc -> General - Date': > Document B: 1.1.1904 > Document A: 1.1.1900 > > Seems to be a user error, but I believe Help / Documentation should mention > that there is no "absolute" base day definition, but it has to be agree upon > outside the document. > > But there remains 1 question: > I steps in Comment 11 are not fiction, but real experience from an experiment > (Seeing the complex sample documents I doubt), there might exist a problem > concerning use of different templates or similar with different base day > settings (or something similar). I currently can't see something like that, > but > you never know. > > @Mike Finch: > Can you please check and contribute your experience with 2 new documents "and > every mouse click ...., it's really important. > > > @David: > May be you can add some hints to the Calc Manual "Calculate options" - "Date > section"? Currently it's not clear why this setting might be important. > -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
