https://bz.apache.org/bugzilla/show_bug.cgi?id=61252
Bug ID: 61252
Summary: Error evaluating formulas with more of 30 arguments on
excel file 2007 or major.
Product: POI
Version: 3.15-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Hi
using Poi 3.15 we have a problem with the evaluation of the formulas with more
than 30 arguments(in our user case we have a SUM operand).
Taking a look to the code we have seen that in the class
MultiOperandNumericFunction.java there is a constant value
DEFAULT_MAX_NUM_OPERANDS = 30.
this value is used during the evaluation of the formulas to check the maximum
number of arguments. According to us should be better to use the value retrieve
from the class SpreadsheetVersion.java but fix in this way the problem require
a lot of changes on the code.
Considering that 30 was the maximum number of arguments of Excel 97, a very old
version, could be more reasonable to use 255 instead that is the limit for
Excel 2007 or major.
The fix using the limit of 255 is very fast and safe.
we looking forward for your feedback
Best Regards
Floriano
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
