[Bug 12757] New: single quote in odt export
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12757 Bug ID: 12757 Summary: single quote in odt export Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: gmcharlt@gmail.com Reporter: nengard@gmail.com QA Contact: testopia@bugs.koha-community.org 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. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12757 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|single quote in odt export |Integers in saved SQL | |report ODT export prepended | |with single quote --- Comment #1 from Owen Leonard <oleonard@myacpl.org> --- I can't reproduce this problem in master. Could you post the SQL which triggers the error? -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12757 --- Comment #2 from Nicole C. Engard <nengard@gmail.com> --- 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 -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12757 --- Comment #3 from Owen Leonard <oleonard@myacpl.org> --- 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. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org