https://bugs.documentfoundation.org/show_bug.cgi?id=167205
--- Comment #16 from [email protected] --- USER NOTES If reading because of General Input/Output Error on a file, pre-release 25.8.3.1 resolves one cause (saving a sheet with many cells occupied - the Count). That affected the zipped ods or xlsx saved size (in MB), then being able to open it again. The maximum varied due to whether only decimal numbers or mixtures with texts, functions or charts. A file of integers only (for example half billion cells occupied) is very small in comparison (compact when zipped to only 3MB). 1. File .ods size was limited to around 185MB for a successful save and reopen. 25.8.3.1 .ods tested now saving and opening files up to 1.4 GB (240 million cells of decimal numbers). 2. File .xlsx size was larger cell capacity (Count) yet limited also in MB. 25.8.3.1 .xlsx tested now saving and opening files up to 1.9 GB (360 million cells of decimal numbers). 3. Making use of Calc at those file sizes requires at least 32GB RAM. The original Bug report was raised because in research here, much parsing of .csv data is done, followed by Statistics exponential filtering (engineering). For quality control, selected series need be plotted and always able to inspect any single cell value. SCILABS, Paraview, Base are less suitable. Calc (and it's Charts at 4K resolution) is perfect for this heavy and crucial task. >From there, validated data is passed onto smaller Calc files (often, not always by links) for Signal Processing. 3. Using the new maximum data file size with links to other dependent user files requires 64 GB of RAM. Any questions, please ask. After testing the 25.8.3.1 Release, it's intended to see if this news might help on Ask Libreoffice somewhere (one cause of General Input/Output Error). Resolved. -- You are receiving this mail because: You are the assignee for the bug.
