[i18n] 2 hours are added to time in Preview of Spreadsheet

[Adobe-G11N-I18N-L10N-Team]

Expected Behaviour

Time in Preview / Publish of spreadsheet is the same as in the spreadsheet

Actual Behaviour

2 hours are added to time in Preview of Spreadsheet

Reproduce Scenario (including but not limited to)

Steps to Reproduce

1. Install extension
2. Add project to extension
3. In project folder create spreadsheet file and edit it
4. Add "Date" column
5. Add dates with time in Date column (dd/mm/yyyy format for Google Drive, mm/dd/yyyy format for Sharepoint)
6. Click on Preview button on action bar

Platform and Version

Chrome 131.0.6778.205
Sidekick 7.1.4

Issue is not reproducible on old Sidekick extension v6.50.1.
Issue is regress from #384

[rofe]

Is the local time on your test system GMT +2?

[Adobe-G11N-I18N-L10N-Team]

@rofe Yes

[rofe]

Got it. So the JSON view assumes that if the author adds a local date/time to the sheet, that same date/time is always UTC in the resulting JSON payload, which is probably wrong. I think it should be viewed in context of the sheet's (drive's?) timezone. But how would we know that?

@dylandepass @tripodsan @davidnuescheler wdyt?