Through testing with sample files we can reproduce the issue. We have opened the ticket:CELLSJAVA-45629 in our internal issue tracking system. We will look into it soon.
@oraspose
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): CELLSJAVA-45629
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.
It appears there are more cases where content of the cells no longer displayed fully.
Attached is the zip archive containing the following:
LocaleFormatting_DateFormats.xlsx - input template for testing various date formats. Note the long date in cells D3 and E6 is not shown properly
LocaleFormatting_CurrencyFormats.xlsx - input template for testing currency formats. It is similar to the LocaleFormatting_NumberFormats.xlsx, with various symbols.
Output HTMLs generated with older version of Cells, as well as 23.9 version
LocaleFormattingDifferentLocales.java - sample program demonstrating the problem (only changed name of the input template)
Thank you.
toAspose_dateFormat_currencyFormat.7z (23.2 KB)
Thanks for providing the zipped archive containing more test cases (source files, output HTMLs and sample code, etc.) regarding numbers formatting and Date formatting issues. We have logged it with your existing ticket “CELLSJAVA-45629” into our database. We will evaluate it and may consider to resolve it as well.
Once we have an update on it, we will let you know.
Can you please provide an update on the opened tickets CELLSJAVA-45538 and
CELLSJAVA-45629 . Are there plans to include them in the upcoming release of 23.10?
Thanks.
We are sorry that both issues, “CELLSJAVA-45538” and “CELLSJAVA-45629”, have not been resolved yet. We will do our best to address these issues in the upcoming release of Aspose.Cells for Java v23.10.
We will keep you updated with any new information on these issues.
We plan to fix your issues in the next week.
Once we have an update on it, we will let you know.
This is to inform you that your issue has been resolved. The fix will be included in an upcoming release (Aspose.Cells v23.10) that we plan to release in the first half of October 2023. You will be notified when the next version is released.
Here is the output file after fix:CELLSJAVA-45538.zip (12.4 KB)
Hi Erik.
Thank you for providing the output for issue CELLSJAVA-45538.
Have you also checked the output for the other issue CELLSJAVA-45629:
And can you please attach that file as well?
Thank you,
Yan
Both issues (“CELLSJAVA-45538” and “CELLSJAVA-45629”) are resolved. The fixes will be included in our upcoming release (Aspose.Cells v23.10) that we plan to release in this week or in the next week early. You will be notified when the new version is released.
The output is actually for issue CELLSJAVA-45629.
The issue CELLSJAVA-45538 has been fixed in v23.9. it should not be reopened as the new issue CELLSJAVA-45629 was opened. Sorry for the confusion.
The issues you have found earlier (filed as CELLSJAVA-45629, CELLSJAVA-45538) have been fixed in Aspose.Cells for Java 23.10.
I did a quick sanity check - it seems neither data formats issue , nor currency formats issue are fixed.
Attached is archive containing examples that highlighted the differences between older Cells library and version 23.10.
Please let us know if you have any questions.
Thank you.
date_localeUS_21.10_versus_23.10_currencyFormat_variousLocales.zip (352.0 KB)
We have added an option “HtmlSaveOptions.FormatDataIgnoreColumnWidth”. Please try the following code after the next version is released：
Workbook workbook = new Workbook("LocaleFormatting_NumberFormats.xlsx");
HtmlSaveOptions saveOptions = new HtmlSaveOptions();
saveOptions.setFormatDataIgnoreColumnWidth(true);
workbook.save("dest.html", saveOptions);
Here is the output file after fix: output.zip (16.1 KB)
Thank you, will try this option when the new version is released.
Sure, please take your time to test with the new option using newer version of the API. Hopefully, it will figure out your issue.
using newer version of the API
When will the newer version be available? Is it going to be a patch or regular 23.11 release?
The issues you have found earlier (filed as CELLSJAVA-45538) have been fixed in Aspose.Cells for Java 23.11.