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: 30/12/1899 (default) 01/01/1900 (StarCalc 1.0) 01/01/1904Although 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.
-- Mark. -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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