0015798: Quantity column in Expense Sheet Lines when exporting to excel

Description

When the lines of Expense Sheet are exported to excel, Quantity is exported as text format. This makes not possible to use it to make operations, such us sum up this value among different projects.

Steps To Reproduce

1) Go to Project & Service Management || Transactions || Expense Sheet || Header and create a header
2) Go to lines and create different lines
3) Go to grid and export to excel all the lines
4) If you open the excel with Microsoft Excel, you will notice an error in Quantity column that says something like "Numeric field exported as text".

Tags

closingMay2011

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

backport

0015329

2.50MP26

closed

adrianromero

Quantity column in Expense Sheet Lines when exporting to excel

Notes
(0034008) hgbot (developer) 2011-02-02 11:41	Repository: erp/devel/pi Changeset: 36de0af50bf5f58dcce0b60c01a7604f450bf459 Author: Ioritz Cia <ioritz.cia <at> openbravo.com> Date: Tue Feb 01 16:20:44 2011 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/36de0af50bf5f58dcce0b60c01a7604f450bf459 [^] Fixes issue 15798: Quantity column in Expense Sheet Lines when exporting to excel. --- M src/org/openbravo/erpCommon/utility/ExportGrid.java ---

(0034011) ioritzCia (developer) 2011-02-02 11:51	* Testing the issue - Go to Project & Service Management \|\| Transactions \|\| Expense Sheet \|\| Header and create a header - Go to lines and create different lines - Go to grid and export to excel all the lines - If you open the excel, you must be able to make operations with the quantities, for example include column in a sum function. * Other areas affected - Any other grid exporting to excel with a column that has Quantity as a reference.

Issue History
Date Modified	Username	Field	Change
2011-01-27 13:32	adrianromero	New Issue
2011-01-27 13:32	adrianromero	Assigned To	=> adrianromero
2011-01-27 13:32	adrianromero	Modules	=> Core
2011-01-27 13:32	adrianromero	Issue generated from	0015329
2011-01-27 13:32	adrianromero	Relationship added	blocks 0015329
2011-01-27 13:33	adrianromero	Status	new => scheduled
2011-01-27 13:33	adrianromero	fix_in_branch	=> pi
2011-02-02 11:41	hgbot	Checkin
2011-02-02 11:41	hgbot	Note Added: 0034008
2011-02-02 11:41	hgbot	Status	scheduled => resolved
2011-02-02 11:41	hgbot	Resolution	open => fixed
2011-02-02 11:41	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/36de0af50bf5f58dcce0b60c01a7604f450bf459 [^]
2011-02-02 11:51	ioritzCia	Note Added: 0034011
2011-05-24 10:08	dalsasua	Tag Attached: closingMay2011
2011-05-24 10:56	dalsasua	Status	resolved => closed