Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008513Openbravo ERP09. Financial managementpublic2009-04-08 17:092009-05-09 00:00
Reporternetworkb 
Assigned Toiperdomo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.50MP1 
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
Summary0008513: Number cells exported to excel are not recognised as numeric values
DescriptionIn Report General Ledger and Report General Legder Journal, if information is exported to a xls file, then numeric values are recognised by Strings instead of Numbers.

That makes the exportation useless, because you cannot do any arithmetic operations whithin the file.

Keep in mind that the value should also maintain the number format (="#,##0.00", for example) in case it is needed.

This happens also in every jasper report of the application which wants to be exported to excel. This is very common and a feature requested by almost all customers.
Steps To Reproduce1. Go to Financial Management || Accounting || Analysis Tools || General Ledger Journal
2. Click on HTML format and see the results
3. Click on "export to excel" button.
4. Save the file, open it and try to sum two values
5. These values are not recognized as numbers, but Strings.
Proposed Solution
Additional Information
Tags250MP1
Relationships
depends on backport 0008595 closed iperdomo Number cells exported to excel are not recognised as numeric values 
related to feature request 0008776 closed iperdomo Improve the number format handling on jasper report based reports 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-04-08 17:09networkbNew Issue
2009-04-08 17:09networkbAssigned To => rafaroda
2009-04-08 17:09networkbRegression testing => No
2009-04-08 17:27rafarodaAssigned Torafaroda => gorkaion
2009-04-08 17:27rafarodaPrioritynormal => immediate
2009-04-16 12:23psarobeStatusnew => scheduled
2009-04-16 12:23psarobefix_in_branch => pi
2009-04-23 12:31gorkaionAssigned Togorkaion => iperdomo
2009-04-23 16:04psarobeTag Attached: 250MP1
2009-04-27 11:47hgbotCheckin
2009-04-27 11:47hgbotNote Added: 0015765
2009-04-27 11:47hgbotStatusscheduled => resolved
2009-04-27 11:47hgbotResolutionopen => fixed
2009-04-27 11:47hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/dc6dd1057579e6a5fceb3a202eae62ff87f19e25 [^]
2009-05-08 17:04iperdomoRelationship addedrelated to 0008776
2009-05-08 17:07psarobeStatusresolved => closed
2009-05-08 17:07psarobeNote Added: 0016192
2009-05-09 00:00anonymoussf_bug_id0 => 2789237

Notes
(0015765)
hgbot   
2009-04-27 11:47   
Repository: erp/devel/pi
Changeset: dc6dd1057579e6a5fceb3a202eae62ff87f19e25
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Mon Apr 27 11:47:12 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/dc6dd1057579e6a5fceb3a202eae62ff87f19e25 [^]

Fixes issue 8513: Added detect cell type when exporting to excel

---
M src/org/openbravo/base/secureApp/HttpSecureAppServlet.java
---
(0016192)
psarobe   
2009-05-08 17:07   
Just changed the possibility to export cells as numbers. The report keeps working bad until the template changes