Issue 67805 - Cut, copy & pasted shouldn't take the formatting by default
Summary: Cut, copy & pasted shouldn't take the formatting by default
Status: CLOSED DUPLICATE of issue 17563
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: requirements
QA Contact: issues@sc
URL:
Keywords:
Depends on: 17563
Blocks:
  Show dependency tree
 
Reported: 2006-07-26 17:25 UTC by phervas
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description phervas 2006-07-26 17:25:30 UTC 
When you cut a cell, it cuts the contents and also the formatting, leaving a
blank cell. When you copy a cell and paste it, it will also paste de formatting
by default.
I believe that the default cut behavior shuould only cut contents. The default
copy behavior should only copy contents. If we want also the formatting we could
do a paste special.
The problem is when working with already formatted spreadsheets, cutting,
copying and pasting becomes a nightmare.
Comment 1 phervas 2006-08-10 15:50:09 UTC 
Does anybody agree with me ? Or, is the actual functionality better ?
Any comments ?
Comment 2 frank 2006-08-31 13:59:27 UTC 
Hi,

this is something for the requirements team. IMO it would be a nightmare if only
the coontent of a cell is copied. In most cases the format is copied is needed
also in the resulting cell. In the rare cases this is not needed, you may use
Paste Special which can be easily called by CTRL+SHIFT+V.

Frank
Comment 3 phervas 2006-09-05 16:54:28 UTC 
I totally disagree with you in this issue. While I agree that formatting is very
important, content is the most important thing. So default behavior of cut
should cut only the contents. Right now, lets say you have a grid of data with a
lot of formatting (borders, shadows, font-colors, etc) if you cut one cell to
another inside the grid, you will end up with a white cell with no formatting.
In this case what you ment was to copy the data, but you ended up having to
format that cell again.
I believe paste special should be used to paste the formatting also if you want,
but not the other way around as you say.
What I mean is that OOo should behave like Excel in this case, which I believe
is a more logical approach than the actual behavior.
Comment 4 phervas 2006-09-05 16:55:18 UTC 
I totally disagree with you in this issue. While I agree that formatting is very
important, content is the most important thing. So default behavior of cut
should cut only the contents. Right now, lets say you have a grid of data with a
lot of formatting (borders, shadows, font-colors, etc) if you cut one cell to
another inside the grid, you will end up with a white cell with no formatting.
In this case what you ment was to copy the data, but you ended up having to
format that cell again.
I believe paste special should be used to paste the formatting also if you want,
but not the other way around as you say.
What I mean is that OOo should behave like Excel in this case, which I believe
is a more logical approach than the actual behavior.
Comment 5 phervas 2006-09-05 16:55:43 UTC 
I totally disagree with you in this issue. While I agree that formatting is very
important, content is the most important thing. So default behavior of cut
should cut only the contents. Right now, lets say you have a grid of data with a
lot of formatting (borders, shadows, font-colors, etc) if you cut one cell to
another inside the grid, you will end up with a white cell with no formatting.
In this case what you ment was to copy the data, but you ended up having to
format that cell again.
I believe paste special should be used to paste the formatting also if you want,
but not the other way around as you say.
What I mean is that OOo should behave like Excel in this case, which I believe
is a more logical approach than the actual behavior.
Comment 6 phervas 2006-09-05 16:56:46 UTC 
sorry, i posted it 3 times, something was wrong with my browser
Comment 7 moxfox 2007-07-17 19:38:24 UTC 
The pasting (unformatted) part of this issue will work via a shortcut, once issue 17563 is done.
Comment 8 moxfox 2009-03-02 20:00:32 UTC 
Making paste unformatted the default paste style is not really going to happen ever.

But the (different) shortcut for paste unformatted is provided in issue 17563.
Marking this as duplicate.

*** This issue has been marked as a duplicate of 17563 ***
Comment 9 Mechtilde 2009-07-12 17:52:37 UTC 
duplicate -> closed