VisibleInfosText vs GetResultValueAsString

[y2kdis]

Hi,

Which is the better way of getting the 'as displayed' cell value?

Dim selection As CellSelection = worksheet.Cells(i, j)
Dim value As ICellValue = selection.GetValue().Value
Dim format As CellValueFormat = selection.GetFormat().Value
Dim formatResult As CellValueFormatResult = format.GetFormatResult(value)
Dim result As String 

result = value.GetResultValueAsString(format)
'vs.
result =  formatResult.VisibleInfosText   

             

Thanks,

Sid

[Tanya]

Hi Sid,

The two approaches are identical and you can use the one that most suits your preferences. Internally GetResultValueAsString() uses GetFormatResult() and VisibleInfosText to evaluate the value.

I hope this information is useful.

Regards,
Tanya
Progress Telerik