Hi,
We are using Aspose products from long time. Now I am working on Aspose.Cells and I need to extract a superscript character from a cell. For example, I am having a cell value as "Aspose" and the first character "A" is superscript. I have set this to superscript by going to FormatCells option of an excel. I use following code to get the IsSuperScript value. This code always returns false eventhough the chanracter I am at is superscript.
private void ReadExcelFile()
{
Cell cell = workBook.Worksheets[0].Cells[1, 0];
string name = cell.Characters(0, 1).Font.Name;
bool isSuperScript = cell.Characters(0, 1).Font.IsSuperscript;
}
Some of the article said, programatically setting it to true, but thats not what I want. This property will be set manually to superscript and i need to read and findout which is superscript chanracter.
Any help in this regard is highly appreciated.
Venki