Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037945Openbravo ERP09. Financial managementpublic2018-02-16 02:182018-02-16 02:18
Reportermatias-bernal 
Assigned ToTriage Omni OMS 
PrioritynormalSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037945: Export to excel in Trial Balance
DescriptionCombined cells in excel file downloaded from trial balance report, that are wrong drawed (See attachment).
Steps To Reproduce1- In trial balance window
2- Use in filters:
 * From=01-01-2017
 * To=31-12-2017
 * Organization= F&B España -Región Norte
 * General Ledger= F&B España, S.A USA/Euro
Use search button.
3- Then you can use "Export to Excel" button.
4- In the file downloaded you can se this problem.
Proposed SolutionChange in the file

src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml

<textField>
 <reportElement mode="Opaque" x="545" y="84" width="96" height="15" forecolor="#000000" backcolor="#FFFFFF" uuid="635c7994-6b22-4775-983f-e6b564459e3d"/>
 <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
 <font fontName="Bitstream Vera Sans" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
 <paragraph lineSpacing="Single"/>
 </textElement>
 <textFieldExpression><![CDATA[$P{DATE_TO}]]></textFieldExpression>
</textField>

to:

<textField>
 <reportElement mode="Opaque" x="279" y="84" width="96" height="15"
forecolor="#000000" backcolor="#FFFFFF" uuid="f1e80c42-eb88-4f1b-8b61-1a2d85b15dd1"/>
 <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None"
markup="none">
 <font fontName="Bitstream Vera Sans" size="10" isBold="false" isItalic="false"
isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica"
pdfEncoding="Cp1252" isPdfEmbedded="false"/>
 <paragraph lineSpacing="Single"/>
 </textElement>
 <textFieldExpression><![CDATA[$P{DATE_FROM}]]></textFieldExpression>
</textField>
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng 2018-01-31_101501.png (66,161) 2018-02-16 02:18
https://issues.openbravo.com/file_download.php?file_id=11587&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2018-02-16 02:18matias-bernalNew Issue
2018-02-16 02:18matias-bernalAssigned To => Triage Finance
2018-02-16 02:18matias-bernalFile Added: 2018-01-31_101501.png
2018-02-16 02:18matias-bernalModules => Core
2018-02-16 02:18matias-bernalTriggers an Emergency Pack => No

There are no notes attached to this issue.