We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Numeric values set using PutValue are incompatible with OpenOffice

I am using


to set numeric values into the cells.

In Microsoft Excel those cells are still seen as numeric and calculated fields involving those cells work correctly.

If I open the same worksheet with OpenOffice, though, the content is displayed as numeric but when you edit the cell you see that 5 really is stored as '5 (apostrophe in front).

This has the undesired effect that the value of the cell cannot be used by other cels for automatic calculations. ('5*4 is 0 and not 20)

Any chance that you can fix this?

Giorgio Malagutti


Thanks for your details,

We will check your issue soon.

Thank you.


Please try the following codes:

Workbook workbook = new Workbook();
Cells cells = workbook.Worksheets[0].Cells;
cells["B1"].Formula = "=A1*4";
cells["B2"].Formula = "=A2*4";
cells["B3"].Formula = "=A3*4";
// workbook.Save(@"C:\Book1.xls");

The value of B2 in OpenOffice is zero and the value of A2 is '5.So i think you must set a string value as the value. If you want to set a number value with string param, please use Cell."].PutValue(string stringValue, bool isConverted) method.

setting IsConverted to true solved the issue.

Many thanks for your prompt reply.