Apache OpenOffice (AOO) Bugzilla – Issue 53132
Pasting from Calc should ask how
Last modified: 2013-02-07 22:34:14 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/ unprintable. 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. Solution: 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). Cheers -- David
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.
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
OpenOffice.org 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: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ 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: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html