Issue 126004 - Selecting a column selects ~1048576 cells
Summary: Selecting a column selects ~1048576 cells
Status: CLOSED DUPLICATE of issue 74566
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2015-01-05 07:47 UTC by richardbaxter
Modified: 2017-05-20 09:52 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description richardbaxter 2015-01-05 07:47:22 UTC
Selecting a column selects ~1048576 cells. This means any operation (accidentally or intentionally) performed to a column;

a) can take 10 minutes to perform (assuming Calc doesn't crash in the process, and depending on the document size)
b) can take 10 minutes to revert (assuming Calc doesn't crash in the process), and;
c) may unnecessarily load the file with data (I have noticed calc become unusually slow to operate, eg scroll through some files, before; perhaps this is related)

An example of this issue would be if the user must insert 10 new columns into a 100 column spreadsheet and copy and paste the first cell of each respective preceding column into the first cell of each new column. It is difficult to perform this operation quickly without copying and pasting the cell contents into an entire selected column (for at least one of the new columns).

To replicate the issue;
1. create new calc document
2. enter "hello" into A1
4. copy the cell A1 (Ctrl-C)
5. select column B (by left clicking on column header "B")
6. paste (Ctrl-V)

Some notes;
- when the text contents is copied (and not the cell itself), the issue only occurs when the cell being copied and pasted contains a formula
- the time to execute the operation scales linearly(?) with number of columns/text in the document. 
- it appears to spend most of its time "Adapt[ing] row height".
- sometimes Calc will crash when performing the operation (irrespective of the file size), and sometimes it will not.
- on Linux, the runtime crash (/near infinite loop) can be terminated by executing "killall soffice.bin" in the shell
Comment 1 oooforum (fr) 2015-01-05 14:06:37 UTC
Tested with AOO 4.1.1 and Win7 x64 Pro
I don't reproduce any crash with your procedure.
Step 6 is done in less 1 sec.
If I extend with column C to F, pasting is done in 4 sec.
Comment 2 richardbaxter 2015-01-10 10:31:59 UTC
Thanks for looking into these issues I appreciate it.

I have confirmed this issue occurs on both Linux UB14.04 x86_64 (AAO 4.1.0) and MS Win8 x86_64 (AAO 4.1.1).

In order to trigger the bug, try entering a value instead of "hello" which is greater than the cell width, eg "atssdgdbadfbfd".

It takes around 3 minutes to fill the column on my system, and then Calc crashes when it is closed (on both Linux and Windows). When the bug is not triggered, it takes around 1 second to fill the column as you have indicated (depending on the system speed).
Comment 3 oooforum (fr) 2015-01-13 16:52:25 UTC
AOO freeze at "Adapt row height" step. 
See issue 74566 to enhance with an option to disabling this process.
Comment 4 oooforum (fr) 2015-03-05 09:16:28 UTC
Report vote or comment over there

*** This issue has been marked as a duplicate of issue 74566 ***