I've been dealing with this problem for years and i'm fed up.
Whenever you select a column and apply some sort of format (god forbid you try to do it with an autoformat) the application doesn't limit itself to just the cells with data and then remember to autoapply the format to any new cells in the work area but rather just goes and applies the format to all the cells in the row from 0 to the maximum cell value.
This results in the program freezing until it's able to process all billion cells and the file becoming several gigabytes in size for something as simple as trying to apply a format to a column.
This is not acceptable, the amount of times I had to force quit the app and redo work because I forget libre office (and only libre office) has this quirk is more than I would like to have happened.
At worst the user should have a confirmation dialogue pop up when the user tries to modify 500k+ cells in a single operation (changing it's formatting in this case), at best the excel logic should be replicated where the format is applied to any already "existing" cell and then any cell currently in the viewport (without actually commiting it to the file until data is added to said cell) or any new cell added to the format range.
I've been dealing with this problem for years and i'm fed up.
Whenever you select a column and apply some sort of format (god forbid you try to do it with an autoformat) the application doesn't limit itself to just the cells with data and then remember to autoapply the format to any new cells in the work area but rather just goes and applies the format to all the cells in the row from 0 to the maximum cell value.
This results in the program freezing until it's able to process all billion cells and the file becoming several gigabytes in size for something as simple as trying to apply a format to a column.
This is not acceptable, the amount of times I had to force quit the app and redo work because I forget libre office (and only libre office) has this quirk is more than I would like to have happened.
At worst the user should have a confirmation dialogue pop up when the user tries to modify 500k+ cells in a single operation (changing it's formatting in this case), at best the excel logic should be replicated where the format is applied to any already "existing" cell and then any cell currently in the viewport (without actually commiting it to the file until data is added to said cell) or any new cell added to the format range.