Wrong Decimal Separator in CSS Properties when saving Workbooks as HTML

Aspose.Cells Product Family
1

Hello,

when using the new option IsBorderCollapsed the properties in css for transform are set with wrong decimal separators.
Eg: transform: rotate(-90deg) skew(-22,5deg);

System Language is German.
CultureInfo of the thread/workbook is set according to the documents language and is needed for dates and other localized formatsettings.

Code to reproduce the issue:

var lic = new License();
lic.SetLicense(@"S:\Aspose.Total.NET.lic");

var workbook = new Workbook(@"S:\tmp\in.xlsx");
var options = new HtmlSaveOptions
{
    IsBorderCollapsed = false
};
workbook.Save(@"S:\tmp\out.html", options);

Thank you for your help

Attached Files for in.xlsx and out.html
example.zip (8,8 KB)

2

@DCyl,

Thanks for the template XLSX file.

Please try our latest version/fix Aspose.Cells for .NET v24.8. I have tested your scenario/case using your sample file and code snippet and the output HTML is fine tuned.
out.zip (1.9 KB)

Let us know if you still find any issue with Aspose.Cells for .NET v24.8.

3

@amjad.sahi, thanks for your reply.

I tested with Aspose.Cells v24.8 and can still reproduce the issue.

I have added the docCulture information to the code to reproduce the issue.

var lic = new License();
lic.SetLicense(@"S:\Aspose.Total.NET.lic");

var workbook = new Workbook(@"S:\tmp\in.xlsx");

// Set culture for formatting
var docCulture = new System.Globalization.CultureInfo("DE_DE");
Thread.CurrentThread.CurrentCulture = docCulture;
Thread.CurrentThread.CurrentUICulture = docCulture;
workbook.Settings.CultureInfo = docCulture;

var options = new HtmlSaveOptions
{
    IsBorderCollapsed = false
};
workbook.Save(@"S:\tmp\out.html", options);

Some style informations like height and width have correct values.
It’s only transform which seems to be using cultureInfo for their decimalSeparator.

4

@DCyl,

Thanks for providing further details.

After setting locale/culture information in code, I was able to reproduce the issue as you mentioned. We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-56447

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

5

@DCyl ,

We are pleased to inform you that your issue has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.9) that we plan to release in the first half of September 2024. You will be notified when the next version is released.
Attached is the fixed result for your reference:
output.zip (1.9 KB)

6

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