Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0008513

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 09. Financial management

major

always

2009-04-08 17:09

2009-05-09 00:00

Reporter

networkb

View Status

public

Assigned To

iperdomo

Priority

immediate

Resolution

fixed

Fixed in Version

2.50MP1

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

2.40

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0008513: Number cells exported to excel are not recognised as numeric values

Description

In 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 Reproduce

1. 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.

Tags

Relationships [ Relation Graph ] [ Dependency Graph ]

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

Notes
(0015765) hgbot (developer) 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 (manager) 2009-05-08 17:07	Just changed the possibility to export cells as numbers. The report keeps working bad until the template changes

Issue History
Date Modified	Username	Field	Change
2009-04-08 17:09	networkb	New Issue
2009-04-08 17:09	networkb	Assigned To	=> rafaroda
2009-04-08 17:09	networkb	Regression testing	=> No
2009-04-08 17:27	rafaroda	Assigned To	rafaroda => gorkaion
2009-04-08 17:27	rafaroda	Priority	normal => immediate
2009-04-16 12:23	psarobe	Status	new => scheduled
2009-04-16 12:23	psarobe	fix_in_branch	=> pi
2009-04-23 12:31	gorkaion	Assigned To	gorkaion => iperdomo
2009-04-23 16:04	psarobe	Tag Attached: 250MP1
2009-04-27 11:47	hgbot	Checkin
2009-04-27 11:47	hgbot	Note Added: 0015765
2009-04-27 11:47	hgbot	Status	scheduled => resolved
2009-04-27 11:47	hgbot	Resolution	open => fixed
2009-04-27 11:47	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/dc6dd1057579e6a5fceb3a202eae62ff87f19e25 [^]
2009-05-08 17:04	iperdomo	Relationship added	related to 0008776
2009-05-08 17:07	psarobe	Status	resolved => closed
2009-05-08 17:07	psarobe	Note Added: 0016192
2009-05-09 00:00	anonymous	sf_bug_id	0 => 2789237

Copyright © 2000 - 2009 MantisBT Group