🪨 (@Varpie)

Arne Brasseur @plexus@toot.cat

So the app we adopted recently has a CSV export. And the client is unhappy because some of it looks garbled in Excel, due to a cell that contains commas and newlines. It's correctly quoted in the CSV. OpenOffice reads it correctly, google sheets reads it correctly, his version(?) of Excel apparently does not. And I'm here doing support over email without access to excel...

Any fedifriend seen something like this before and want to tell me what the magic solution is?

🪨 @Varpie@peculiar.florist

@plexus Could be some localization bullshit, if you have number,number that would be translated into a number with a fractional part. Although these days ; is a more common separator than , and it wouldn't have that issue.

⭐1