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.
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?