tracker issue : CF-4183980

select a category, or use search below
(searches all categories and all time range)
Title:

Spreadsheet Formula Bug

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/DesignLimitation

Reporter/Name(from Bugbase): Milind Joshi / Milind Joshi (Milind Joshi)

Created: 08/25/2016

Components: Document Management, Office Integration

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Major / All users will encounter

Locale/System: ALL / Win 2012 Server x64

Vote Count: 0

Problem Description:
I am using ColdFusion 11 and trying to use FDIST function in a spreadsheet to get F-distribution value. The error I'm getting is that, it does not like the semicolon in the formula. In the exception.log file I see this error, org.apache.poi.ss.formula.FormulaParseException: Parse error near char 7 ';' in specified formula 'FDIST(1;4;5)'. Expected ',' or ')'

Steps to Reproduce:
Use the following code to reproduce the error. 

<cfset sObj = SpreadsheetNew()>
<cfset sFormula = "FDIST(1;4;5)">
<cfset spreadsheetSetCellFormula(sObj, sFormula, 1, 1)>
<cfset iValue = spreadsheetGetCellValue(sObj, 1, 1)>
<cfoutput>
<p>Value = #iValue#</p>
</cfoutput>

Actual Result:
Server throws error, "org.apache.poi.ss.formula.FormulaParseException: Parse error near char 7 ';' in specified formula 'FDIST(1;4;5)'. Expected ',' or ')'"

Expected Result:
The result should be "0.485657"

Any Workarounds:
No workaround

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4183980

External Customer Info:
External Company:  
External Customer Name: Milind Joshi
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments:

OpenOffice (instead of Microsoft Office) has been configured to be used by the server.
Comment by External U.
1959 | August 25, 2016 08:43:37 AM GMT
Note: FDIST not currently supported by Apache POI - https://poi.apache.org/spreadsheet/eval-devguide.html#appendixA
Comment by External U.
1960 | August 25, 2016 09:41:06 AM GMT
looks like "FDIST" is not supported yet, with POI v3.12 (used with CF2016). <cfscript> wrkbk_eval_obj = createObject("java","org.apache.poi.ss.formula.WorkbookEvaluator") ; itr = createObject("java","java.util.Iterator"); //supported functions f_coln = wrkbk_eval_obj.getSupportedFunctionNames(); itr = f_coln.iterator(); while(itr.hasNext()) writeOutput(itr.next() & "<br>"); writeOutput("<hr>"); //NOT supported functions f_coln = wrkbk_eval_obj.getNotSupportedFunctionNames(); itr = f_coln.iterator(); while(itr.hasNext()) writeOutput(itr.next() & "<br>"); </cfscript>
Comment by Piyush K.
1961 | August 28, 2016 08:52:28 AM GMT