Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a few Open Office spreadsheet files (let us call them source files), each containing the financial info of a particular office of ours. I also have a summary spreadsheet, that reads some key data about the offices and does some analysis. For the analysis, I would like to know also, how outdated the individual source files, when was the last time the offices updated their data. Is there a way to access the "Last time modified" and/or "Time of creation" file system properties of the source files from Open Office, and import the date into a given cell?

Alternative solutions are also OK, as long as I get the date of last change of the source files into the cells of the summary spreadsheet.

share|improve this question

1 Answer 1

The closest thing I've found for libreoffice is the NOW() function. The internet has many Excel-related answers that require visual basic. See for example

http://www.sumproduct.com/thought/creating-a-timestamp

Hope you (and I!) get a good answer some day, but 9 months on I suppose we will have to live without a bit longer...

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.