Problem description: Opening a file changes its modification date attribute. Steps to reproduce: 1. open an XLS file with libreoffice with an aged modification time attribute Current behavior: the XLS file is opened and its mtime attribute is changed to now, without any saving action performed by the user. Expected behavior: the XLS file is opened, but its mtime attribute doesn't change, unless it is saved by the user. * I suspect this behavior is common for other file type, and perhaps not only for spreadsheet. (MacOS 10.6.8) Operating System: Mac OS X Version: 4.2.5.2 release
Created attachment 105196 [details] Example worksheet which demonstrates the bug. (Macros have to be activated) This file contains a macro which provides of a function to insert the last modification date and time to the worksheet.
I guess the bug here is very similar to the one found in Microsoft Excel (KB826741): This problem occurs because when you open an Excel workbook, Excel writes the name of the current user to the header of the file. This is necessary so that other users receive the "file in use" notification. The operating system then updates the last modified date. There is a binary difference between the file contents before you open and close an Excel workbook without saving it and after you open and close an Excel workbook without saving it.
*** This bug has been marked as a duplicate of bug 75467 ***