Issue 102591 - Paste special | Unformatted pastes formatted text
Summary: Paste special | Unformatted pastes formatted text
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 3.1
Hardware: Mac All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2009-06-08 10:55 UTC by ithinkihaveacat
Modified: 2010-01-09 18:19 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
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 ithinkihaveacat 2009-06-08 10:55:16 UTC 
To reproduce:

1. Copy (formatted) text from e.g. email.
2. Paste this (using standard paste) into a cell in a spreadsheet.
3. Formatted text appear.  Delete this text.  (i.e. to replicate making a mistake of accidentally pasting 
formatted text.)
4. Select Paste Special... from the edit menu.
5. Choose "Unformatted text" from the dialog box.
6. Choose "Okay".

Expected result:

Unformatted text appears.

Actual result:

Formatted text appears.

Example video:

http://screencast.com/t/wqdz9cQVDv

(Row 1 is some sample text; row 2 is pasted, deleted, special paste; row 3 is just special paste.)
Comment 1 ithinkihaveacat 2009-06-08 11:14:18 UTC 
A similar problem happens if you paste, then undo (ctrl-z), then paste special ... | Unformatted; see

http://screencast.com/t/oEBbl9rcqr
Comment 2 avagula 2009-06-09 06:04:07 UTC 
When you past unformatted text it grabs attributes that are currently active.
- first case: deleting text does not delete cell attribute, so the behaviour is
normal
- second case: undo inside cell doesnt delete attributes at cursor location and
this is not normal, ie. this may be an issue, but sure not P3
Comment 3 kpalagin 2009-06-10 08:48:23 UTC 
can't reproduce with m49 on WinXP.

ithinkihaveacat,
please try latest dev build (m49 at the moment).
Comment 4 Mechtilde 2010-01-09 18:19:17 UTC 
no response => invalid
Comment 5 Mechtilde 2010-01-09 18:19:50 UTC 
-> closed