Bug 62801

Summary:	XLSX import does not read track changes document property
Product:	LibreOffice	Reporter:	Robert Roth <robert.roth.off>
Component:	filters and storage	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	aron.budea, kelemeng, libreoffice, stgohi-lobugs
Priority:	medium	Keywords:	filter:xlsx
Version:	4.0.1.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	125650
Attachments:	Screenshot of a test file in Excel and Calc Example file from LO 6.1

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

Hi,

Thanks for reporting!

I can reproduce this behavior using Linux Mint 14 x64 with LibreOffice Versie 4.0.2.2 .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,
Joren

Comment 2 A (Andy) 2015-02-26 20:03:30 UTC

For me not reproducible with LO 4.4.1.2, 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)

** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

- Update the version field
- Reply via email (please reply directly on the bug tracker)
- Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:

1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug

3. Leave a comment with your results.

4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword

Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16

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