Multiple row insertion

[Former Member]

Requirement:

Pick from a selector (combobox, accordion, label based menu etc.) and have the selected item drive a list.

Challenge seems to be that I can't seem to find a way to insert multiple results for same selection.

In the project i have each, selection could contain from 1- 500 rows of data with a total of over 15,000.

Appreciate any feedback

Example

Item 1 selected>display 50 rows of matching data in a list

Item 2 selected>display 150 rows of matching data in the list

etc.

Thanks!

[Former Member · Accepted solution]

Hi David,

Insertion type of "Filtered Rows" can accomplish your requirement.

Assume your data is like

Col1       Col2
A            1
A            2
......
A           50
B           51
B           52
......
B          200

For example, you can use a selector to insert multiple rows:

1) Bind seletor(say combo box) labels to Col1.

2) Selert "Filtered Rows" as insertion type.

3) Bind Source to Col2.

4) Bind a Destination range.

5) At run time, when you click "A" in selector, Row1:50 will be inserted to destination range; when you click "B", Row51:200 will be inserted to destination range.

If you are using Xcelsius 5 or later versions, you also can find a Filtered Rows sample in File->Samples.

Hope this can help!

[Former Member · Accepted solution]

Thanks Grace! That was very helpful!

Unfortunately my data set is just to large, Certain items when selected have over a thousand rows of data.....looks like Xcelsius puts a max on...

Thanks again for your help!

[Former Member · Accepted solution]

Hi,

If you want to bind a large range more than 512 rows, go to File->Performance->Excel Options, change the Maximum Number Of Rows. But we don't recomment to bind a range of thousands of rows because it will decrease the performance.