https://bz.apache.org/bugzilla/show_bug.cgi?id=69718
Bug ID: 69718
Summary: xval if not specified is giving error instead of
taking a default value
Product: POI
Version: 5.4.1-FINAL
Hardware: PC
OS: Mac OS X 10.1
Status: NEW
Severity: critical
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: parvathyskumar...@gmail.com
Target Milestone: ---
Created attachment 40049
--> https://bz.apache.org/bugzilla/attachment.cgi?id=40049&action=edit
A sample code where this behaviour can be seen
In both hssf and xssf, in multiple new functions introduced in POI, if the xval
is not given, the output goes to ERROR VALUE. This behaviour should be
redefined since Microsoft Excel takes the default value as 0 and evaluates the
output. I could see this behaviour in multiple functions - NORMSDIST, CEILING,
FLOOR and many more. Please validate these behaviour.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
