I’m still trying to get complex tables to work in writer and tried pasting a table from calc. However, my column headers require spilling over into the next cell, and I can find no way to do that in writer. Can it be done without merging the cells?
Question 2: Can background color and other formatting be preserved when copying a table from calc? It even unmerged the tall cells in column 1; I manually combined them again before saving the test file.
Test2.odt (20.1 KB)
Why not just click Edit > Paste special > Paste special > LibreOffice xx.x Spreadsheet?
Test2_122976EA.odt (33.6 KB)
Ok that did work, so I guess I can just make my tables in calc and then paste special.
Welp, I tried editing it after pasting it and it just breaks again, so definitely all editing needs to be done in calc and then delete and re-paste any time I want to make a change. I wish there were better table handling in writer.
No. Just double click the table and edit it with Calc tools
I am not seeing how to get it to break across pages. Trying to paste a tall table squeezes it into one page.
Test2.odt (35.2 KB)
OLE objects are limited to the one page. You can make the page bigger, up to 6 m x 6 m, but printing might be a problem.
The problem I see is that the columns are not consistent, there are merged cells through them. They don’t work well in Calc either. The rest of the table looks as if it could easily be replicated in Writer with a normal page size.
If it is just the Heading rows that are the issue, you could merge the cells although merging cells always has drawbacks you could put the heading in frames, preferably using a frame style. Still have to delete the merged cell rows. You can have the first two rows repeated on every page
Test2_122976-2EA.odt (29.6 KB)