Bug 12757 - Integers in saved SQL report ODT export prepended with single quote
Summary: Integers in saved SQL report ODT export prepended with single quote
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-08-13 22:46 UTC by Nicole C. Engard
Modified: 2019-11-20 17:38 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nicole C. Engard 2014-08-13 22:46:38 UTC
When you export the result of a report to ODT format, it seems to prepend a single quote prior to integer values.  It gets a little annoying since you can't do an math on those figures until the quote is removed.  There is no single quote prepended with CSV or tabular exports.
Comment 1 Owen Leonard 2014-10-08 13:01:21 UTC
I can't reproduce this problem in master. Could you post the SQL which triggers the error?
Comment 2 Nicole C. Engard 2014-10-08 14:10:36 UTC
Here's one:

select i.location, s.type, count(s.datetime) as count from statistics s left join items i using (itemnumber) where i.location IN ('BOARDBK','EASYRDR','JAUDIOBK','JBIO','JDVD','JDVDNF','JDVDS7','JDVDSER','JFIC','JGRAPHIC','JLANG','JMUSIC','JMYS','JNF','JOS','JPER','JSPN','JVDV','KIWANIS','PICBOOK','SUMMER') AND s.datetime between <<Between (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> and s.type in ('issue','renew','return') group by i.location, s.type
Comment 3 Owen Leonard 2014-10-08 14:44:20 UTC
Okay you're right and I can reproduce it with my reports as well. I just didn't realize that the single quote wasn't visible in the spreadsheet until you click in a cell to edit it.
Comment 4 Owen Leonard 2019-11-20 17:38:24 UTC
This bug is still valid in master as of 2019-11.