# Where do .ods files show the Calc version used to create or generate the last save?

There's a huge archive of files here. Some may be useful for debugging and bug reports today. I consulted File Properties on files from 2016, 2017 etcetera and am surprised that the Calc version used to create/modify/save the file the last time (it's last modified date) is absent. Am I looking in the right place?

edit retag close merge delete

You don't say which version of LO you are using. I am using v6.4.6.2 and for a file from Jan 2018 File Properties lists the date/time (and user) for both the Creation and Modified events. It is possible that some of the information was not recorded in some earlier versions, and therefore would not be available now even in a recent version of LO.

( 2020-09-27 19:03:04 +0200 )edit

Yes, thankyou. I'm using LO Calc 7.0.1.2.

To help the Bug reporting debugging activity, much older files are needed that may have been created and saved with 4.1 or 5 for example. I can search the archives by year of course, yet it's the version that's needed. Sometimes the "Bug" leaves an error in the file. Samples provided on the Bug reporting open correctly with one Calc version, not another. That way we may be able establish a more precise statement of regression (which is version-used-dependent). I don't know if "version-used" was ever noted in the .ods format. Hope so! Somewhere!

( 2020-09-27 19:55:26 +0200 )edit

Sort by » oldest newest most voted

Hello,

as far as I know the only way to get the generator of an ODF is to:

• unzip the ODF zip container (e.g. unzip myspreadsheet.ods)
• open file meta.xml
• Search for line starting with <meta:generator>

Example:

<?xml version="1.0" encoding="UTF-8"?>

[snip]

<meta:generator>LibreOffice/6.4.4.2$Linux_X86_64 LibreOffice_project/3d775be2011f3886db32dfd395a6a6d1ca2630ff</meta:generator> [snip] </office:meta> </office:document-meta>  more ## Comments Thank you very much. I'll give that a go and, of course, share what happens. I'll be at it tomorrow, Monday. ( 2020-09-27 19:59:40 +0200 )edit Excellent. ODF file placed on Researchgate for all to download in 2016 gives <meta:generator>LibreOffice/5.0.5.2$Linux_X86_64 LibreOffice_project/00m0\$Build-2

It seems there's much to learn in the Object folders too. Thankyou very much (from France)

( 2020-09-28 08:30:06 +0200 )edit

To avoid the need of using an unzipper, but accepting the need to open the file(s), you can rely on user code.
(Basic):

Function sourceFileGenerator(Optional pDoc As Object)
If IsMissing(pDoc) Then pDoc = ThisComponent
sourceFileGenerator = pDoc.DocumentProperties.Generator
End Function

Sub showSourceFileGenerator(Optional pDoc As Object)
If IsMissing(pDoc) Then pDoc = ThisComponent
r = sourceFileGenerator(pDoc)
If r = "" Then
msg = "This document was not loaded from a file." & Chr(10) &_
"Its title is: " & pDoc.Title
Else
msg = "The file the document" & Chr(10) & pDoc.Title & Chr(10) &_
"was loaded from was saved with/on:" & Chr(10) & r
End If
ans = MsgBox(msg, 0, "You asked...")
End Sub


(You may also write a few additional lines of code to batch-process folders containing the mentioned files.)

more