To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=65086
User burgesspa changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Issue type|DEFECT |ENHANCEMENT
--------------------------------------------------------------------------------
Resolution|INVALID |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Jul 3 06:44:58 -0700
2006 -------
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.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
