Menu ▾ ▴

#497 Invalid Excel format generated

Not planned
wont-fix
nobody
Excel (1)
5
2014-12-04
2014-12-02
Creature
No

When a csv is generated using the "Generate Excel" button on the view, it uses semicolons ";" to separate the columns, not commas ",". This results in all row data being stuck into the very first column when viewed in Microsoft Excel (and semicolons, as well as double quotes, are visible)

To replicate: Load up MySchool app, go to Teachers view, make sure there are rows visible, then click "Generate Excel" button. Save and view the .csv file. (example attached)

Environment:
OpenXava 5.1.1
Apache Tomcat Version 7.0.50
Windows 7 Professional SP 1

1 Attachments
Teacher report 20141202_1553.csv

Discussion

  • Creature

    Creature - 2014-12-02
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -1,3 +1,8 @@
 When a csv is generated using the "Generate Excel" button on the view, it uses semicolons ";" to separate the columns, not commas ",". This results in all row data being stuck into the very first column when viewed in Microsoft Excel (and semicolons, as well as double quotes, are visible)

 To replicate: Load up MySchool app, go to Teachers view, make sure there are rows visible, then click "Generate Excel" button. Save and view the .csv file. (example attached)
+
+Environment: 
+ OpenXava 5.1.1
+ Apache Tomcat Version 7.0.50
+ Windows 7 Professional SP 1
     

  • Javier Paniza

    Javier Paniza - 2014-12-04
    • status: open --> wont-fix
     

  • Javier Paniza

    Javier Paniza - 2014-12-04

    This is not a bug. Please, put your question about how to solve this issue in the Help forum.

     

Log in to post a comment.