Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm looking to grab / fetch a specific value of a row / column from a table object, for use in another object.
So lets say I have a table object with ID of OBJECT1.
In another object, say a text object, I want to say something like: =OBJECT1.Column(2) and simply display the number which exists in that column/row of object 1.
Any way to do this?
Dan
Bump. Can anyone help?
You can't directly refer an object row in qv like that. You should rather refer the data considering it's POV. Otherwise, there is macro, somthing like:
set obj = ActiveDocument.GetSheetObject( "BU01" )
CellRect = ActiveDocument.GetApplication().GetEmptyRect()
CellRect.Top = 0
CellRect.Left = 0
CellRect.Width = obj.GetColumnCount
CellRect.Height = obj.GetRowCount
set CellMatrix = obj.GetCells( CellRect )
for RowIter=CellRect.Top to CellRect.Height-1
for ColIter=CellRect.Left to CellRect.Width-1
msgbox(CellMatrix(RowIter)(ColIter).Text)
next
next