We have been using the aspose.cells product for many years - we have recently run into a strange case where an XLSX file is presented and that is returned by the Cell.Value function has no resemblance to the data that is in the cell.
We can re-save the file as an XLS as it does not correct the issue but if we copy the contents and paste it into a new document - it works fine.
Code is as follows:
for (counter = 0; counter < 50; counter++)
{
headerCell = workSheet.Cells[startingRow - 1, counter];
String headerName = “” + headerCell.Value;
bla bla…
}
Cell A3 has the value PAYER but when we print out the headerCell we see:
Aspose.Cells.Cell [ A3; ValueType : IsNumeric; Value : 24 ]
This is repeated for all cells across that row (these should just be Strings). Excel reads it ok though.
We have updated to the latest version that was available for Aspose.Cells (7.3.1) and get the same error. Anyone else that has run into this issue?