Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033743Openbravo ERPA. Platformpublic2016-08-18 16:452022-02-01 08:09
Reporterrbianchini 
Assigned ToTriage Platform Base 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version3.0PR16Q2.1 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033743: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0031676 closed caristu Some values are not shown in XLS format after Jasper Library Upgrade using Microsoft Office 2007 
related to defect 0031710 closed collazoandy4 Review XLS reports to apply cell type when required 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-08-18 16:45rbianchiniNew Issue
2016-08-18 16:45rbianchiniAssigned To => platform
2016-08-18 16:45rbianchiniModules => Core
2016-08-18 16:45rbianchiniTriggers an Emergency Pack => No
2016-08-22 08:30caristuReview Assigned To => caristu
2016-08-22 08:30caristuNote Added: 0089269
2016-08-22 08:30caristuStatusnew => closed
2016-08-22 08:30caristuResolutionopen => no change required
2016-08-23 08:22caristuStatusclosed => new
2016-08-23 08:22caristuResolutionno change required => open
2016-08-23 08:29caristuRelationship addedrelated to 0031684
2016-08-23 08:32caristuRelationship deletedrelated to 0031684
2016-08-23 08:33caristuRelationship addedrelated to 0031676
2016-08-23 08:33caristuRelationship addeddepends on 0031710
2016-08-24 08:17caristuRelationship deleteddepends on 0031710
2016-08-24 08:17caristuRelationship addedrelated to 0031710
2016-08-24 15:51caristuReview Assigned Tocaristu =>
2016-09-29 16:40egoitzNote Added: 0090382
2022-02-01 08:09alostaleAssigned Toplatform => Triage Platform Base

Notes
(0089269)
caristu   
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   
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.