Doug McNutt wrote:
What I have learned:
Most important: Brian is very helpful. Thank you.
Dates are really floating point numbers and the unit is one day.
Somewhere there must be a way of setting the zero point. 1900, 1904,
1970 are common.
Tools > Options > LibreOffice Calc > Calculate > Date; the options are:
01/01/1900 (StarCalc 1.0)
Although it appears under the application's options, from a quick
experiment it appears that setting is actually saved in individual files
(at least when saving as ODS). Changing the setting seems to change the
default used for new documents, but opening an existing file will use
whatever epoch was saved in that file (again, at least with ODS files) -
which makes sense as different files might use different epochs. I guess
with non-ODS formats, LibreOffice will use the default if the file
format doesn't specify the epoch.
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted