Mastodawn

TIL Excel localises formulas, and will error if you put the wrong language in

mildly horrifying

@q this is the WORST, and aside from the names, in some locales the function argument separator is a comma and in some it's a semicolon

Show thread

Mauser II 2d ago

@chfour @q

CSV Import/Export in german. Always a joy.

Show thread

fops 2d ago

@wakame @q OH GOD THAT TOO
the so called comma separated values format when microsoft decides to make it semicolon delimited in locales where the decimal separator is a comma while still calling it csv

@chfour @wakame WHAT

I work both with colleagues who export XLSX to "german csv" and with programs that use "english csv".
So the normal way to open a csv in excel for me is to go the "Data" > "From Text", "then define the limiter" route.

Show thread

jet set ratio 2d ago

@wakame @q @chfour I wrote a CSV importer for my current employer and had to deal with this shit 😭

Show thread

Mauser II

@lio @q @chfour

How to escape quotation marks:

Normal people: \"
CSV: """

Show thread

Alex@rtnVFRmedia Suffolk UK 1d ago

@wakame @lio @q @chfour not only Excel, years ago I had a SAGEM mobile phone and being French it would export the contacts list as semicolon delimited (rather than using a comma)