Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Cell cut does not display a dialog like that displayed for cell delete | ||
---|---|---|---|
Product: | Calc | Reporter: | burgesspa <philip.burgess.pb1> |
Component: | ui | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | gerhard.schaber, issues |
Version: | OOo 2.0.2 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
burgesspa
2006-05-04 15:04:00 UTC
Hi, not a defect as Cut and delete are different operations. Del erases parts or all of the cell content, cut copys all of the cell into the clipboard and than erases the content from the cell. If you just want to remove a style or the cell formatting, just assign the default style to the cell or the one you want to use. Frank closed invalid You seem to have misunderstood the issue: "If you just want to remove a style or the cell formatting ...". I want to KEEP the style formatting when doing a cut. Delete provides a dialog box so I can choose to keep the style. But cut does not provide the choice. I see someone has voted for this issue, so I suppose there are other persons who find this annoying. Here is another way to look at the issue. If I set up a spreadsheet using the nice Ooo style defining facilities to define nice fonts, character sizes, number of decimal places for numbers etc. etc., why should I want to remove the style definition from a cell when I do a cut and have it set to "Default"? I usually just want to move cell contents (i.e. the numbers or equations) from one place to another. I ALWAYS want the source cells to keep their defined styles. If I want to change the style of the cell then I would do exactly that: change the style. If the Ooo cut function continues to do a style delete then to me I see no point in having the nice style defintion functionality which is a part of Calc, since everytime a user does a cut they will have to define the style again of the cell, or will have to do the proposed workaround: cut then paste then delete. I took a new look at Excel (version 2002 (10)), and yes Cut also deletes the defined style, and sets it to "Normal". But then as far as I know I cannot define new styles in Excel, I have to change one of the existing styles such as Normal, so it is much less powerful than Calc. So Calc needs an appropriate cut function to complement this power. In Excel I do not notice the issue because I am stuck with a fixed set of styles. Also Excel is different from Ooo in that it does not display a dialog box when deleting a cell, it just does the delete. So if in your specification it says that Calc must clone the functions of Excel, then I suggest this issue is changed to an enhancement. Proposal for enhancement: 1) The cut/copy/delete functions should all give a dialog like the delete function so I can choose what is cut/copied/deleted from the cell. When the data is pasted again it should only paste what was included. e.g. if the styles were not included then the paste will not change the style of the destination cells. 2) I should be able to configure a default selection of elements to include so that the cut/copy/delete function does not display a dialog box. I personally would configure it never to include styles in the copy, so they are neither changed when a cut or delete is performed nor when something is pasted. 3) as a general rule I would prefer that only content is copied/pasted and not the cell style. Ok, let's requirements decide. Frank Yes, please provide at least one of the three proposed solutions. The current behaviour can be annoying. If you do not want to lose the style of a cell (including conditional formatting), you currently need to copy the cell, delete it, and then paste it somewhere else. You cannot use the cut command at all in this case. Best regards, Gerhard BTW, another issue regarding cut and paste is 28411. |