Bug 34278

Summary:	Calc spreadsheets inserts into Writer as OLE instead as simple tables
Product:	LibreOffice	Reporter:	unggnu
Component:	Writer	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	enhancement	CC:	cno, sasha.libreoffice
Priority:	medium
Version:	3.3.0 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description unggnu 2011-02-14 14:17:15 UTC

If you paste a Calc spreadsheet in Writer it is not possible to stretch them over more than one page. Instead of being cut of at the bottom of the page and continued on the following one the table just uses all the available space on one page. I haven't tested it on my own but I am told that this problem doesn't appear in Excel.

Since this issue might be complicated to fix maybe there could be as a start an easy way to convert Calc spreadsheets to Writer ones so they could be stretched over more than one page. This would be fine for many people I suppose.

Comment 1 Björn Michaelsen 2011-12-23 11:49:43 UTC

[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html

Comment 2 sasha.libreoffice 2012-01-04 03:04:00 UTC

Some explanation:
We have 2 way to insert table into document: as OLE object and as RTF text. When we insert as OLE, than it my appear only on one page, both in Writer and in MSWord. And when insert as RTF text it appears in any number of pages, both in Writer and in MSWord. 
And now the problem: MSWord insert text by default as RTF and Writer as OLE. To insert into Writer as RTF, press Ctrl-Shivt-V and select RTF variant.

Comment 3 sasha.libreoffice 2012-01-04 03:08:17 UTC

My by it makes sense to add option to Writer to insert tables from Calc as RTF by default? Then this bugreport becomes feature request bugreport.

Comment 4 Cor Nouws 2012-02-06 01:21:27 UTC

I would suggest to close this one as not a bug.
THe solution is available: Paste special, as you said

Comment 5 sasha.libreoffice 2012-02-06 01:32:27 UTC

And how about comment 3?