https://bugs.documentfoundation.org/show_bug.cgi?id=168612
--- Comment #8 from JJ <[email protected]> --- 'www.excel1040.com' (redirects to Google Sites) is Glenn Reeves' set of excellent, complex, multi-sheeted income-tax spreadsheets, and the problem described here is much like the one I encountered. In my case Calc hung (repeatedly) while saving to an .fods file. (Well, I didn't wait any 30 minutes, just killed LO after 10 minutes. Is that a legitimate "hang"?) In previous years saving took several minutes, but otherwise succeeded. This year I used LO 24.2.7.2 in an Ubuntu environment. The problem has gone away after upgrading to LO 25.8.2.2. It might be interesting to determine whether any intervening versions are susceptible to this, but the basic solution here is: upgrade. As to what was happening: googling "librecalc fails to save large fods file" (or similar) finds some interesting stuff. Like: "The most common reason for LibreOffice Calc failing to save large Flat OpenDocument Spreadsheet (.fods) files is memory exhaustion during the save process." "When you save a file in LibreOffice, it generates a massive temporary XML stream before compressing it. ..." (See https://ask.libreoffice.org/t/trouble-converting-large-excel-spreadsheet/90197/) The problem seems to involve two factors. First, Calc opens the file with the xlsx maximum number of rows (1,048,576) and columns (XFED -- 16,384?). Second, it appears that all those rows are given a height value, which amounts to about 80 chrs of xml code per row, and for each of some 60 sheets. Selecting that last million or so lines and setting the height to "Optimum" reportedly fixes the problem. (Well, for a single sheet.) (See https://superuser.com/questions/777279/openoffice-calc-reduce-file-size-when-saving-as-excel) So: perhaps this problem was just a passing glitch in version 24.2.7.2? But it seems to me that some attention ought to be given to why Calc opens with 1,048,576 rows. I suspect that Glenn's spreadsheets are the most complex that most of us encounter. Perhaps the LibreOffice folks would consider testing Calc on them. -- You are receiving this mail because: You are the assignee for the bug.
