Issue 53132 - Pasting from Calc should ask how
Summary: Pasting from Calc should ask how
Alias: None
Product: Writer
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-08-10 03:12 UTC by david
Modified: 2013-02-07 22:34 UTC (History)
1 user (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 david 2005-08-10 03:12:38 UTC
When you paste alot of Calc rows into Writer you can't see them all unless you 
shrink all, say, 1000 lines down to 2% to fit one page making them unreadable/

I assume this is necessary to retain Calc's spreadsheet functionality within 
Writer on those rows/cells - if it's possible to embed as spreadsheet but still 
split it up into several pages it would be great.

Make two paste functions for pasting from Calc - one for pasting as table and 
one for pasting as embedded spreadsheet. Or you simply ask the user how with 
three buttons named "Paste as table", "Embed as one Spreadsheet" and "Embed as 
spreadsheet allow splittng". This makes it possible to paste the rows as a table 
without scaling it and with the ability to edit it like text (e.g. search and 
change styles - which is much needed as it's impossible within Calc - so the 
user must use Microsoft Word to search/replace styles in a Calc spreadsheet 
copying into Word and then back into Calc).

-- David
Comment 1 michael.ruess 2005-08-10 10:33:46 UTC
One possibility already exists: you can paste the content into Writer via
"Edit.Paste special" (or do a long-click on Paste-button). There, choose
"Formatted text" and this will insert the Spreadsheet content as a Writer-Table.

However, to make the use easier, it could be good to ask the user before pasting
large spreadsheets (about 35 rows or more) into a Writer document via a dialog.
I't looks, that not everyone knows about the "Paste special" option, means it is
not intuitive enough.
Comment 2 david 2005-08-10 16:41:15 UTC
I agree. However the row counts should not be used for deciding wether to ask or 
not. If it makes sense to only ask if there are too many rows you should make it 
depend on the unscaled length of the spreadsheet rows. If it's longer than the 
current page in Writer it should ask wether to split it up if needed.

-- David
Comment 3 ace_dent 2008-05-16 00:51:46 UTC Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 3 years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~