Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013588Openbravo ERP09. Financial managementpublic2010-06-09 12:382010-06-17 00:00
Reporternetworkb 
Assigned Toiperdomo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP18 
Target Version2.50MP19Fixed in Version2.50MP19 
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
Summary0013588: Using VMWARE appliance, there is an error when exporting grid in Assets window
DescriptionIf you export assets window grid (to any format) you will realize that some columns have a incomplete label.
Steps To Reproduce1. Download 2.50MP18 vmware virtual appliance and run
2. Financial Management || Assets || Assets || Assets : create one asset, go to grid mode and press Export to Excel grid button (or any format):

*Check that label of 11th column is "Deprecia" instead of "Depreciate"
*Check that label of 26th column is "Depreciation" instead of "Depreciation Amount"
*Check that 2 last labels are "Depreciated" instead of "Depreciated value" and "Depreciated Plan".

That also happens in PDF and CSV format

[Same error reported in bug 13078 was solved for 250mp17, but it continue failing when using vmware]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 00130782.50MP17 closed balamurugan Error when exporting grid in Assets window 
Attached Filesxls ExportGrid.xls (14,336) 2010-06-14 13:12
https://issues.openbravo.com/file_download.php?file_id=2678&type=bug
csv ExportGrid.csv (559) 2010-06-14 13:12
https://issues.openbravo.com/file_download.php?file_id=2679&type=bug
pdf ExportGrid.pdf (6,142) 2010-06-14 13:12
https://issues.openbravo.com/file_download.php?file_id=2680&type=bug
csv Ubuntu-ExportGrid.csv (590) 2010-06-14 13:24
https://issues.openbravo.com/file_download.php?file_id=2681&type=bug
pdf Ubuntu-ExportGrid.pdf (6,159) 2010-06-14 13:25
https://issues.openbravo.com/file_download.php?file_id=2682&type=bug
xls Ubuntu-ExportGrid.xls (14,336) 2010-06-14 13:25
https://issues.openbravo.com/file_download.php?file_id=2683&type=bug
csv VM-ExportGrid.csv (537) 2010-06-14 14:04
https://issues.openbravo.com/file_download.php?file_id=2685&type=bug
pdf VM-ExportGrid.pdf (6,120) 2010-06-14 14:04
https://issues.openbravo.com/file_download.php?file_id=2686&type=bug
xls VM-ExportGrid.xls (14,336) 2010-06-14 14:04
https://issues.openbravo.com/file_download.php?file_id=2687&type=bug
csv ORA-ExportGrid.csv (561) 2010-06-14 14:12
https://issues.openbravo.com/file_download.php?file_id=2688&type=bug
pdf ORA-ExportGrid.pdf (6,159) 2010-06-14 14:13
https://issues.openbravo.com/file_download.php?file_id=2689&type=bug
xls ORA-ExportGrid.xls (14,336) 2010-06-14 14:13
https://issues.openbravo.com/file_download.php?file_id=2690&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-06-09 12:38networkbNew Issue
2010-06-09 12:38networkbAssigned To => dalsasua
2010-06-09 12:38networkbOBNetwork customer => Yes
2010-06-09 12:50dalsasuaNote Added: 0028207
2010-06-09 12:52dalsasuaRelationship addedhas duplicate 0013078
2010-06-09 13:11jpabloaeIssue Monitored: jpabloae
2010-06-09 13:32dalsasuaAssigned Todalsasua => adrianromero
2010-06-09 13:34dalsasuaNote Edited: 0028207bug_revision_view_page.php?bugnote_id=0028207#r478
2010-06-09 13:34dalsasuaNote Edited: 0028207bug_revision_view_page.php?bugnote_id=0028207#r479
2010-06-09 14:01networkbNote Added: 0028208
2010-06-09 16:54adrianromeroAssigned Toadrianromero => alostale
2010-06-09 16:55adrianromeroNote Added: 0028220
2010-06-09 17:26networkbNote Added: 0028222
2010-06-14 12:54iperdomoAssigned Toalostale => iperdomo
2010-06-14 12:55iperdomoStatusnew => scheduled
2010-06-14 12:55iperdomofix_in_branch => pi
2010-06-14 12:55iciordiaStatusscheduled => acknowledged
2010-06-14 13:11iperdomoNote Added: 0028362
2010-06-14 13:11iperdomoStatusacknowledged => scheduled
2010-06-14 13:12iperdomoFile Added: ExportGrid.xls
2010-06-14 13:12iperdomoFile Added: ExportGrid.csv
2010-06-14 13:12iperdomoFile Added: ExportGrid.pdf
2010-06-14 13:24iperdomoFile Added: Ubuntu-ExportGrid.csv
2010-06-14 13:25iperdomoFile Added: Ubuntu-ExportGrid.pdf
2010-06-14 13:25iperdomoFile Added: Ubuntu-ExportGrid.xls
2010-06-14 13:29iperdomoNote Added: 0028364
2010-06-14 14:04iperdomoNote Added: 0028366
2010-06-14 14:04iperdomoFile Added: VM-ExportGrid.csv
2010-06-14 14:04iperdomoFile Added: VM-ExportGrid.pdf
2010-06-14 14:04iperdomoFile Added: VM-ExportGrid.xls
2010-06-14 14:12iperdomoNote Added: 0028370
2010-06-14 14:12iperdomoFile Added: ORA-ExportGrid.csv
2010-06-14 14:13iperdomoFile Added: ORA-ExportGrid.pdf
2010-06-14 14:13iperdomoFile Added: ORA-ExportGrid.xls
2010-06-14 14:13iperdomoNote Added: 0028371
2010-06-14 14:13iperdomoStatusscheduled => feedback
2010-06-15 10:05iperdomoStatusfeedback => scheduled
2010-06-15 11:06hgbotCheckin
2010-06-15 11:06hgbotNote Added: 0028435
2010-06-15 11:06hgbotCheckin
2010-06-15 11:06hgbotNote Added: 0028436
2010-06-15 11:06hgbotStatusscheduled => resolved
2010-06-15 11:06hgbotResolutionopen => fixed
2010-06-15 11:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0e44f440ef7198b4b663c4bb349bceddf9fcdd50 [^]
2010-06-16 00:20hudsonbotCheckin
2010-06-16 00:20hudsonbotNote Added: 0028474
2010-06-16 00:20hudsonbotCheckin
2010-06-16 00:20hudsonbotNote Added: 0028475
2010-06-16 12:00marvintmNote Added: 0028493
2010-06-16 12:00marvintmStatusresolved => closed
2010-06-16 12:00marvintmFixed in Version => 2.50MP19
2010-06-17 00:00anonymoussf_bug_id0 => 3017331

Notes
(0028207)
dalsasua   
2010-06-09 12:50   
(edited on: 2010-06-09 13:34)
It is reproducible even in a normal erp instance. No need to install the virtual machine.

My environment: Ubuntu / Oracle / Firefox
(0028208)
networkb   
2010-06-09 14:01   
If you increase on the AD the length of the columns afected the grid is exported properly.
A possible solution is to define the width using the lengh of the field name (not lenght of the fied) exported, and not the lenght of the column exported.
(0028220)
adrianromero   
2010-06-09 16:55   
This error is also reproduced in pi, not only in the virtual appliance.
(0028222)
networkb   
2010-06-09 17:26   
After some tests it could be related with Tomcat: same local environment accessed trough eclipse shows proper names, accessed from outside tomcat shows cut names. FYI.
(0028362)
iperdomo   
2010-06-14 13:11   
The attached files are produced on an instance built from pi @ rev ae808d1e7781
(0028364)
iperdomo   
2010-06-14 13:29   
Ubuntu* files are generated from Openbravo Ubuntu package
(0028366)
iperdomo   
2010-06-14 14:04   
VM* files are generated from 2.50MP18 virtual appliance
(0028370)
iperdomo   
2010-06-14 14:12   
ORA* files are generated on Oracle instances based on pi @ rev ae808d1e7781
(0028371)
iperdomo   
2010-06-14 14:13   
Please confirm _all_ environment details. I cannot reproduce the error.
The 2.50MP18 virtual appliance is working fine.
(0028435)
hgbot   
2010-06-15 11:06   
Repository: erp/devel/pi
Changeset: c3208eb7eb119c4435e800dd494c4fae2addaa7f
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Tue Jun 15 10:38:16 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c3208eb7eb119c4435e800dd494c4fae2addaa7f [^]

Updated license, reformatted text. Related to issue 13588

---
M src/org/openbravo/erpCommon/utility/ExportGrid.java
---
(0028436)
hgbot   
2010-06-15 11:06   
Repository: erp/devel/pi
Changeset: 0e44f440ef7198b4b663c4bb349bceddf9fcdd50
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Tue Jun 15 10:57:17 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0e44f440ef7198b4b663c4bb349bceddf9fcdd50 [^]

Fixes issue 13588: Increased character width for column length calculation
Since we are not defining any style in plantilla.jrxml, to calculate the
column width we use the text of the column name multiplied by a factor
(character width). It seems that is a font configuration issue, is only
reproducible in some GNU/Linux environments with not all 'expected' ttf fonts
installed, e.g. rPath on the community appliance.

---
M src/org/openbravo/erpCommon/utility/ExportGrid.java
---
(0028474)
hudsonbot   
2010-06-16 00:20   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/c3208eb7eb11 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/3b320eca6d68 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17616.obx [^]
(0028475)
hudsonbot   
2010-06-16 00:20   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/0e44f440ef71 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/3b320eca6d68 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17616.obx [^]
(0028493)
marvintm   
2010-06-16 12:00   
Tested in a MP18 Virtual Appliance. Before, it didn't work. After updating to MP19 candidate, it worked correctly.