From ooo-users-return-1868-apmail-incubator-ooo-users-archive=incubator.apache.org@incubator.apache.org Tue Jun 12 11:17:48 2012 Return-Path: X-Original-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 502B29155 for ; Tue, 12 Jun 2012 11:17:48 +0000 (UTC) Received: (qmail 28206 invoked by uid 500); 12 Jun 2012 11:17:48 -0000 Delivered-To: apmail-incubator-ooo-users-archive@incubator.apache.org Received: (qmail 28021 invoked by uid 500); 12 Jun 2012 11:17:44 -0000 Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-users@incubator.apache.org Delivered-To: mailing list ooo-users@incubator.apache.org Delivered-To: moderator for ooo-users@incubator.apache.org Received: (qmail 17060 invoked by uid 99); 12 Jun 2012 08:49:40 -0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lei.wang.leiw@gmail.com designates 209.85.210.47 as permitted sender) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=00COQMb7/MHGfCKQbtJIfiVS4+70OZuHGOJ6i7P/cMU=; b=IK6UODKOT4P/lHiR6yBibuDMsgo4uG5jdnW4OmpBl0nUpbqjFMTtsFwOnkyafoKylW /IOAztF7CktH37dVvf5RZn+AN3F7jKfcn0K2in+8jvYfSpEPnBnIgh5ErHpytyWoJPBP Su8SFnQnAeb3ATb2uJNBiVYJiXYErZ+0FRYYOopnicxu1UCQH5Fr5BpeOvngL2mnuqU8 H1RG+xlxwx2+OKI9A2af556Z+VfWX7m55uQGCbj8UEepRzBmXHxtdBMxxUg6w5uPayTx D7N/vufON4HTLeGCY87Ctlyw/tHK7/zRFzsRSC3xw5/0ESWvjmxxZP+IVI6yY+sanVIX fPew== MIME-Version: 1.0 Date: Tue, 12 Jun 2012 16:49:11 +0800 Message-ID: Subject: [Calc][DISCUSS] What is your expected behavior when doing paste with a whole column or a whole sheet. From: Lei Wang To: ooo-dev@incubator.apache.org, ooo-users@incubator.apache.org Content-Type: multipart/alternative; boundary=047d7b33d6505a872004c2428a6d --047d7b33d6505a872004c2428a6d Content-Type: text/plain; charset=ISO-8859-1 Hi, 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). What is your opinion? --047d7b33d6505a872004c2428a6d--