Issue 100706 - Paste Special - please allow to independently select link and format
Summary: Paste Special - please allow to independently select link and format
Alias: None
Product: Writer
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo, oooqa
Depends on:
Reported: 2009-03-31 11:06 UTC by kpalagin
Modified: 2013-08-07 14:38 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description kpalagin 2009-03-31 11:06:44 UTC
When pasting from Calc to Writer there is no option to link and retain format 
(or paste unformatted). Instead you get unformatted text in table, which is 
useless in majority of usage cases.
Please allow to select linking independently from format, preferably across 
all of OO applications.
Comment 1 eric.savary 2009-03-31 11:13:53 UTC
I don't understand your request.
You want to keep the format OR paste unformatted AND/OR link the data?
Link -> Paste special: DDE Link/OLE object
Format -> Paste special: RTF, HTML, OLE object
Non format -> Paste special: Unformatted text.

Please explain.
Comment 2 kpalagin 2009-03-31 11:50:07 UTC
I want to paste link AND choose format. Repro:
1. Start Calc, type some text in any cell, apply some formatting.
2. Click Edit-Copy.
3. Start Writer, click Edit-Paste Special, select DDE Link, OK - you get 
unformatted text in table.
There are cases when I do want formatting to be included and in majority of 
cases I do not want table.
Comment 3 eric.savary 2009-03-31 13:23:30 UTC
Well after a short discussion with the DEV, I think we won't ever implement this
(balance effort/gain).

Such a clipboard format would mean that every cell would be transformed in to a
text field.
For now, a DDE field can only handle a range of cells0 and not every cell

And even if....
Selecting a row in Calc would give you Field1Field2Field3Field4 (without
separator) in Writer.

Selecting a column in Calc would ALSO give you Field1Field2Filed3Field4 (without
separator) in Writer. Or maybe there should be a paragraph mark between the
fields in this case...

Nonetheless, reassigning... Who knows...
Comment 4 kpalagin 2009-03-31 15:45:53 UTC
do you think that single-cell DDE link can be made special case and be pasted 
as text and not table?
Comment 5 eric.savary 2009-03-31 15:56:43 UTC
Well (currently) pasted not.
But a dirty workaround is to:
- copy/paste as DDE
- Ctrl+F2 -> Variables TabPages
(you should see the DDE link you have copied)
- Click "Insert"
-> You get the link to the cell value as text field.