I can't believe this function does not exist. Quite often I prepare and distribute a spreadsheet to others. I would like it to contain the date on which it was updated. The easiest thing would be to implement a function DATELASTSAVED(). Everything I can find about this suggests using a macro. However, a function would be a lot easier to use.
Hi, Thanks for reporting! Set this bug report to enhancement. The developers are currently very busy crunching bugs for the new release of 4.0 (release in February). But I hope this enhancement will be picked up :-). Kind regards, Joren
So, 4.x has come and gone... this is, I believe, is an important feature. Many people create spreadsheets with a "last updated" field, which this function allows. Also, I would use LASTSAVEDATE() or something better than both options.
When you look at the properties off a document, you will see date and hour of creation and date and hour off update plus revision number Best regards
Created attachment 136332 [details] screenshot off properties
(In reply to Jorendc from comment #1) > Hi, > > Thanks for reporting! > Set this bug report to enhancement. > > The developers are currently very busy crunching bugs for the new release of > 4.0 (release in February). But I hope this enhancement will be picked up :-). > > Kind regards, > Joren (In reply to Al Weiss from comment #0) > I can't believe this function does not exist. Quite often I prepare and > distribute a spreadsheet to others. I would like it to contain the date on > which it was updated. The easiest thing would be to implement a function > DATELASTSAVED(). Everything I can find about this suggests using a macro. > However, a function would be a lot easier to use. It is now nearly 5 years since this enhancement has been requested. I see this need as significant because a person wants to know the date of the document CHANGE on the PRINTED SHEET. I am new to Libre Office, finally giving up Windows and going back to Linux after 15 years. No Save Date in Calc? Not even after this much time? As to the info being in the file properties, it is also displayed on the Linux file "ls -l" but that doesn't help those with a printed copy either.
Created attachment 136478 [details] date on a printed sheet
If you want a date and hour on printed sheet goto format => page tab footer or header and edit.