https://bugs.documentfoundation.org/show_bug.cgi?id=167205
--- Comment #8 from [email protected] --- USER WORKAROUND Using the first step by step example of sheet of decimal numbers: The limit found for *.ods is 1000 columns by 31808 Rows (less than 200MB). For a file that is to store or examine or filter or display more, a workaround: 1. Open the .ods spreadsheet file that works. 2. Increase it's quantity of functions or data or both as usual. 3. File> Save As> name. . . .use V change from ODF to Office Open XML. 4. Confirm Use Office Open XML Spreadsheet Format 5. The file will save as type name.xlsx (and can go far larger) I've tested this as far as decimal numbers in an array 1000 columns by 90000 Rows; i.e. a block of 90 million cells (Calc 25.2.4.3). The file saves and opens without difficulty (465.3 MB) at more than twice the array of the *.ods version. I've tested it further as far as 1000 columns by 100 thousand and 200 thousand Rows (two hundred million cells occupied). The files save also (516 MB and 1GB respectively without Gen IO Error). However, after closing and reopening those two largest files, Calc starts with a new warning (on opening) that it finds corruption with an offer to repair the very large xlsx. Notes on the workaround: A message appears that the source *.ods file may contain formatting or content that cannot be saved in the xlsx format. There's work to do to check if this Workaround will be adequate. For example, in the case of medical research done here: 90 thousand rows of records suffice (so got lucky). Charts elsewhere keep their plotting and colours but lose the Data Label choice; xlsx places alternative symbols and numbers instead of the text. Both can be simplified or switched off and saved to avoid the nuisance. However, while using the file it's also possible to provisionally place the Data Label range back into the Chart parameters (takes a minute), see the names, study etc. That repair is lost at the next Save as xlsx yet is a very minor inconvenience; once Labels are up in RAM the full large xlsx study file is precisely the same use as for it's smaller *.ods source file (including Charts). I've learnt not much about what other content or format might get "lost". Formulae here are quite varied; statistics, indirect addressing, Truth tables and those all work just fine. I've not yet noticed a risk by switching to xlsx to get by (yet here all files will move back to ODF *.ods when this Bug is fixed). -- You are receiving this mail because: You are the assignee for the bug.
