Bug 62801 - XLSX import does not read track changes document property
Summary: XLSX import does not read track changes document property
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Track-Changes
  Show dependency treegraph
Reported: 2013-03-27 09:17 UTC by Robert Roth
Modified: 2021-01-07 17:39 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Screenshot of a test file in Excel and Calc (94.94 KB, image/png)
2018-12-05 09:09 UTC, Gabor Kelemen (allotropia)
Example file from LO 6.1 (6.99 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-12-05 09:09 UTC, Gabor Kelemen (allotropia)

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Roth 2013-03-27 09:17:23 UTC
Steps to reproduce:
1. Create a new spreadsheet using Calc
2. Insert something in the first cell
3. Turn Track changes on 
   (in windows using File->Properties: Record changes)
   (in ubuntu using Edit->Changes->Record)
4. Insert something in the second cell (notice the text having a red border, showing that it has been added lately)
5. Save as XLSX
   (when manually checking the archive XLSX, it does contain the tracked changes attributes, revisions directory in /xl/, so tracked changes setting is saved in the document  )
6. Close calc
7. Open the saved XLSX
Expected behaviour: revision history appears (the second cell appears with another color, as it has revision history associated), the document editing starts with track changes on, as the document was saved with track changes turned on
What happens instead:
The track changes option is turned off, when saving, the whole revision history is lost, and not saved in the resulting XLSX, thus causing data loss.
Comment 1 Jorendc 2013-04-08 18:50:52 UTC

Thanks for reporting!

I can reproduce this behavior using Linux Mint 14 x64 with LibreOffice Versie .2.2 (Bouw-id: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3); Dutch UI.

Therefore I mark this as NEW. I left the bug priority as default (normal medium).
Normal: it does prevent you to make high quality work (share documents etc)
Medium: default priority.

Kind regards,
Comment 2 A (Andy) 2015-02-26 20:03:30 UTC
For me not reproducible with LO, Win 8.1

Can anybody still reproduce this issue or was this already resolved in the meantime?
Comment 3 tommy27 2016-04-16 07:22:59 UTC Comment hidden (obsolete)
Comment 4 Gabor Kelemen (allotropia) 2018-12-05 09:09:10 UTC
Created attachment 147297 [details]
Screenshot of a test file in Excel and Calc

Seems to mostly work fine, although I had to explicitly enable the display of tracked changes in Excel.
Comment 5 Gabor Kelemen (allotropia) 2018-12-05 09:09:41 UTC
Created attachment 147298 [details]
Example file from LO 6.1