Re^2: Spreadsheet::ReadSXC and localization -- Google Sheets vs LibreOffice Calc

What it is surprising is that Google Sheets does not save the file with the current settings as LibreOffice does, if that is the standard. Or it is the opposite? I tried to find this in the ODS file format specs but I couldn't find any reference about it.

Changing the localization of my LibreOffice setup before saving the document is a workaround I'm not sure to take as normal. Google Sheets is clearly saving a "cannonical" version of the value in "text:p" tag, and Libreoffice is reformating that field at open time, but at save time it keeps the new localizated format there. What I haven't tried is to upload a LibreOffice modified document back to Google Sheets... What should I expect there?

Comment on Re^2: Spreadsheet::ReadSXC and localization -- Google Sheets vs LibreOffice Calc

Replies are listed 'Best First'.
Re^3: Spreadsheet::ReadSXC and localization -- Google Sheets vs LibreOffice Calc by holli (Abbot) on Jan 14, 2020 at 20:36 UTC
Let's take a step back. - Where are the Google documents coming from? As in, how do they get created? And - What do you want to do with them after download? Or, what is your workaround actually for? holli You can lead your users to water, but alas, you cannot drown them.	[reply]