openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shan Zhu <>
Subject Re: [Calc][DISCUSS] What is your expected behavior when doing paste with a whole column or a whole sheet.
Date Wed, 13 Jun 2012 10:59:13 GMT
Hi, all
Repeated pasting is frequently used feature in Spreadsheet.
It can help user to format cells regularly, create assistant column for
sorting, etc.

In my view, Solution 1 can not resolve problem completely.
Because the whole sheet/column selection is not the only trigger that will
caused the poor performance and the crash.
The root cause is the quantity of cells in selected area.
It means that if user select a huge cell range (say, C1:AMJ65536), they
will encounter this issue as well.

I prefer Solution 2, if I have to make a choise.
The ideal solution is solving the performance and stability issues, it is
what I really want. : )


2012/6/13 Risto Jääskeläinen <>

> Hello!
> I have read response of Clarence GUO too and mostly agreed.  Solution 1 is
> better for macro scripts too, I guess.
> If user really want to fill whole column it will be still possible leaving
> last row out and hanling it specially.
> Greetings
> Risto
> Lei Wang [] kirjoitti:
>> Hi,
>> When I review bug i118863 (
>> 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).
>>  What is your opinion?

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message