Categories > OpenTBS with XLSX >

Filling a pre-existing table

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Jo
Date: 2015-02-23
Time: 14:15

Filling a pre-existing table

Hi

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

I currently have
[cpsc.key;block=tbs:row]    [cpsc.week]    [cpsc.cu]    [cpsc.id]    [cpsc.number]
in 1st table row but after merging data - table dimension does not change and data is overflowing table boundary. :(
By: Skrol29
Date: 2015-02-23
Time: 15:24

Re: Filling a pre-existing table

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.
By: Jo
Date: 2015-02-26
Time: 09:16

Re: Filling a pre-existing table

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?
By: Skrol29
Date: 2015-03-07
Time: 23:17

Re: Filling a pre-existing table

> 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()
By: Jo
Date: 2015-05-14
Time: 06:31

Re: Filling a pre-existing table

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.
By: Skrol29
Date: 2015-05-18
Time: 10:10

Re: Filling a pre-existing table

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