Thanks PJ Fanning and Stanton Fisque for your comments.
I must say that for me it would be a sad news if POI withdraws from
supporting excel formulas evaluations. The company I work for uses POI for
more than 10 years to process excel files. Being able to evaluate excel
workbooks in java and have
there is a use case, and i have used it, so i will raise a counter comment for
POI to retain running calculations:
i had a project where i built a harness to load an excel spreadsheet and then
exercise it as a system of record. if POI were to lose the ability to perform
that function, it would
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #15 from PJ Fanning ---
I think it was a big mistake for POI to start evaluating formulas. It is too
complicated and there are not enough devs interested. It doesn't just take
someone to submit a change. It takes multiple people to
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
Jakub changed:
What|Removed |Added
CC||jakub.vojti...@gmail.com
--- Comment #14 from
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
PJ Fanning changed:
What|Removed |Added
CC||lauri4...@gmail.com
--- Comment #13 from
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
raghavi changed:
What|Removed |Added
CC||raghav...@gofrugal.com
--
You are receiving
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
Mark Murphy changed:
What|Removed |Added
Status|NEEDINFO|NEW
--
You are receiving this mail beca
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #12 from mewa...@gmail.com ---
Calling all coders who want more money: who is willing to fix this bug for a
bounty?
I have to admit I am surprised that there hasn't been more attention being paid
to what appears to be a fundamental
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #11 from mewa...@gmail.com ---
Looking at the syntax in
https://msdn.microsoft.com/en-us/library/dd906358(v=office.12).aspx, then,
assuming that "Unary Minus" is equivalent in the POI grammer as "sign" in the
MSFT site's grammar, it
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #10 from mewa...@gmail.com ---
the plot thickens.
Using the below example, when cell A3 is changed to be:
=SUMPRODUCT(--(B4:B6))
then, as before, evaluation of that throws an error.
However, when cell A3 contains
=SUMPRODU
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #9 from mewa...@gmail.com ---
If any developers are interested in fixing this for a $ bounty, please send me
a proposal at mewa...@gmail.com
--
You are receiving this mail because:
You are the assignee for the bug.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #8 from mewa...@gmail.com ---
I will try to take a look. the main (at least initial) limitation on my ability
to do so is that I'm pretty unfamiliar with the Java build process (I'm mostly
a C programmer and stick with emacs + cc + m
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #7 from Greg Woolsey ---
The current logic is completely dependent on the internal class type of of the
first argument. As I mentioned, the problem is with the unary negation
operator (minus). I haven't tested it, but I suspect th
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #6 from mewa...@gmail.com ---
Thank you for the comment
Out of curiosity, why is the processing wrt the first argument different from
that wrt subsequent arguments? Note that if we do:
=SUMPRODUCT(A5:A20, --(B5:B20))
then even t
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
Greg Woolsey changed:
What|Removed |Added
Version|3.15-FINAL |3.16-dev
--- Comment #5 from Greg Wools
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #4 from mewa...@gmail.com ---
Please ignore the reference to "good.xlsx" in comment 2. It was meant to be
removed before it was sent.
--
You are receiving this mail because:
You are the assignee for the bug.
---
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #3 from mewa...@gmail.com ---
Created attachment 34860
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34860&action=edit
bad.xlsx
bad.xlsx as described in prior comment. It has no contents other than one
formula in cell A3: =
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
--- Comment #2 from mewa...@gmail.com ---
It's as simple as evaluating a sumproduct whose first arg starts with --.
--- Sample files ---
bad.xlsx: in A3, set formula to
=SUMPRODUCT(--(B5:B20))
--- Test results ---
Running the sample code
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
Dominik Stadler changed:
What|Removed |Added
Status|NEW |NEEDINFO
--- Comment #1 from Dominik
19 matches
Mail list logo
