Free Support Forum - aspose.com

Bug with Convert

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

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.

Hi,

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

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.