Bug 12757

Summary: Integers in saved SQL report ODT export prepended with single quote
Product: Koha Reporter: Nicole C. Engard <nengard>
Component: ReportsAssignee: Galen Charlton <gmcharlt>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

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.