Basically, what the title says. As of late (I think since I updated to version 5.4.2.2.0+), whenever I open a spreadsheet with Calc, it appears as modified:
-
There’s a star above the ‘Save’ icon
-
I get a ‘Save Document?’ pop-up window if I try to close the file immediatly without doing anything on it
It only happens with Calc documents. Writer and Impress don’t exhibit this behavior. Is this a bug? Is it a new default behavior that I can change in the Options? (I’ve looked there, but couldn’t find anything)
PS: I’m on Arch Linux 64bit.
EDIT: I’ve got new data regarding this issue.
-
I couldn’t reproduce the aforementioned behaviour on my work PC which runs LibreOffice 4.something on Ubuntu 14.04. No spreadsheet I opened with it was immediately marked as modified.
-
By trying lots of other spreadsheets on my home computer (the one with Arch Linux and LO v5.4.2.2.0+), I think I’ve found what causes the issue. It’s got to do with whether the document contains any chart or not. Spreadsheets without charts in them behave as expected, while documents with even a single, simple chart are automatically marked as modified when opened.
In fact, I can easily reproduce the issue now:
- Create a new spreadsheet, and write some random text in cell A1. Save and exit.
- Open the newly created spreadsheet, and it doesn’t get marked as modified.
- Now enter some random numbers in different contiguous cells, and create a chart (e.g. a pie chart). Save and exit.
- Open the spreadsheet again, and it will now be marked as modified upon loading it.
Can anyone reproduce it and confirm it?