the date format is changed in result pdf file.
xls: 2011-01-10 , pdf : 10.01.2011
I’m attaching xls file for testing.
Thanks in advance for help
I have tested your file with latest Aspose.Cells for Java fix v220.127.116.11, it works fine. Here is my sample code:
//Instantiate a new workbook
Workbook book = new Workbook();
//Open an existing file
I have also attached my output file here.
thank you for reply.
I’ve checked your file and I can see dates in format dd/mm/yyyy while in the xls there is yyyy-mm-dd.
Maybe it depends on some Adobe Reader settings ?
I think you must have specified a different locale when you converting this xls to pdf. The date format of the cell (such as “H3”) depends on locale. When you change your computer’s locale to the same one that you used to convert xls to pdf, you will see the date shown in excel for “H3” is same with the content in the generated pdf file.
How I can change the locale used while saving xls to pdf ?
I’ve tried following methods but it doesn’t work
No matter what value I set, I always get date in format "dd.mm.yyyy"
To change the locale, please use JVM options like “-Duser.language=en -Duser.country=US”.
thank you for reply.
I’m attaching test xls file and two pdf files:
dat_test_asp.pdf - generated using aspose.cells
dat_test_exc.pdf - generated using excel.
I want to receive the same result when I use aspose. That is - what I see in excel I get in pdf.
Well, we have tested your case with JVM option like “-Duser.language=pl” which will set locale as polan
and the generated Pdf file is same with Excel’s result except the cell C6 which uses Zulu locale. For Zulu locale, we have tested it with several JDK versions and found none of them can format May as “uMeyi” as Excel. I think maybe current JDKs cannot support Zulu local.
Thank you for reply.
I’ve tried to run my example on the Unix environment and it works fine(with the -Duser.language option).
On Windows environment despite setting the language option, I’m getting the same incorrect result.
This solution is good for me because our client runs application on Unix environment.
However the Windows env case is interesting.
Well, we have done test on Windows. We cannot find the issue. The generated pdf is just same with what is shown in MS Excel except the cell C6 that we have already given you the explanation about it. Here is the sample code and attached it the output PDF file. I am also using JVM’s -Duser.language option to pl.
Workbook workbook = new Workbook();
can you provide any other solutin for this problem. Setting JVM option is unacceptable because it changes language in other applications running on the same server.
Thanks in advance
For this requirement about changing locale, please try Workbook.getWorkbookSettings().setRegion()/setLocale() again with recent version/fix. In recent versions and fixes, we have supported to change the output number format according with user’s custom locale.
Aspose.Cells for Java v18.104.22.168