Project:
| 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 |
 |