We are sorry but we have not evaluated it yet. We will analyze your requirements and get back to you soon.
We are sorry for any inconvencie caused!
We have made some optimizations for your requirements in the next release 23.9. Please try the following code after 23.9 is released：
Workbook workbook = new Workbook(dir + "CELLSJAVA45538.xlsx");
HtmlSaveOptions saveOptions = new HtmlSaveOptions();
saveOptions.setPresentationPreference(true);
workbook.save(dir + "dest.html", saveOptions);
The issues you have found earlier (filed as CELLSJAVA-45538) have been fixed in Aspose.Cells for Java 23.9.
Hello.
The optimization looks good, thank you, it is an improvement compare to 23.08 version.
However, we have several non-US clients and using different locales on the server.
For some of the locales ( “es” , “fr”, “it” in particular) the issue with numeric values shown with hashes still exists.
Perhaps it is caused by extra non-breaking space in the table cell after the actual value. You would see it in the comparison between generated HTML for US locale and for French (FR) locale.
Attached is the zip archive containing the following:
LocaleFormatting_NumberFormats.xlsx - input template
LocaleFormattingDifferentLocales.java - small test program
NumberFormat_Locales_comparison.png - screenshot of comparison between generated HTMLS, highlighted the issue;
Various outputs, generated with older version of Cells (21.9.0) and new version (23.9.0) .
Please let us know if you need additional information.
Thank you.
toAspose_numberFormat.7z (138.1 KB)
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.