Filling a pre-existing table

Hi

Is there a possibility to fill a pre-existing table in xlsx?

I currently have in 1st table row but after merging data - table dimension does not change and data is overflowing table boundary. :(

Hi Jo,

There is no OpenTBS solution for this problem for now. We are working on it.
All ranges keeps defined with absolute position as in the original template.

See the XLSX demo template to perform formulas that keeps relative after the merging.

I see... The problem being that this table is a source for a pivot table, I can 'hack' my way around column sums etc. but i need to change table definition.

I tried (cleverly, I thought) to put ref="A1:E[rows.count]" to template and do merge block on this but it seems opentbs plugin does not parse table definition xml's. :(
Could you take this feature into the consideration?

> it seems opentbs plugin does not parse table definition xml's

It can but you have to select the proper sub-file using OPENTBS_SELECT_FILE, and the do a MergeBlock() or a MergeFields()

Thank you for the tip . Duly noted.
It does indeed work like I wanted it to work, but unfortunately it's very tricky to set up/edit such files. Every time file changed I had to edit these xml's by hand :-(

In the end I ditched tables and using named ranges (learning about their existence along the way) as a data source.

I'm studying a way to retrieve a XLSX table from its name. But it's quite complicated.