Bug 56789

Summary: [Request] Enhancement: DATELASTSAVED()
Product: LibreOffice Reporter: Al Weiss <AlWeiss>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: eyalroz1, jorendc, marina.latini
Priority: medium    
Version: unspecified   
Hardware: Other   
OS: All   
Whiteboard: MS Excel feature parity
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108827    
Attachments: screenshot off properties
date on a printed sheet

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.