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)
To tidy up the sample a bit more, in the sidebar, in Styles, select the Frame styles pane, right click TableHeading style, select Edit Style. In the dialogue that opens select the Transparency pane and set Transparency to 100%
Alright, so you’ve seen the tables I’m trying to make. For my test there, I just grabbed a long column with unformatted cells at the bottom to try to break it across pages in writer, but the actual goal is to have a tall table of the spell entries like you see nearer the top.
In writer, I can make this table, and if I remember my tests correctly, I think that the only way to, say, insert a new entry in the middle would be to:
Or I can just use calc, which is able to copy a spell entry row and paste it in the middle of the table, but then I don’t have a good space for preamble text.
I’m not seeing any better way to handle it than those two possibilities at the moment. Am I missing something?
You can retain more formatting, if you insert it into Writer as HTML. You will find this option in the drop-down list of the Paste icon.
Aye, I tried that, but the columns weren’t exactly the same width as they were in Calc, so I only tried it once.
It sounds like you need a database to manage overlapping groups. I can’t help with that
Alright, I’ll just use calc for this list for now then. Thanks.