can you count the letter "s" in:
when we are calling aspose service for watermark, we are passing the date format in the form of string with converted local date.
but when the date is printed on the excel it is not showing the local date.
please help us how can we set the local date format for watermark.
when you apply built-in numbers formatting in code, the date/time values are converted in accordance with locale/regional settings of the system/environment when you open the output file into ms excel there.
if you apply custom numbers formatting in code, then the datetime value would be independent and does not change with locale/regional settings.
keep the above points in mind. also, i am not entirely certain about your issue, so if you still have confusion/problem, kindly do provide more details, sample code (runnable) and sample files (input (if any) and output file, etc.), we will check it soon. also provide a file with your expected datetime in the cell, you may manually create the file in ms excel. this will help us really to evaluate your issue precisely and to consequently figure it out soon.
ps. please zip the excel files prior attaching.
below is the code to format i am using.
i am not getting the correct time and local however date is retained correct in the watermark.
well. i am afraid, we cannot evaluate your issue (if there is any problem with aspose.cells for java apis) precisely based on your provided code segment. we need more details, complete sample code (runnable) and sample files (input (if any), output file by aspose.cells and your expected file, etc.), some screenshots to highlight the problem, etc., to reproduce the issue on our end.
user
There are seventy-four "s"s.
assistant