[Koha-bugs] [Bug 22038] New: 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 21 00:04:59 CET 2018


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

            Bug ID: 22038
           Summary: When exporting account table to excel, decimal is lost
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Fines and fees
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: caroline.cyr-la-rose at inlibro.com
        QA Contact: testopia at bugs.koha-community.org
  Target Milestone: ---

When you want to export a patron's account lines in Excel, the decimals are
lost. So instead of having a fine of 3,75, the Excel file says the fine is 375.

Note that I opened the Excel file in LibreOffice Calc. I'm not sure if that
affects anything. Although I also opened the file in vim and got the same
result: <c r="D2" s="63"><v>375</v></c><c r="E2" s="63"><v>375</v></c>

To reproduce:
1) Find a patron with small fines (my patron had 3,75) or create some manual
charges
2) In the patrons file, go to the Fines tab and then the Account tab
3) At the top of the account table, click on Excel
4) Open the file
5) Notice the fines are now multiplied by 100

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


More information about the Koha-bugs mailing list