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.
I can't reproduce this problem in master. Could you post the SQL which triggers the error?
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
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.
This bug is still valid in master as of 2019-11.