Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015798Openbravo ERP08. Project and service managementpublic2011-01-27 13:322011-05-24 10:56
Reporteradrianromero 
Assigned Toadrianromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionProfessional Appliance
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015798: Quantity column in Expense Sheet Lines when exporting to excel
DescriptionWhen 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 Reproduce1) 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".
Proposed Solution
Additional Information
TagsclosingMay2011
Relationships
blocks backport 00153292.50MP26 closed adrianromero Quantity column in Expense Sheet Lines when exporting to excel 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-01-27 13:32adrianromeroNew Issue
2011-01-27 13:32adrianromeroAssigned To => adrianromero
2011-01-27 13:32adrianromeroModules => Core
2011-01-27 13:32adrianromeroOBNetwork customer => Yes
2011-01-27 13:32adrianromeroIssue generated from0015329
2011-01-27 13:32adrianromeroRelationship addedblocks 0015329
2011-01-27 13:33adrianromeroStatusnew => scheduled
2011-01-27 13:33adrianromerofix_in_branch => pi
2011-02-02 11:41hgbotCheckin
2011-02-02 11:41hgbotNote Added: 0034008
2011-02-02 11:41hgbotStatusscheduled => resolved
2011-02-02 11:41hgbotResolutionopen => fixed
2011-02-02 11:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/36de0af50bf5f58dcce0b60c01a7604f450bf459 [^]
2011-02-02 11:51ioritzCiaNote Added: 0034011
2011-05-24 10:08dalsasuaTag Attached: closingMay2011
2011-05-24 10:56dalsasuaStatusresolved => closed

Notes
(0034008)
hgbot   
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   
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.