Categories > OpenTBS with XLSX >

Populating rows without expanding the excel rows?

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Paul
Date: 2014-05-05
Time: 10:46

Populating rows without expanding the excel rows?

Hi,

If my excel template already has cells defined, eg: cols A to D and rows 1 to 10. and I would like to pouplate rows 1 to 10 with a dataset, can this be done?

So in other words, I would like to use the BlockMerge, but it must NOT duplicate the row, instead it must populate the row already defined.

I need to do this to solve the formula problem, as the MergeBlock copies the formulas of the first row as is, so the formulas dont work for consecutive rows.

Any help would be appreciated.

Paul
By: Skrol29
Date: 2014-05-05
Time: 23:45

Re: Populating rows without expanding the excel rows?

Hi,

You can use a block with 10 conditional sections :
[b;block=tbs:row;when [b.#]=1]
[b;block=tbs:row;when [b.#]=2]
...
# is a virtual column that counts the record number.

By: Paul
Date: 2014-05-06
Time: 11:13

Re: Populating rows without expanding the excel rows?

Brilliant, thanks, it works.

Just a quick question if I may, if I only have 5 rows in the particular dataset, the result block deletes the last 5 empty rows, which is what I expect.

However, if I have, for example a sum() formula at the end of the 10 rows, I get a circular ref error, as the rows have been deleted, but the formula obviously has not been updated.

Is there any way I can tell tbs to NOT delete the rows, but simply leave them blank. This will solve the circular ref problem?

Regards

Paul
By: Skrol29
Date: 2014-05-06
Time: 18:27

Re: Populating rows without expanding the excel rows?

> Is there any way I can tell tbs to NOT delete the rows, but simply leave them blank. This will solve the circular ref problem?

You can feed you record set with empty data until you have 10 rows.
By: Paul
Date: 2014-05-06
Time: 22:36

Re: Populating rows without expanding the excel rows?

thanks skrol29,

Unfortunately I am using the tbs dataset query feature directly from mySQL, so I cannot add any blank rows to the dataset as I am using tbs as a reportwriter with users designing their own templates.

Is there any way we can add a property to tell it NOT to delete the row if the condition fails, but rather replace with blanks?, eg

[b;block=tbs:row;when [b.#]=2; else donotdeleterow=true]

So in other words, if the condition fails, we simply replace all cells with blanks,

I am happy to look at adding this if you can point me in the right direction?

Paul
By: Paul
Date: 2014-05-07
Time: 12:24

Re: Populating rows without expanding the excel rows?

Hi skrol29, further to my discussions above, I see my problem I am trying to get around is related to this forum post


Do you have an ETA of this bug fix, cause if it is fairly close, I can hold out doing any circumvent changes?

Paul.

PS: My feature request in previous post I think is still a nice handy one to have.