Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015329
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 08. Project and service managementminoralways2010-11-30 13:002011-02-28 19:47
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PrioritynormalResolutionfixedFixed in Version2.50MP27
StatusclosedFix in branchFixed in SCM revisionf921b6444ba7
ProjectionnoneETAnoneTarget Version2.50MP26
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
Product Version2.50MP23SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015329: 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".
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0015798 closedadrianromero Quantity column in Expense Sheet Lines when exporting to excel 

-  Notes
(0032912)
networkb (developer)
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 (developer)
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 (developer)
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 (reporter)
2011-02-28 19:47

 Verified

- Issue History
Date Modified Username Field Change
2010-11-30 13:00 networkb New Issue
2010-11-30 13:00 networkb Assigned To => adrianromero
2010-11-30 13:00 networkb Modules => Core
2010-11-30 13:00 networkb Issue Monitored: emartinez
2010-11-30 13:04 networkb Note Added: 0032912
2011-01-27 13:32 adrianromero Status new => scheduled
2011-01-27 13:32 adrianromero Type defect => backport
2011-01-27 13:32 adrianromero Issue cloned 0015798
2011-01-27 13:32 adrianromero Relationship added depends on 0015798
2011-02-02 11:41 hgbot Checkin
2011-02-02 11:41 hgbot Note Added: 0034009
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/stable/2.50/rev/f921b6444ba715597c241f2bcb29fab310f34f48 [^]
2011-02-02 11:50 ioritzCia Note Added: 0034010
2011-02-28 19:47 jonalegriaesarte Note Added: 0034445
2011-02-28 19:47 jonalegriaesarte Status resolved => closed
2011-02-28 19:47 jonalegriaesarte Fixed in Version => 2.50MP27

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker