Convert HTML to excel - currency issue

Aspose.Cells Product Family
1

Hi,
When I convert HTML to an excel file in specific cases ( when the currency is $ NZ) the cell converts the data into numbers instead of leaving it $1
but when we use the currency EUR, the data is displayed as requested.
attached here example
htmlToExcelIssue.zip (117.1 KB)

2

@zivdaniel
We can reproduce your mentioned issue. We have log it with issue id CellsNet-52289

3

Hi,
any ETA on this? we just before deployment.

4

@zivdaniel
Please set HtmlLoadOptions.ConvertNumericData as false when loading html file to ignore parsing string value to numberic value as the following codes:
HtmlLoadOptions loadOptions = new HtmlLoadOptions();
loadOptions.ConvertNumericData = false;
Workbook workbook = new Workbook(@“D:\FileTemp\NZ$.html”, loadOptions);
And this issue has been fixed, we will include the fix in next release 22.12 in the next month.

5

working. thank you.
when the fix will be released I should remove that flag?

6

@zivdaniel,

The next version (which includes the fix), i.e., Aspose.Cells 22.12 will be published in the second week of Dcember, 2022. You will be notified once the new release is published.

7

The issues you have found earlier (filed as CELLSNET-52289) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi