Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015329Openbravo ERP08. Project and service managementpublic2010-11-30 13:002011-02-28 19:47
Reporternetworkb 
Assigned Toadrianromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionProfessional Appliance
Product Version2.50MP23 
Target Version2.50MP26Fixed in Version2.50MP27 
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
Summary0015329: 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
TagsNo tags attached.
Relationships
depends on defect 0015798 closed adrianromero Quantity column in Expense Sheet Lines when exporting to excel 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-11-30 13:00networkbNew Issue
2010-11-30 13:00networkbAssigned To => adrianromero
2010-11-30 13:00networkbModules => Core
2010-11-30 13:00networkbOBNetwork customer => Yes
2010-11-30 13:00networkbIssue Monitored: emartinez
2010-11-30 13:04networkbNote Added: 0032912
2011-01-27 13:32adrianromeroStatusnew => scheduled
2011-01-27 13:32adrianromeroTypedefect => backport
2011-01-27 13:32adrianromeroIssue cloned0015798
2011-01-27 13:32adrianromeroRelationship addeddepends on 0015798
2011-02-02 11:41hgbotCheckin
2011-02-02 11:41hgbotNote Added: 0034009
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/stable/2.50/rev/f921b6444ba715597c241f2bcb29fab310f34f48 [^]
2011-02-02 11:50ioritzCiaNote Added: 0034010
2011-02-28 19:47jonalegriaesarteNote Added: 0034445
2011-02-28 19:47jonalegriaesarteStatusresolved => closed
2011-02-28 19:47jonalegriaesarteFixed in Version => 2.50MP27

Notes
(0032912)
networkb   
2010-11-30 13:04   
This happens in other places of the application. Specifically, in all windows where the lines are exported to excel, (e.g Sales Order Lines, Sales Invoice Lines, etc).
(0034009)
hgbot   
2011-02-02 11:41   
Repository: erp/stable/2.50
Changeset: f921b6444ba715597c241f2bcb29fab310f34f48
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Tue Feb 01 16:23:22 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/f921b6444ba715597c241f2bcb29fab310f34f48 [^]

Fixes issue 15329: Quantity column in Expense Sheet Lines when exporting to excel.

---
M src/org/openbravo/erpCommon/utility/ExportGrid.java
---
(0034010)
ioritzCia   
2011-02-02 11:50   
* 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.
(0034445)
jonalegriaesarte   
2011-02-28 19:47   
Verified