https://bugs.documentfoundation.org/show_bug.cgi?id=171404
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 CC| |[email protected] Status|UNCONFIRMED |NEW --- Comment #9 from ady <[email protected]> --- I think we need some real performance test, comparing the 2 cases (saving as ods vs saving as xlsx). CC'ing Xisco, any ideas? (In reply to m_a_riosv from comment #3) > Under Menu > Data > Consolidate, there are thousands of duplicate rows; > deleting them will resolve the issue. I don't understand. Why would that resolve the "save in ods format" issue? The specific data in the file that was previously attached in comment 1 is not relevant, as the OP removed the (private) information (and thus resulting in empty cells that are repeated row after row, instead of the original data, that would be different). For the consolidation to be relevant, that would mean actually deleting the "unused" rows, not in the dialog but in the original source of data. I assume that the OP does not want to delete the original real data – remember that the attachment does not include real data. I was able to replicate the issue (before the file in comment 1 was deleted); saving as ods takes much, much longer than saving as xlsx. Unless there is some feature that is not saved at all in xlsx file format (i.e. ignored at the time of saving), there is probably some performance issue and there might be something to improve, maybe. Maybe there is some issue with entire rows or entire columns being formatted, or referenced somewhere. Or perhaps the many VLOOKUP() functions? Would that imply such difference in saving times? Analyzing the case "manually" without having some clues would take a lot of time – there are 25 worksheets. Since 2 different users (plus the OP) have replicated the issue, I am setting this to NEW. -- You are receiving this mail because: You are the assignee for the bug.
