Ah, I think I didn't state my problem clearly, as usual!
What I mean is, I want the cells of the bottom row to be offset by half a cell horizontally from those in the top row, so that the vertical borders of the top row come halfway across the cells of the bottom row.
(I'm doing a comparison of chronologies. Each cell width is to represent one year, but the starting point of the year for the bottom row is shifted by six months from the year start in the top row.)
Technically, it should be possible to merge cells alternately, but there'll be a heck of a lot of cells (as many as I can reasonably get on a landscape page and still have room for a few characters in each cell; I'll have to experiment, but I reckon at least 40 - 50 in a row) so unless there's a way of automating that, it's out of the question.
I'm guessing I'll have to have a separate table for each row; in principle that's not a problem; but I haven't worked out how to align the two tables (in writer); they seem always to expand to fill the page width and are quite difficult to resize afterwards. I'm guessing there must be a way to do this, I just haven't found it yet. If possible, I'd like to make the first cell of the row wider and have the rest adjust to a common width to the end of the table, but at the moment, at least, that's icing on the cake.
I've tried importing a selected row of cells from calc into draw to do this, in theory I think this ought to work well, but the problem I'm experiencing there is that cell size and formatting don't seem to be preserved when pasting the row.
I don't really mind how I achieve it, as long as it's not too tedious!
Thanks,
/Gary