[Libreoffice-bugs] [Bug 137527] New: FILESAVE LibreOffice Calc advertised as 1024 columns and 1048576 rows appears to be a limit of between 11 534 336 and 13 037 568 active cells that will save to disc.

Fri Oct 16 11:33:33 UTC 2020

https://bugs.documentfoundation.org/show_bug.cgi?id=137527

            Bug ID: 137527
           Summary: FILESAVE LibreOffice Calc advertised as 1024 columns
                    and 1048576 rows appears to be a limit of between 11
                    534 336 and 13 037 568 active cells that will save to
                    disc.
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: willim.walker at aim.com

Description:
Linux Mint 20 16GiB Memory 2.0GiB Swap
Calc Build ID 1:6.4.6-0ubuntu0.20.04.1

>From my tests there seems to be a limit of between 11 534 336 and 13 037 568
active cells that will save to disc.  More can be displayed but don't save -
Calc is terminated and file has to be recovered

>From variation in file size 56.7Mb 120.1Mb I doubt if it is a file size
restriction, I could be wrong.

if A -AMJ filled only 12732 rows 120.1Mb  13_037_568 cells
A1=1 B1=A1+10 C1=B1+10    ... AMJ1=AMI1+10
A2=A1+1 B2=B1+1 C2=C1+1 ... AMJ2=AMJ1+1
row 2 copied to rows 3 - 12732

if A1 - A1048576 filled only to column K 56.7Mb 11_534_336 cells
column B copied to columns C to K 
A1=1                          B1=A1+1
A2=A1+1                   B2=B2+1 
A3=A2+1                  B3=A3+1
A1048576=A1048575+1   B1048576=A1048576+1

A1 can be changed to say 10 file saves and can be changed to 1 again 
with no issues if 12732 rows or K columns

Further tests and summary

12732  AMJ (1024) 13_037_568 120.1MB
25347  SR  (512)  12_973_056 117.8MB
50601  IV  (256)  12_956_160 117.3MB
100810 DX  (128)  12_903_680 108.7MB
198896 BL  ( 64)  12_729_344 102.5MB

Working downwards Columns halved and Rows duplicated 

262144  AV (48)   12_582_912  61.0MB
524288  X  (24)   12_582_912  61.6MB
1048576 K  (11)   11_534_336  56.5MB

Working upwards Rows halved and Columns duplicated

Cannot copy row 50601 to 50602 or column AV to AW ...

Additional rows/columns are calculated properly but do NOT save to disc.

When document is recovered it is only to last "Save"

Steps to Reproduce:
First Spreadsheet
if A -AMJ filled only 12732 rows 120.1Mb  13_037_568 cells
A1=1 B1=A1+10 C1=B1+10    ... AMJ1=AMI1+10
A2=A1+1 B2=B1+1 C2=C1+1 ... AMJ2=AMJ1+1
row 2 copied to rows 3 - 12732

Failure when try to save row 12733 ..

on second spreadsheet

if A1 - A1048576 filled only to column K 56.7Mb 11_534_336 cells
column B copied to columns C to K 
A1=1                          B1=A1+1
A2=A1+1                   B2=B2+1 
A3=A2+1                  B3=A3+1
A1048576=A1048575+1   B1048576=A1048576+1

A1 can be changed to say 10 file saves and can be changed to 1 again 
with no issues if 12732 rows or K columns

Failure when trying to save column K

Actual Results:
On attempting to save additional row / column
LibreOffice 6.4 Document Recovery
Due to an error, LibreOffice crashed. All the files you were working on will
now be saved. The next time LibreOffice is launched, you files will be
recovered automatically.

Only recovers to last "Save" no point in "Recovery"

Expected Results:
File saved and continue 

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: 6.4.6.2
Build ID: 1:6.4.6-0ubuntu0.20.04.1
CPU threads: 12; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); UI-Language: en-GB
Calc: threaded

OpenGL vendor string: X.Org
OpenGL renderer string: Radeon RX 570 Series (POLARIS10, DRM 3.35.0,
5.4.0-51-generic, LLVM 10.0.0)
OpenGL core profile version string: 4.6 (Core Profile) Mesa 20.0.8
OpenGL core profile shading language version string: 4.60
OpenGL core profile context flags: (none)
OpenGL core profile profile mask: core profile
OpenGL core profile extensions:
OpenGL version string: 4.6 (Compatibility Profile) Mesa 20.0.8
OpenGL shading language version string: 4.60
OpenGL context flags: (none)
OpenGL profile mask: compatibility profile
OpenGL extensions:
OpenGL ES profile version string: OpenGL ES 3.2 Mesa 20.0.8
OpenGL ES profile shading language version string: OpenGL ES GLSL ES 3.20
OpenGL ES profile extensions:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201016/fd146647/attachment-0001.htm>