Incorrect working Convert and Roman excel functions

Aspose.Cells Product Family
1

Hi!


It looks like Convert and Roman functions work incorrectly. Please see the code and attached excel file:

string sourseFileName = “test.xlsx”;
Workbook sourceWorkbook;
using (FileStream fstream = new FileStream(sourseFileName, FileMode.Open))
{
sourceWorkbook = new AC.Workbook(fstream);
}
sourceWorkbook.CalculateFormula(true);
var sheet = sourceWorkbook.Worksheets[“Sheet1”];
for (int i = 3; i <= 7; i++)
{
var cellAddressHardcodedValue = “B” + i;
var cellAddressFormulaValue = “C” + i;
Console.WriteLine(string.Format("{0} vs {1}", sheet.Cells[cellAddressHardcodedValue].Value, sheet.Cells[cellAddressFormulaValue].Value));
}

Thanks,
Leo
2

Hi Leo,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue. The calculated values of the Convert and Roman functions by Aspose.Cells do not match with MS-Excel.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42517.

3

Hi,

Thanks for using Aspose.Cells.

Please download and try the fix: Aspose.Cells for .NET 8.0.0.1 and let us know your feedback.

4

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.