Getting cell value from an expression or calculated dimension column

[#1]

Hello,

Is there a way to get the value (into some string) from a cell in an expression column or from a calculated dimention?

Thanks!

[Gysbert_Wassenaar]

Depends on what you need. It's possible to use a macro to get a value from a cell if you know the row and column of the cell you're interested in:

Sub GetCellValue
    RowNo=6
    ColNo=2
    set obj = ActiveDocument.GetSheetObject( "CH01" )
    set cell = obj.GetCell(RowNo,ColNo)
    msgbox(cell.Text)
end sub

If that's not a workable solution you'll have to reuse the expression that calculated the value and possibly modify it so it calculates the value for the right dimension value(s).