Description: Decimal numbers are used to create a sheet for reproducing a Bug. A maximum size array of only numbers is found; further pasting into only one more cell causes General Input/Output Error. Steps to Reproduce: 1. New empty Spreadsheet; in cell A1 type decimal number 1.1 Enter 2. Click again on A1 cell, then it's corner. Autofill down to A10000 3. Click on corner again. Autofill across to ALL10000 4. Selection is A1:ALL10000. Right Click mouse that selection > Copy 5. Click on empty cell A10001. Right Click, Paste 6. Click on empty cell A20001. Right Click, Paste 7. File> Save As> "30 million block.ods" (size should be 176.3 MB) 8. Click on empty cell A30001. Right Click, Paste 9. File> Save As> "40 million block.ods": The File will save damaged with the message "General Input Output Error" 10. Restart Calc and again Open "30 million block.ods" 11. Click hold A1 then mouse down to highlight A1:A1808 12. Ctrl+Shift+> to fully select A1:ALL1808 13. Click right Copy that selection 14. Click on empty cell A30001. Right Click, Paste 15. File> Save As> "31808 Rows by Copy and Paste.ods" (size is 186.9 MB) 16. Click hold A1809 then mouse across to select only A1809:TJ1809. 17. Click Right to copy that selection (limited to part of a row, Count 530) 18. Click on empty cell A31809 and right click Paste 19. File Save as "31808530 cells by Copy and Paste.ods" This creates the maximum occupied testing area before Errors occur 20. Click on TK1809: Right Click Copy. 21. Click on empty cell at the bottom TK31809 then Right Click Paste 22. File> Save As> "31808531 cells by Copy and Paste.ods". The file will save damaged "General Input Output Error" Actual Results: A sheet of only decimal values in a limited area can become larger yet the User is unaware that the File will be damaged when saved. General Input/Output Error message is given, the File is saved and may be repairable. Expected Results: File Save without damage. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 25.2.4.3 (X86_64) / LibreOffice Community Build ID: 33e196637044ead23f5c3226cde09b47731f7e27 CPU threads: 12; OS: Linux 6.11; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded
The above test file can be generated by autofilling A1:ALL10000 then copying and pasting that block then parts of that block down to Row 31808. The full table is then A1:ALL31808. It is then only possible to paste 530 values more; in A31809:TJ31809. Any more cells with values causes a damaged file when saved. Because the block copy paste method was used, the maximum value anywhere in the spreadsheet is 10999.1 To test if the File Save procedure is producing General Input Output Errors for varying reasons; one might be the process of detecting continguous columns of data to compact the eventual file size. This additional procedure generates a file that reproduces the Error yet this time by only autofilling (without copying pasting). The result is a smaller table of numbers that can be saved before General Input/Output Errors occur. Maximum value anywhere in this new spreadsheet becomes 32481.1 1. New Spreadsheet. Click on cell A1 and enter value 1.1 2. Click on cell A1 and click the corner dragging down autofill to A1:A31478 3. Click the corner A31478 to autofill right until ZZ31478 (then release) This is because autofill has limits to what it can follow 4. Click on ZZ1. Then Ctrl+Shift+v to select full ZZ column down to ZZ31478. 5. Click corner; drag autofill right again until ALL31478 (has value 32477.1) 6. File> Save As> "A1 to ALL31478 autofilled.ods". This is the starting square table available before Errors 7. Click on A31478 then Ctrl+Shift+> to select that bottom row A31478:ALL31478 8. Click corner to autofill down to learn/test, using File>Save As each time. 9. Here, autofill further down to Row 31482 then File>Save is successful 10. Here, autofill further down to Row 31483 causes File>Save General Input Output Error The first test file with copied and pasted blocks (using lower decimal values) works until row 31809 This new generated file with autofilled all columns (causing greater decimal values) works until row 31482
The result is reproducible (same cell limit 31808530) with this Version: 7.3.0.1 (x64) / LibreOffice Community Build ID: 840fe2f57ae5ad80d62bfa6e25550cb10ddabd1d CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL
Tested LO 5.4.7.2 No Bug LO 6.0.0.1 No Bug LO 6.2.8.2 No Bug LO 6.3.0.0 alpha1 No Bug; tested saving 100 million values LO 6.3.0.0 beta1 Crashes when saving 20 million values in A1:ALL20000 LO 6.3.0.0 beta2 Crashes as above LO 6.3.0.4 Crashes as above LO 6.3.2.1 Crashes as above LO 6.3.4.1 Crashes as above LO 6.3.6.2 Crashes as above LO 6.4.7.2 Crashes as above LO 7.0.0.0 alpha1 Gen Input/Output Error Bug Step 22 saving 31808531 values LO 7.0.0.1 Gen Input/Output Error as above LO 7.2.2.2 Gen Input/Output Error as above LO 7.3.0.1 Gen Input/Output Error as above LO 25.2.4.3 Gen Input/Output Error as above Last known version to work here (without Bug when saving a table of decimal numbers) is Version: 6.3.0.0.alpha1 (x64) Build ID: 547edd20e527fb02900f6174973770d26306e2e7 CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: threaded Generating a 50 or 100 million cell table can be saved with 6.3.0.0alpha1 However using a later version of Calc to open that file (using 7.3.0.1 here) it fails to open, showing message "Read Error. Format error discovered in the file in sub-document content.xml at 2,-1837072437(row,col)." Is that a clue? A negative Column number?