Hello,
thank you for your help. Unfortunately there still is an issue here. The number of entries is correct using your code, but the calculated dates are wrong. In the given example the output contains entries for April and May, but in the data source are no entries for that months. After using the refresh data functionality in excel the dates are correct. Please see the attached screenshots.
Kind regards
Stefanie
screenshots.zip (52.6 KB)
It looks like you are still using older version of the APIs. Please try using our latest version/fix and it will work as expected.
I tested it with Aspose.Cells for Java 21.3 and still encountering this problem.
Please find attached the output Excel file which is ok. Please open it into MS Excel and let us know if you find any issue.
out1.zip (19.6 KB)
Also, test your code in a separate console application using Aspose.Cells for Java v21.3 and generate the output files. If you still find the issue, kindly do share your output files and environment details, we will check it soon.
Hello,
Please find attached output file that contains the error.
outputFile.zip (19.7 KB)
What environment details do you need?
Please share your regional settings/locale settings of the OS where you are processing your sample code, we will investigate further. Also add a line to save to PDF file format and share the output PDF for reference. By the way, did you open my attached file into MS Excel and if it is fine tuned?
Hello,
my regional settings and OS:
Region: Germany
Regional format: German (Germany)
Time Zone: UTC+1:00 Europe/Berlin
OS: Windows 10
Here is the PDF you asked for.
outputFile.zip (67.2 KB)
Yes, I opened your attached file and it is all fine.
Kind regards
Stefanie
Could you please try specifying the region and try your scenario/ case if it works:
e.g.
Sample code:
Workbook workbook = new Workbook(stirngFilePath);
workbook.Settings.Region = CountryCode.Germany;
.............
Let us know if you still find the issue.
I tried this code:
WorkbookSettings settings = workbook.getSettings();
settings.setLocale(Locale.GERMAN);
settings.setRegion(CountryCode.GERMANY);
settings.setLanguageCode(CountryCode.GERMANY);
Still the same probleme. Here is the output:
files.zip (86.9 KB)
We are sorry that it still does not work on your end. As we have already logged a ticket with an id “CELLSJAVA-43418”. Please spare us little time so we could evaluate your issue thoroughly.
Once we have an update on it or we figure it out, we will let you know.
@stefgt,
Please try our latest version/fix: Aspose.Cells for Java v21.3.6 (attached)
aspose-cells-21.3.6-java.zip (7.2 MB)
Your issue should be fixed now.
Let us know your feedback.
Hi,
I tried v21.3.6 and unfortunately I am still seeing the same problem.
Here is my output with v21.3.6
files.zip (86.9 KB)
Could you also share your sample code (runnable) that you are using with latest fix to generate the output file(s). This will help to trace the issue and we could fix the issue (if found) soon.
I did test your sample code with your template file and it works fine on my end. Please find attached the output files for your reference.
files1.zip (112.7 KB)
I have logged your output files and sample code with your existing ticket. We will investigate and look into it further on why it is not working on your end. Once we have an update on it, we will let you know here.
@stefgt,
We can not reproduce the issue using Aspose.Cells for Java v21.3.6.
Can you print the API version and let us know the feedback?
System.out.println(CellsHelper.getVersion());When i print the API version it says “21.3.6”
Hi,
is there any news on the subject?
We are sorry but still we could not reproduce the issue. We will further evaluate your issue and get back to you soon.