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?
I am using
Thanks for your details,
We will check your issue soon.
Please try the following codes:
Workbook workbook = new Workbook();
Cells cells = workbook.Worksheets.Cells;
cells["B1"].Formula = "=A1*4";
cells["B2"].Formula = "=A2*4";
cells["B3"].Formula = "=A3*4";
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.