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” Actual results: Arrows are not removed. Expected results: No arrows saved to XLSX. LibreOffice details: Version: 7.1.0.0.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 Calc: CL
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. https://opengrok.libreoffice.org/xref/core/sc/inc/detfunc.hxx?r=9d4c36d7#39
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": https://git.libreoffice.org/core/commit/14b40ec7be7ca8315848034591e3c3a246d5a8dd 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.