[Koha-bugs] [Bug 22038] When exporting account table to excel, decimal is lost

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22038

--- Comment #11 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
Created attachment 132301
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=132301&action=edit
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 at inlibro.com>
Signed-off-by: Florian Bontemps <florian.bontemps at biblibre.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen at theke.io>

-- 
You are receiving this mail because:
You are watching all bug changes.