Bug 123186 - FILEOPEN XLSX Accepting or rejecting changes in Excel don't transfer to Calc correctly
Summary: FILEOPEN XLSX Accepting or rejecting changes in Excel don't transfer to Calc ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, filter:xlsx
Depends on:
Blocks: XLSX-Track-Changes
  Show dependency treegraph
 
Reported: 2019-02-05 13:19 UTC by NISZ LibreOffice Team
Modified: 2021-10-31 04:02 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Xlsx with some accepted and rejected changes. (20.89 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-02-05 13:20 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc. (308.99 KB, image/png)
2019-02-05 13:20 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-02-05 13:19:49 UTC
Description:
Accepting changes in Excel in a xlsx will show up as unaccepted changes in Calc, rejecting changes will show up as a change reverting back to before the change.

Steps to Reproduce:
    1. Create a new xlsx in Excel.
    2. Turn on change tracking.
    3. Make some changes.
    4. Reject some of them and accept the rest.
    5. Save and open in Calc.

Actual Results:
Actual results: The accepted changes show as unaccepted ones and the rejected one show as unaccepted changes reverting back to before the change.

Expected Results:
Expected results: Accepted changes should show as accepted changes and rejected ones should show as rejected in Calc.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2019-02-05 13:20:36 UTC
Created attachment 148913 [details]
Xlsx with some accepted and rejected changes.
Comment 2 NISZ LibreOffice Team 2019-02-05 13:20:52 UTC
Created attachment 148914 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 Durgapriyanka 2019-02-05 17:22:45 UTC
Thank you for reporting the bug. I confirm the bug in

Version: 6.3.0.0.alpha0+
Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 4 Xisco Faulí 2019-02-06 17:09:48 UTC
track changes for xlsx were added in https://cgit.freedesktop.org/libreoffice/core/commit/?id=b92fdaa1a40bd54d279b4ac2faf19bf15468cc2f
Comment 5 QA Administrators 2021-10-31 04:02:03 UTC Comment hidden (spam)