Determining data type of cell in cellset -
07-26-2006
, 03:24 PM
I need to determine the data type of individual cells, specifically if they
are currencies or percentages. The Cell.Value property contains a Double and
the Cell.FormattedValue may have a currency formatted string if it's defined
correctly in AS; however, due to internationalization issues I obviously
should not be looking at the FormattedValue property to determine the cell's
data type.
This seems like it would be easy, but so far I can not see how to do this
using the available metadata brought back from a cellset.
Any suggestions?
Thanks,
Terry
______________________
Terry Smith
Senior Architect
Insight Ecosystems
http://www.insightecosystems.com |