Bug Hunting Session
Bug 56789 - [Request] Enhancement: DATELASTSAVED()
Summary: [Request] Enhancement: DATELASTSAVED()
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: MS Excel feature parity
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2012-11-05 23:47 UTC by Al Weiss
Modified: 2018-11-26 11:47 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot off properties (69.09 KB, image/png)
2017-09-18 07:33 UTC, Xavier Van Wijmeersch
Details
date on a printed sheet (95 bytes, text/plain)
2017-09-22 15:04 UTC, Xavier Van Wijmeersch
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Al Weiss 2012-11-05 23:47:41 UTC
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.
Comment 1 Jorendc 2013-01-09 21:44:36 UTC
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
Comment 2 Eyal Rozenberg 2015-09-29 17:43:08 UTC
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.
Comment 3 Xavier Van Wijmeersch 2017-09-18 07:32:35 UTC
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
Comment 4 Xavier Van Wijmeersch 2017-09-18 07:33:24 UTC
Created attachment 136332 [details]
screenshot off properties
Comment 5 John 2017-09-21 15:58:05 UTC
(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.
Comment 6 Xavier Van Wijmeersch 2017-09-22 15:04:53 UTC
Created attachment 136478 [details]
date on a printed sheet
Comment 7 Xavier Van Wijmeersch 2017-09-22 15:06:15 UTC
If you want a date and hour on printed sheet goto format => page tab footer or header and edit.