https://bugs.documentfoundation.org/show_bug.cgi?id=171404
--- Comment #11 from Jordi PAPA <[email protected]> --- (In reply to ady from comment #9) > 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. Thanks, Ady, for your input. In my workbook, I don't want to perform any consolidation. I didn't enter the values in the Data > Consolidate menu. I checked the data in the ranges involved in the consolidation, and I didn't see anything suspicious. It's not a problem with empty data. In the worksheets, I even deleted the affected ranges and created new ones for my usual workbook calculations: it didn't change anything; the two bugs are still there. I noticed that the repeated rows exclusively reference cell "A1" from the first worksheet (="TvxAscenseur"). After deleting these rows, I inserted a new worksheet at the beginning of the workbook ("Sheet25") and then saved the workbook. The unexpected result: now the reference "Sheet25.A1" is repeated many times for the consolidation data target. This is therefore proof that the new versions of LIBREOFFICE invent values for consolidation data, by interpreting old deleted values = the reference to the first cell of the first sheet of the workbook. -- You are receiving this mail because: You are the assignee for the bug.
