Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0039367Openbravo ERP09. Financial managementpublic2018-09-27 17:482018-12-11 20:22
anderaranguren 
markmm82 
urgentmajoralways
closedfixed 
5
 
3.0PR19Q1 
Sandrahuguet
Core
No
0039367: Product name is cut when exporting to excel in Trial Balance
Product name is cut when exporting to excel in Trial Balance
Login 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
No tags attached.
png productName.png (132,940) 2018-10-03 09:20
https://issues.openbravo.com/file_download.php?file_id=12225&type=bug
png
Issue History
2018-09-27 17:48anderarangurenNew Issue
2018-09-27 17:48anderarangurenAssigned To => Triage Finance
2018-09-27 17:48anderarangurenModules => Core
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: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 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