Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #31710 Back to Issue ]
Summary 0031710: Review XLS reports to apply cell type when required
Revision 2016-05-25 09:56 by caristu
Description Since [1] the XLS report content is exported as string in order to ensure that all the data can be seen when opening this kind of reports with Office.

In order to ensure a correct definition of our core XLS reports, they should be reviewed and for example make numeric fields be exported as numbers. This way they can be manipulated directly after opening them with any spreadsheet application.

Currently the General Ledger Report and the Trial Balance are properly configured as explained here[2] and numeric values are seen as numbers in spreadsheet. The rest of XLS reports should be configured in the same way.

Note: with fix [3], BigDecimal values are exported as numbers. The decimal and thousands separators used for that numbers will be those configured in the spreadsheet program (Excel).

[1] https://issues.openbravo.com/view.php?id=31676 [^]
[2] http://wiki.openbravo.com/wiki/How_to_create_a_Report#Configuring_Cell_Type_in_XLS_Reports [^]
[3] https://code.openbravo.com/erp/devel/pi/rev/bfee0e727006 [^]
Revision 2015-12-15 10:06 by caristu
Description Since [1] the XLS report content is exported as string in order to ensure that all the data can be seen when opening this kind of reports with Office.

In order to ensure a correct definition of our core XLS reports, they should be reviewed and for example make numeric fields be exported as numbers. This way they can be manipulated directly after opening them with any spreadsheet application.

Currently the General Ledger Report and the Trial Balance are properly configured as explained here[2] and numeric values are seen as numbers in spreadsheet. The rest of XLS reports should be configured in the same way.

[1] https://issues.openbravo.com/view.php?id=31676 [^]
[2] http://wiki.openbravo.com/wiki/How_to_create_a_Report#Configuring_Cell_Type_in_XLS_Reports [^]


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker