Using large files - Examples |
For 20 million sample formulas with cells filled from B2 to the right and downwards so that
B2: =b1+c1+d1+e1, C2: =C1+D1+E1+F1, D2: =D1+E1+F1+G1
B3: =B2+C2+D2+E2, C3: =C2+D2+E2+F2, D3: =D2+E2+F2+G2
and the last bottom-right cell:
U1000001 =U1000000+V1000000+W1000000+X1000000
GS-Calc saves it as a 8KB file (as it detects patterns in cells to compress). Saving and loading takes about 5s on a low-end office pc.