[Solved] Acquiring the Data in tablegrid and loop it

[ouchd'greyt]

Hi,

Thank you for kindness response, i appreciated it,
I do alternative way on how to appear the selected data from the table grid to my record cell, when the push button get push its label will also change (ex: the label of push button is "item 1" after pressing the button the selected data will transfer/appear to my record cell then the push button label will now change to "item 2" and so on and so forth).


But, i will also try your code, to know what would happen.

Thanks very much!

[UnklDonald418]

What happens if you set a Breakpoint and single step through your macro?
Does it then work correctly, or is the macro firing 3 times?
If you upload a sample file so we can see what is happening, then maybe someone can help.

[Villeroy]

Writer:
tbl = ThisComponent.TextTables.getByName("Table 1")

Calc:
tbl = ThisComponent.Sheets.getByIndex(0).getCellRangeByName("A1:C99")

Both:
a() = tbl.getDataArray()

Now you have a nested array of row arrays in variable a.