sap.ui.export.Spreadsheet: Local Time Zone

[shais]

Hi,
I'm using sap.ui.export.Spreadsheet to export date from table to Excel (not using Smart table).

The table includes also date, time columns.

When data is exported, date/time values are being saved in UTC.

Is there any way to configure export of date/time in Local time zone instead of UTC?

[junwu]

maybe you can try formatting the datetime as string with desired timezone before export.

[Domi]

Hi

currently exported timestamps are always in UTC:

Spreadsheet Export Limitations: https://sapui5.hana.ondemand.com/#/topic/2c641481649f44de9c1c22c9c3c49d13

But you could use the headers parameter to provide the "Request for Excel Export" info to the backend and do some "formatting" there

regards

Domi

[shais]

Thanks for the answer.

I wasn't aware of these limitations.

However, for the matter of fact, I was referring to date and time columns (EdmType.Date, EdmType.Time) and not to timestamps.
It seems that these are also exported in UTC.

[Domi]

Hi shais

I guess the same coding is used for Date, Time and Timestamp - at least I hope so 😉