Bug 22038: Fix excel export if CurrencyFormat is FR
authorDidier Gautheron <didier.gautheron@biblibre.com>
Fri, 11 Dec 2020 09:46:04 +0000 (10:46 +0100)
committerKyle Hall <kyle@bywatersolutions.com>
Fri, 8 Apr 2022 14:39:32 +0000 (10:39 -0400)
commit817befca63a774ae6d9b2a6f455c26c2530011cd
tree34679767c391ded8a95bd15dca6cc043afa14ee6
parentbcd73fbdae5fe838533ddd51c7410c1337b3cbcc
Bug 22038: Fix excel export if CurrencyFormat is FR

DataTables excel export is broken if number decimal separator is a comma.

Test plan:
1 - Set syspref CurrencyFormat to US
2 - Export as excel a table with decimal numbers, patrons list with fines
for example.
3 - Open in libreoffice or excel, numbers are ok.
4 - Set syspref CurrencyFormat to FR
5 - Export and open again, number are wrong 25,10 is imported as 2510
6 - Apply patch
7 - Redo 1 to 4
8 - Excel export, number is 25,10

Signed-off-by: hakam <hakam@inlibro.com>
Signed-off-by: Florian Bontemps <florian.bontemps@biblibre.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
koha-tmpl/intranet-tmpl/prog/en/includes/columns_settings.inc