Categories > OpenTBS with XLSX >

XLSX: use block=row to only merge a set number of columns (not the entire row with all columns)

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: John Lawler
Date: 2013-05-09
Time: 23:55

XLSX: use block=row to only merge a set number of columns (not the entire row with all columns)

Is there any straightforward way using OpenTBS in an XLSX to indicate that you want to fill in a number of rows, using a

[b.Column1;block=row]...[b.ColumnN]

simple approach, only you happen to also have other content in the XLSX to the left or the right of the range of cells you're trying to duplicate that you do *not* want to be duplicated?

E.g., I have a fairly simple document I'm trying to produce in Excel where I have one big table that works fine with regular block=row syntax, but then at the very end I have a couple of small summary tables which I would like to have side by side, only one of which has rows that need to be filled in in a block.  The other one just has some 'onload' variable insertions to do.

The way things are now, that other more static table gets rows duplicating over and over when the other small table is merged.

I realize what I'm doing is somewhat unusual, and that I could be doing this in Word instead with tables, but for various reasons I started the project in Excel and would rather stay there now that I'm near the end.

Thanks.