Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037626Openbravo ERP04. Warehouse managementpublic2018-01-12 11:092018-02-22 18:18
Reportergorkaion 
Assigned Tocollazoandy4 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q2 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037626: Numbers in Valued Stock Report are exported to Excel as strings
DescriptionNumbers in Valued Stock Report are exported to Excel as strings
Steps To ReproduceAs group admin role:
   Go to Valued Stock Report
   Select any org
   Export to Excel
   Open the file and check the number values are exported with an apostrophe
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0031710 closed collazoandy4 Review XLS reports to apply cell type when required 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-01-12 11:09gorkaionNew Issue
2018-01-12 11:09gorkaionAssigned To => Triage Finance
2018-01-12 11:09gorkaionModules => Core
2018-01-12 11:09gorkaionResolution time => 1517526000
2018-01-12 11:09gorkaionTriggers an Emergency Pack => No
2018-01-12 11:11gorkaionRelationship addedrelated to 0031710
2018-01-12 11:59PracticsIssue Monitored: Practics
2018-01-12 13:52dmiguelezAssigned ToTriage Finance => collazoandy4
2018-01-12 17:15collazoandy4Statusnew => scheduled
2018-01-12 22:22collazoandy4Note Added: 0101684
2018-01-16 11:58hgbotCheckin
2018-01-16 11:58hgbotNote Added: 0101714
2018-01-16 11:58hgbotStatusscheduled => resolved
2018-01-16 11:58hgbotResolutionopen => fixed
2018-01-16 11:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8e83421e15ba8e98c8e5fc34440f4c57eef75e70 [^]
2018-01-16 11:59dmiguelezReview Assigned To => dmiguelez
2018-01-16 11:59dmiguelezNote Added: 0101716
2018-01-16 11:59dmiguelezStatusresolved => closed
2018-01-16 12:00dmiguelezFixed in Version => 3.0PR18Q2
2018-02-22 18:18hudsonbotCheckin
2018-02-22 18:18hudsonbotNote Added: 0102658

Notes
(0101684)
collazoandy4   
2018-01-12 22:22   
Test Plan
  As F&B International Group Admin Role
    Go to Valued Stock Report
    Select F&B España - Region Norte as organization
    Export the report to Excel
    Open the file and check the number values are exported as number
(0101714)
hgbot   
2018-01-16 11:58   
Repository: erp/devel/pi
Changeset: 8e83421e15ba8e98c8e5fc34440f4c57eef75e70
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Mon Jan 15 12:28:10 2018 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/8e83421e15ba8e98c8e5fc34440f4c57eef75e70 [^]

Fixes issue 37626:Numbers in Valued Stock Report are exported as strings

The number columns of Valued Stock Report was exporting to text in xls format.

The net.sf.jasperreports.export.xls.detect.cell.type property was added to the report
with a true value. Also the pattern "#,##0.00;-#,##0.00" was included to the fields.

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStockExcel.jrxml
---
(0101716)
dmiguelez   
2018-01-16 11:59   
Code Review + Testing Ok
(0102658)
hudsonbot   
2018-02-22 18:18   
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/980a6ad5bbf5 [^]
Maturity status: Test