incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 118863] [From Symphony] Calc stop responding if paste merged celss to a column
Date Tue, 12 Jun 2012 08:52:02 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=118863

--- Comment #4 from Wang Lei <leiw@apache.org> ---
When I review bug i118863
(https://issues.apache.org/ooo/show_bug.cgi?id=118863), I find there are some
other related user cases which can get AOO crash or freeze.

Scenario 1
1)New a calc doc.
2)Input 1, 2, 3 in cell A1, A2, A3
3)Set background color for cell A1, A2, A3 as blue, green, red
4)Select A1:A3, and copy
5)Select a whole columnm, such as column E, and paste

AOO need more than 5 minutes to complete this work.
6)undo the paste
AOO also need a lot of time

Scenario 2
1)New a calc doc.
2)Input 1, 2, 3 in cell A1, A2, A3
3)Select A1:A3, and copy
4)Select another whole sheet, such as "sheet2", and paste

AOO will crash


Now Calc supoorts 1,048,576 rows * 1024 columns, which is 1,073,741,824 cells.
Pasting with a whole column selected will fill the column. Pasting with a whole
sheet selected will fill the sheet, which always casue AOO crash.

I have two suggestions

Solution 1
Disable auto repeat to fill cells when pasting with a whole column/sheet
selected. Considering user may not want to repeat to fill the cells when
pasting with a whole column/sheet selected, just paste the source data and do
not repeat to fill.

Excel has a strange behavior. It will not repeat to fill cells, if the cell
numbers in target range is not integer multiple of the source data.
For an example,
Copy A1:A2, Select B1:B10, Ctrl+V -> B1:B10 will be filled
Copy A1:A2, Select B1:B11, Ctrl+V -> Only B1:B2 will be filled
So when pasting with a whole column/sheet selected, sometimes Excel will repeat
to fill the whole column/sheet, sometimes it will not.


Solution 2
Set two thresholds, one is for warning user, one is for the limitation.
If number of cells in target range is bigger than warning threshold, Calc will
popup a warning message to warn user the potential bad performance. If number
of cells in target range is bigger than limitation, Calc will popup a error
message to info user the operation can not be completed.

The purpose of Solution 1/Solution 2 is to avoid making Calc crash for careless
operation(paste with a whole column/sheet selected).

This is a great patch to improve the performance. But if we change the
behavior, the improvement may not useful.

What is your opinion?

-- 
You are receiving this mail because:
You are the assignee for the bug.

Mime
View raw message