https://bugs.documentfoundation.org/show_bug.cgi?id=167205
--- Comment #6 from Warren <[email protected]> --- On further testing I was able to reproduce the "Error on Save" using cells that had text and number contents though at a different total number of cells than the decimal only cells. Further the number of cells depends on the actual text within the cells which may indicate the issue is at a certain memory threshold in the background. For the attached file (36,722,019 cells text contents.ods) 36,722,019 cells will save OK. If you add contents to a new cell and try to save, an Error message will appears saying "General Error: General input/output error." This file was created using steps following the same pattern as the original decimal file - auto fill followed by copy and paste. Positioning of the final cell does not appear to matter Steps to Reproduce (based on the ones originally reported): 1. New empty Spreadsheet; in cell A1 type Text1 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 text contents.ods" (size should be 85.605 MB) 8. In the Input box type A1:ALL1000 which results in 1,000,000 cells being selected. Right click mouse that selection > copy 9. Click on empty cell A30001. Right click > Paste Result:31,000,000 cells 10.Click on empty cell A31001. Right click > Paste Result:32,000,000 cells 11.Click on empty cell A32001. Right click > Paste Result:33,000,000 cells 12.Click on empty cell A33001. Right click > Paste Result:34,000,000 cells 13.Click on empty cell A34001. Right click > Paste Result:35,000,000 cells 14.Click on empty cell A35001. Right click > Paste Result:36,000,000 cells 15. In the Input box type A1:ALL500 which results in 500,000 cells being selected. Right click mouse that selection > copy 16.Click on empty cell A36001. Right click > Paste Result:36,500,000 cells 17. In the Input box type A1:ALL100 which results in 100,000 cells being selected. Right click mouse that selection > copy 16.Click on empty cell A36501. Right click > Paste Result:36,600,000 cells 17.Click on empty cell A36601. Right click > Paste Result:36,700,000 cells 18. In the Input box type A1:ALL10 which results in 10,000 cells being selected. Right click mouse that selection > copy 19.Click on empty cell A36701. Right click > Paste Result:36,710,000 cells 20.Click on empty cell A36711. Right click > Paste Result:36,720,000 cells 21. In the Input box type A1:ALL1 which results in 1,000 cells being selected. Right click mouse that selection > copy 22.Click on empty cell A36721. Right click > Paste Result:36,721,000 cells 23.Click on empty cell A36722. Right click > Paste Result:36,722,000 cells 24. In the Input box type A1:AS1 which results in 19 cells being selected. Right click mouse that selection > copy 25.Click on empty cell A36723. Right click > Paste Result:36,722,019 cells Save file as 36,722,019 cells text contents.ods 26. Copy cell A1 and paste in cell T36723 or cell A36724 and Save file with name "36,722, 020 text contents.ods and should result in an Error message - note the file will be saved when you OK the Error message but will cause an error message if you close and reopen Calc and try to open that file. If the file is created slightly different the cell count where the Save Error appears is different. The following steps will create a File Save Error at 36,464,853 cells slightly less than above with very similar cell contents. Steps to Reproduce 1. New empty Spreadsheet; in cell A1 type Text1 Enter 2. Click again on A1 cell, then it's corner. Autofill across to ALL1 3. Click on corner again. Autofill down to A36464 (note I had to do this in steps) 4. In the Input box type A36464:AFT36464 which selects the first 852 cells in the last row 5. Click on the corner. Autofill down to A36465 6. File> Save As> "36,464,852_autofill_text&number_contents.ods" 7. Select cell AFU36464. click on the corner. Autofill down to AFU36465. 8. File> Save As> "36,464,853_autofill_text&number_contents.ods" - the file save should result in an Error dialog showing a message saying: Error saving the document 36,464,852_autofill_text&number_contents: General Error. General input/output error. Note that the name in the Error message is the old name and not the one just entered. I have attached the file I created as a seed file along with the first file in a zip file. Possibly related to the file size but for text and number files, though the number of filled cells is higher (than when using decimal cell values) the file size is less 104.565 MB for the first case above and 103.883 MB for the second case in Windows 7. Also in Windows 7 the file size did not change when the last 9 cells were filled for the first case and for the last 52 cells for the second case so possibly it is on a memory required change as the memory fills up. Wasn't sure if I should create a new bug as the file size and contents are different than original bug but the end result is the same so have added to the original bug. I have also added files that can be used as starting points (last good saves) in a zip file called Bug167295_textandnumber_seedfiles.zip -- You are receiving this mail because: You are the assignee for the bug.
