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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033743
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformmajorhave not tried2016-08-18 16:452022-02-01 08:09
ReporterrbianchiniView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0PR16Q2.1SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033743: Numeric Values in Reports are Text, not numeric in Excel

DescriptionNumeric Values in Reports are Text, not numeric in Excel.
There is a way to configure the custom reports shown in this article: http://wiki.openbravo.com/wiki/How_to_create_a_Report#Configuring_Cell_Type_in_XLS_Reports [^]
But, for the core reports this configuration is not good, since the reports must be modified manually one by one, and must included in custom modules.

It would be nice to have a preference to configurate if you need to export to microsoft excel or libre office calc
Steps To Reproducegenerate a core report in xls format. Realize that the numeric values are shown as text values
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0031676 closedcaristu Some values are not shown in XLS format after Jasper Library Upgrade using Microsoft Office 2007 
related to defect 0031710 closedcollazoandy4 Review XLS reports to apply cell type when required 

-  Notes
(0089269)
caristu (developer)
2016-08-22 08:30

 See issue 0031684

The "Detect Cell Type" feature was not working properly for BigInteger values in Office after the Jasper Library Upgrade. This caused the values were not being displayed when opening the reports with MS Office.

To solve this problem the "Detect Cell Type feature was disabled. This way, by default, all the values in the XLS will be exported as strings. This ensures that the values are always being displayed after opening the report with Office/LibreOffice.

If we would allow to disable this behavior with a preference, then the problem solved on issue 0031684 could be reproduced again.

If any report requires to override this default configuration, this can be done as explained here[1].

[1] http://wiki.openbravo.com/wiki/How_to_create_a_Report#Configuring_Cell_Type_in_XLS_Reports [^]
(0090382)
egoitz (developer)
2016-09-29 16:40

 One possible option could be to allow the users to override that and other properties with a custom jasperreports.properties file.

- Issue History
Date Modified Username Field Change
2016-08-18 16:45 rbianchini New Issue
2016-08-18 16:45 rbianchini Assigned To => platform
2016-08-18 16:45 rbianchini Modules => Core
2016-08-18 16:45 rbianchini Triggers an Emergency Pack => No
2016-08-22 08:30 caristu Review Assigned To => caristu
2016-08-22 08:30 caristu Note Added: 0089269
2016-08-22 08:30 caristu Status new => closed
2016-08-22 08:30 caristu Resolution open => no change required
2016-08-23 08:22 caristu Status closed => new
2016-08-23 08:22 caristu Resolution no change required => open
2016-08-23 08:29 caristu Relationship added related to 0031684
2016-08-23 08:32 caristu Relationship deleted related to 0031684
2016-08-23 08:33 caristu Relationship added related to 0031676
2016-08-23 08:33 caristu Relationship added depends on 0031710
2016-08-24 08:17 caristu Relationship deleted depends on 0031710
2016-08-24 08:17 caristu Relationship added related to 0031710
2016-08-24 15:51 caristu Review Assigned To caristu =>
2016-09-29 16:40 egoitz Note Added: 0090382
2022-02-01 08:09 alostale Assigned To platform => Triage Platform Base

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker