https://bugs.documentfoundation.org/show_bug.cgi?id=171404
--- Comment #15 from Jordi PAPA <[email protected]> --- (In reply to Regina Henschel from comment #12) > Excel does not support <table:consolidation>, thus there exists no part in > export, that writes these values. Writing to xlsx, reopen the xlsx and then > saving to ods will remove <table:consolidation>. Or manually remove the > element from content.xml. > > For ods it is written in > 5163 void ScXMLExport::WriteConsolidation(const ScDocument& rDoc) > in > https://opengrok.libreoffice.org/xref/core/sc/source/filter/xml/xmlexprt.cxx > > Why does the document contains "consolidation" at all? Thank you, Regina, for your excellent solution for permanently removing the consolidation settings from my annual workbooks. I followed your instructions with my .ODS workbook: 1) “Save As” (Ctrl + Shift + S) in .XLSX format; 2) DON'T FORGET to close the .XLSX workbook (otherwise the consolidation settings will be retained); 3) Reopen the .XLSX workbook; 4) “Save As” (Ctrl + Shift + S) in .ODS format. Result: the consolidation settings are permanently removed and are no longer recreated with every save; consequently, saving the workbook and the recovery information now works smoothly, and I can work without any issues. -- You are receiving this mail because: You are the assignee for the bug.
