Bug with Convert

Aspose.Cells Product Family
1

I have an issue with the Convert function. The function is very basic =CONVERT(0.74,“m”,“in”) in excel the output is 29.1 when this is run through aspose.cells to get the cell value i only get .74.


I have attached test.xlsx that has cell A1 on Sheet1 with this formula.

Thanks,
Mark Tomlinson
2

Hi,

Thanks for providing me the template file.

I have found the issue with the Convert
function. When this is run through Aspose.Cells to get the
cell value, I only get “.74” but it should be “29.1” as you pointed out.



Sample code:

Workbook workbook = new Workbook(“e:\test2\bugwithconvert\test.xlsx”);

MessageBox.Show(workbook.Worksheets[0].Cells[“A1”].Value.ToString());

workbook.CalculateFormula();

MessageBox.Show(workbook.Worksheets[0].Cells[“A1”].Value.ToString()); //Wrong value


I have logged an issue with an id: CELLSNET-28230. We will figure it out soon.

Thank you.
3

Hi,

We have fixed this issue. Please download Aspose.Cells for .NET v5.3.3.5.

4

The issues you have found earlier (filed as 28230) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.