Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1157319

Summary:	Spreadsheet cell value by XLS function results in decimal fraction
Product:	[Retired] JBoss BRMS Platform 6	Reporter:	Toshiya Kobayashi <tkobayas>
Component:	BRE	Assignee:	Mario Fusco <mfusco>
Status:	CLOSED EOL	QA Contact:	Marek Winkler <mwinkler>
Severity:	high	Docs Contact:
Priority:	high
Version:	6.0.3	CC:	kverlaen, mfusco
Target Milestone:	ER2
Target Release:	6.1.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2020-03-27 20:08:41 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Toshiya Kobayashi 2014-10-27 03:04:10 UTC

Description of problem:

Platform BZ for https://issues.jboss.org/browse/DROOLS-643

If you use XLS functions (e.g. =ROW(), =SUM()) in Spreadsheet cells, the values (e.g. '10') are parsed to decimal fraction values (e.g. '10.0'). This doesn't occur in version 5.3.

Steps to Reproduce:
1. See unit test https://github.com/droolsjbpm/drools/pull/396

Actual results:

In the test case, 

'=ROW()' results in '11.0'
'=SUM(D10:D11)' results in '21.0'

Expected results:

'=ROW()' results in '11'
'=SUM(D10:D11)' results in '21'

Additional info:

This issue has been already fixed by BZ1156297 (commit: 68e510b6d) at the same time. I just opened this BZ because the sympton is different. So please move this BZ to MODIFIED once the test case is merged.

Comment 1 Mario Fusco 2014-10-27 16:20:58 UTC

Test case merged with https://github.com/droolsjbpm/drools/commit/095542ba76b546fb2f34be87f9aee5456a9b23f4

Comment 2 Marek Winkler 2014-12-09 12:11:33 UTC

Correction: fixed by fixing BZ 1145841 (BZ 1156297 is not related to this issue).

Verified in BRMS 6.1.0 ER2, the provided test case passes.