[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