#352 (ok 2.11) Minor changes to native Excel export (xls.php)

closed-accepted
Marc Delisle
1
2007-08-21
2007-03-15
No

This patch contains several minor changes to the native Excel export plugin (xls.php).

- make column header fixed on print (repeatRows) and when scrolling (freezePanes)
- split data on several worksheets when table contains > 65536 rows (Excel's limit)
- change "Put fields names in the first row" from text field to checkbox (like it is on other export plugins)
- $col renamed to $rowIndex (it counts rows, not columns)

Discussion

  • Patch

     
    Attachments
  • Marc Delisle
    Marc Delisle
    2007-04-02

    • assigned_to: nobody --> lem9
     
  • Marc Delisle
    Marc Delisle
    2007-04-02

    • priority: 5 --> 1
    • summary: Minor changes to native Excel export (xls.php) --> (ok 2.11) Minor changes to native Excel export (xls.php)
    • status: open --> open-accepted
     
  • Marc Delisle
    Marc Delisle
    2007-04-02

    Logged In: YES
    user_id=210714
    Originator: NO

    I merged your changes but was wondering if this export type was still used.

     
  • Logged In: YES
    user_id=32013
    Originator: YES

    >but was wondering if this export type was still used.
    I prefer the native MS Excel export filter, because the generated files work with both MS Excel and OpenOffice.

     
  • Marc Delisle
    Marc Delisle
    2007-08-21

    • status: open-accepted --> closed-accepted