Filling a pre-existing table

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.

New message

Name:

Email:

ignore this line

Email:

-> No email accessible on Web pages.

Send replies notifications by email

Readers can contact you by Anti-Spam System (*)

Subject:

Message:

Special part in message: enter text between [code] and [/code] tags.

(*) Anti-Spam System: A reader can ask for 3 emails a day, no more ; and the reader must have a valid email to ask for emails.