CrossTab GetCaptionText

rbuser

Hello,

When using CrossTab.Matrix.Value[iCol, iRow], is there a way to retrieve the
text as set in the GetCaptionText event instead of the original value?

Thanks,
Natalie

nicocizik

Hi Natalie,

You should not have to use the CrossTab.Matrix.Value property to get the
text from the CrossTab captions when using the GetCaptionText event. The
GetCaptionText event does not affect the matrix value. If you already set
the caption value in the GetCaptionText event, why do you need to extract
that value again? I guess I do not fully understand what you are trying to
accomplish. Please elaborate.

--

rbuser

"Nico Cizik (Digital Metaphors)" wrote in

nicocizik

Hi Natalie,

There is not built-in way to get the caption text using the TppMatrix
object. You will need to save the caption names down as you create them and
then insert them as you regenerate the output to Excel.

--