Apache OpenOffice (AOO) Bugzilla – Issue 126785
Saving Large File Crashes
Last modified: 2017-05-20 11:55:33 UTC
Hello, fan of the project. I had a large file approximately 77,000 rows by 20 columns. No fancy formats or anything, just numbers and text entries. I tried to save it and the program crashed, permanently losing the file. I cannot attach anything because the file is gone. I am going to work around this by assuming I can never save a large document in Open Office and just copying the data into a text file. I just thought the issue should be brought to your attention. Cheers! :)
Hello, we need more information to help you. is your issue reproducible? steps would be very helpful do you have any (not sensitive) raw data to fill such a table? e.g said text file Why do you think it related to the file size? Are you sure it not just slow? What file format are you trying to save? xls supports only 65536 rows (but should give a warning about that)
(In reply to ericjohnhofmann from comment #0) > Hello, fan of the project. I had a large file approximately 77,000 rows by > 20 columns. No fancy formats or anything, just numbers and text entries. I > tried to save it and the program crashed, permanently losing the file. I > cannot attach anything because the file is gone. > > I am going to work around this by assuming I can never save a large document > in Open Office and just copying the data into a text file. I just thought > the issue should be brought to your attention. Cheers! :) Hi. We have not updated the information on maximum sizes for Calc for the 4.x series but I suspect the maximum number of rows is still the same as what is listed on this page: https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What%27s_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F We will make every effort to dig into the code for 4.x and update this information.
(In reply to Kay from comment #2) > (In reply to ericjohnhofmann from comment #0) > > Hello, fan of the project. I had a large file approximately 77,000 rows by > > 20 columns. No fancy formats or anything, just numbers and text entries. I > > tried to save it and the program crashed, permanently losing the file. I > > cannot attach anything because the file is gone. > > > > I am going to work around this by assuming I can never save a large document > > in Open Office and just copying the data into a text file. I just thought > > the issue should be brought to your attention. Cheers! :) > > Hi. > We have not updated the information on maximum sizes for Calc for the 4.x > series but I suspect the maximum number of rows is still the same as what is > listed on this page: > > https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/ > What%27s_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F > > We will make every effort to dig into the code for 4.x and update this > information. I see, thanks! Clearly I exceeded the maximum number and so I won't do that anymore.
(In reply to ericjohnhofmann from comment #3) > I see, thanks! Clearly I exceeded the maximum number and so I won't do that > anymore. I updated the wiki page. the row limit is 1,048,576 since version 3.3 when I tried to reproduce your issue with a sheet of 77000x20 random numbers it saved and opened fine as ods file.