Created attachment 161631 [details]
Example file from Calc
Attached ods document has some simple formulae referencing each other. Calc can trace formula dependents/precedents and indicate these with arrows.
When saving the file to XLSX these arrows are saved as drawing objects and make the “Remove precedents” / “Remove dependents” commands unusable.
Steps to reproduce:
1. Open attached document
2. Save as XLSX, reload
3. Use Tools – Detective - “Remove precedents” / “Remove dependents”
Arrows are not removed.
No arrows saved to XLSX.
Version: 188.8.131.52.alpha0+ (x64)
Build ID: 191288d6a7fb52b31038a21c4e71ee57ffa3bacd
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Created attachment 161632 [details]
The original file saved by Calc
Created attachment 161633 [details]
Screenshot of the original and exported document side by side in Calc
Note: Solving this and the related one has to do with the ScDetectiveObjType enum.
In the ODF filter these seem to be checked and shapes having these are not exported as ODF shapes.
Created attachment 165129 [details]
How it looks with the proposed fix
Szabolcs Toth committed a patch related to this issue.
It has been pushed to "master":
tdf#133688 tdf#125414 XLSX: don't export tracer arrows
It will be available in 7.1.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.