https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12757 --- Comment #6 from Olivia Reynolds <olivia.reynolds@openfifth.co.uk> --- Created attachment 200338 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=200338&action=edit Bug 12757: Set float type on OpenDocument cells Test plan: 1. Navigate to Reports > Create from SQL. 2. Create a new report with a name and the following SQL query: SELECT 'test', 1, '2' 3. Run the report. 4. Under the Download dropdown, select "Open Document Spreadsheet". 5. Verify a ".ods" file is downloaded. 6. Open the downloaded spreadsheet. 7. Verify the two number-like columns are handled as such. This depends on your choice of spreadsheet software: - In Excel, the numbers should not have a leading single quote in the edit-bar when selected. - In Google Sheets, the numbers should be right-aligned, and selecting both of them should display their sum in the bottom toolbar. 8. Run `prove t/Koha/Util/OpenDocument.t` and verify all tests were successful. Sponsored-by: Open Fifth -- You are receiving this mail because: You are watching all bug changes.