https://bugs.freedesktop.org/show_bug.cgi?id=42607
--- Comment #18 from Mike Finch <[email protected]> 2011-11-23 15:14:48 PST --- I've had a think : re the date "problem" --> would there be a method for somehow maintaining many dates in a spreadsheet but being able to switch the date year (what do you call the 1899,1900 and 1904 conventions?). A normal user like me would presumably want the setting to be "1899 (default)". Rather than manually change many, many dates an alternative would be good. You can see my position : I would want all my spreadsheets to be in the 1899 form, but I would want to avoid all the manual changes. It should be made hard to change from default (warning message?). Obviously 1900 is designed for importation of StarCalc spreadsheets, but why the 1904 option? Anyway it's all part of "the learning process" but a pity I was "caught" in a non-1899 scenario! [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
