https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43981

--- Comment #2 from Olivia Reynolds <[email protected]> ---
Created attachment 210291
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=210291&action=edit
Bug 43981: Use report column types to specify ODS column type

As part of generating an ODS spreadsheet from a report, determine
whether each column of the result is a numeric SQL type. This
information can then be used to give ODS cells for those columns a float
type as appropriate.

Test plan:
1.  Create a SQL report with the following SQL:
      SELECT 1, '1', '01', 'one'
2.  Run this report and download an ODS of the result.
3.  Verify that the first three columns have received a float
    type (often this means they're right-aligned).
4.  Verify that the leading zero of the third column has been lost.
5.  Apply patch.
6.  Repeat step 2.
7.  Verify that only the first column now receives a float type.
8.  Verify that the leading zero of the third column has been retained.

Sponsored-by: Open Fifth

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to