search

VSEScala / Scala-Dining

Contains the Scala Dining Website Design
4 stars 5 forks source link

Suggestion: Make a csv export of transactions readable by excel #270

Closed Perry26 closed 8 months ago

Perry26 commented 11 months ago

When creating a csv file for your transaction history, it is not possible to import it into excel with the default settings. Since newer versions of excel don't allow you to change the settings easily anymore (at least not easily enough that I can explain it to people), I propose to alter creditmanagement/csv.py to include the setting dialect='excel' on the csv writer. (https://docs.python.org/3/library/csv.html)

mhvis commented 11 months ago

According to the doc page excel seems to be the default value. So it might not be fixed with that change. Do you know the specific issue?

LenaWil commented 11 months ago

Could it be a localisation issue?

I know the Dutch version and the American version of Excel don't agree on the definition of csv.
(Microsoft, why‽)

mhvis commented 11 months ago

Yeah maybe. Dutch versions might expect a comma for the decimal places in a number, instead of a point. I know Excel is horrible with CSVs.

mhvis commented 8 months ago

Closing this as stale. Reopen it if necessary.