poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 45808] New: POI can't handled add-in functions (functions not present in workbook)
Date Mon, 15 Sep 2008 14:07:38 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=45808

           Summary: POI can't handled add-in functions (functions not
                    present in workbook)
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: antti.koskimaki@joinex.com


Created an attachment (id=22566)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=22566)
source and excel to re-produce the bug

We are using POI to generate input to third party tools that use excel add-in
as an interface to external system.

POI currently has trouble handling functions not present in workbook.

If function is already present in excel, and we're just trying to update its
parameters, we'll get exception:

FormulaParser$FormulaParseException: Attempt to use name 'SomeAddinFunction' as
a function, but defined name in workbook does not refer to a function.

Preferable we would like to insert those functions into blank workbook, but it
results another exception:

FormulaParser$FormulaParseException: Name 'SomeAddinFunction2' is completely
unknown in the current workbook

In addition, we would like to evaluate all (other) functions present in
workbook, but any references (direct or indirect) to those unknown functions
leads to exception:

FormulaParser$FormulaParseException: Attempt to use name 'SomeAddinFunction' as
a function, but defined name in workbook does not refer to a function.

Tested latest with svn r695420, source to re-produce attached.


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


Mime
View raw message