Bug 30293

Summary: ODS report download inserts apostrophe in front of numerical results
Product: Koha Reporter: hebah
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
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 hebah 2022-03-14 15:10:05 UTC
When numerical report results are downloaded as ODS format, an apostrophe is inserted in front of the numbers. The result of this is that most functions in spreadsheet programs will not work since the software then doesn't consider those values numbers.
Comment 1 Katrin Fischer 2022-11-17 00:35:15 UTC
Confirmed in master. My test report was 'select * from aqorders', because acq has a lot of numerical values.
I am not sure how this can be solved - we'd probably send/set a datatype somehow?