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

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Dec 17 15:39:37 CET 2021


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

Florian <florian.bontemps at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #122350|0                           |1
        is obsolete|                            |

--- Comment #8 from Florian <florian.bontemps at biblibre.com> ---
Created attachment 128674
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=128674&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>

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


More information about the Koha-bugs mailing list