Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039367Openbravo ERP09. Financial managementpublic2018-09-27 17:482018-12-11 20:22
Reporteranderaranguren 
Assigned Tomarkmm82 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q1 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket4944
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039367: Product name is cut when exporting to excel in Trial Balance
DescriptionProduct name is cut when exporting to excel in Trial Balance
Steps To ReproduceLogin in the Backend
Go to Product window and change the name of 'Cerveza Ale 0,5L' for 'Cerveza Ale 0,5L length test for the product name'
Go to 'Trial Balance' window
Select fields:
 From 02-10-2018
 To 02-10-2018
 Organization F&B España, S.A.
 Product Cerveza Ale 0,5L length test for the product name
Press the 'Export to Excel' button
See that the product name is cut
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng productName.png (132,940) 2018-10-03 09:20
https://issues.openbravo.com/file_download.php?file_id=12225&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2018-09-27 17:48anderarangurenNew Issue
2018-09-27 17:48anderarangurenAssigned To => Triage Finance
2018-09-27 17:48anderarangurenOBNetwork customer => Yes
2018-09-27 17:48anderarangurenModules => Core
2018-09-27 17:48anderarangurenSupport ticket => 4797
2018-09-27 17:48anderarangurenResolution time => 1539813600
2018-09-27 17:48anderarangurenTriggers an Emergency Pack => No
2018-09-27 17:56SandrahuguetAssigned ToTriage Finance => markmm82
2018-10-03 01:55markmm82Statusnew => scheduled
2018-10-03 08:53anderarangurenSupport ticket4797 =>
2018-10-03 08:53anderarangurenSummaryProduct name is cut when exporting to excel in Trial Balance => Account name is cut when exporting to excel in Trial Balance
2018-10-03 08:53anderarangurenDescription Updatedbug_revision_view_page.php?rev_id=17728#r17728
2018-10-03 08:53anderarangurenSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17730#r17730
2018-10-03 08:53anderarangurenFile Added: BackEnd.png
2018-10-03 08:53anderarangurenFile Added: libreOffice.png
2018-10-03 09:20anderarangurenSummaryAccount name is cut when exporting to excel in Trial Balance => Product name is cut when exporting to excel in Trial Balance
2018-10-03 09:20anderarangurenDescription Updatedbug_revision_view_page.php?rev_id=17731#r17731
2018-10-03 09:20anderarangurenSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17732#r17732
2018-10-03 09:20anderarangurenFile Deleted: BackEnd.png
2018-10-03 09:20anderarangurenFile Deleted: libreOffice.png
2018-10-03 09:20anderarangurenFile Added: productName.png
2018-10-03 09:21anderarangurenSupport ticket => 4944
2018-10-03 19:11markmm82Note Added: 0107146
2018-10-05 14:40hgbotCheckin
2018-10-05 14:40hgbotNote Added: 0107188
2018-10-05 14:40hgbotStatusscheduled => resolved
2018-10-05 14:40hgbotResolutionopen => fixed
2018-10-05 14:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a4607c9c130c683626203f2e0b5c3b494b2231a4 [^]
2018-10-05 14:41SandrahuguetReview Assigned To => Sandrahuguet
2018-10-05 14:41SandrahuguetNote Added: 0107189
2018-10-05 14:41SandrahuguetStatusresolved => closed
2018-10-05 14:41SandrahuguetFixed in Version => 3.0PR19Q1
2018-12-11 20:22hudsonbotCheckin
2018-12-11 20:22hudsonbotNote Added: 0108421

Notes
(0107146)
markmm82   
2018-10-03 19:11   
Test Plan:
  Modify the following items to reach the maximum character length in the UI:
    Account Name = "Proveedores (euros) a corto plazo" to for example:
    "Proveedores (euros) a corto plazo1234567891234567891234567899888888555555222222666666622222222222222222222222222222222222222"
    Business Partner Name = "La Fruta es la Vida, S.L." to "La Fruta es la Vida, S.L.12345678912345678912345678912345678"
    Product Name = "Cerveza Ale 0,5L" to "Cerveza Ale 0,5L 1234567890123456789012345678901234567890123"

  Run the Trial Balance report in EXCEL format for dates between "03/10/2017" and "03/10/2018" for example.
  Notice in the generated excel that those lines related to the modified names have been stretched and the row is adapted to the cell with greater height.
(0107188)
hgbot   
2018-10-05 14:40   
Repository: erp/devel/pi
Changeset: a4607c9c130c683626203f2e0b5c3b494b2231a4
Author: Mark <markmm82 <at> gmail.com>
Date: Wed Oct 03 12:58:44 2018 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/a4607c9c130c683626203f2e0b5c3b494b2231a4 [^]

Fixes issue 39367:Set some columns to be stretched with overflow to avoid be cut

Some columns where cells can show long text are set as stretch with overflow and
with stretch type = "RelativeToTallestObject" to align and stretch correctly

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml
---
(0107189)
Sandrahuguet   
2018-10-05 14:41   
Code review + testing OK
(0108421)
hudsonbot   
2018-12-11 20:22   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/470e3cd384c5 [^]
Maturity status: Test