Spreadsheet date is off by one because it is using local time instead of UTC

[Michael Cheung]

Is there a way to set the timezone to UTC for the spreadsheet? This is probably related to the datamanager servertimezoneoffset https://help.syncfusion.com/js/datamanager/servertimezoneoffset but I don't see this expose in the spreadsheet component.

[Babu Periyasamy]

Hi Michael Cheung,

We have reviewed your query, and before proceeding further, we require some additional details from your end. Kindly provide the following information:

1. Your query references a documentation link related to EJ1. Could you confirm whether you are using EJ1 or EJ2 Spreadsheet?
2. Please specify the purpose for which you want to set the timezone offset in the Spreadsheet.
3. Are you experiencing any issues with date values in the Spreadsheet?
4. If you are encountering issues with date values in different time zones, kindly share the details.
5. Provide a detailed description of your requirement or issue, along with screenshots or a video demonstration, if possible.

Please share the above requested information from your end. Based on that, we will check and update you with further clarification.