You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2017/04/13 12:59:42 UTC

[Bug 60984] New: FormulaParser includes function names to the arguments for unknown functions

https://bz.apache.org/bugzilla/show_bug.cgi?id=60984

            Bug ID: 60984
           Summary: FormulaParser includes function names to the arguments
                    for unknown functions
           Product: POI
           Version: 3.15-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: e.aivaloglou@tudelft.nl
  Target Milestone: ---

When parsing 2-argument formula _xll.HEAT($B3,$C3), FormulaParser creates an
org.apache.poi.ss.formula.ptg.FuncVarPtg [#external# nArgs=3] token with
_numberOfArgs = 3 and 3 children, the first of which contains the function name
(a org.apache.poi.ss.formula.ptg.NameXPxg [sheet=null ! name=_xll.HEAT] token).

_xll.HEAT is an Excel add-in function, but he same applies to UDF functions, eg
for formula myUDF(23, F4).

Is this intentional? The parse tree structure does not seem correct, because it
is inconsistent with the case of build-in Excel functions, whose arguments in
the parse tree only include actual arguments and not the function name.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60984] FormulaParser includes function names to the arguments for unknown functions

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60984

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 60984] FormulaParser includes function names to the arguments for unknown functions

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60984

Javen O'Neal <on...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |INVALID
             Status|NEW                         |RESOLVED

--- Comment #1 from Javen O'Neal <on...@apache.org> ---
Yes, external functions include the function name as the first token. This is
correct.
Adding are essentially a collection of UDFs. I believe this is how functions in
the AnalysisToolPak are parsed into tokens.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org