We are using Aspose Cells version 184.108.40.206, and are having problems formatting numbers.
The code we are using to populate the spreadsheet with the data from our database is:
sheet.Cells.ImportDataReader(reader, true, 0, 0, false, "mmm-yyyy", true);
I understood from the documentation that the last value (‘ConvertStringToNumber’), set to true in our code, is what formats the text as numbers. Setting as false shows the green triangles in Excel, with the error ‘Number Stored as Text’.
However we seem to have a problem with one column. The column shows aspect ratios (e.g. 19:10). With the ‘ConvertStringToNumber’ bool set to true, this seems to be converting the text to a decimal number. Turning the value to false instead shows the value correctly, however then all the other numbers are then stored as text:
Capture2.PNG (1.2 KB)
We have tried a number of different combinations of styles and style flags, however have been unable to find a method to display both the aspect ratios correctly, but have the other numbers stored as numbers.
Please can you advise?