[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2022-02-21 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848 PJ Fanning changed: What|Removed |Added CC||lauri4...@gmail.com --- Comment #13 from

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2018-02-02 Thread bugzilla
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

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2018-02-02 Thread bugzilla
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

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2018-04-09 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848 raghavi changed: What|Removed |Added CC||raghav...@gofrugal.com -- You are receiving

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2017-03-19 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Dominik

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2017-03-21 Thread bugzilla
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

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2017-03-21 Thread bugzilla
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: =

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2017-03-21 Thread bugzilla
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. ---

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2017-03-21 Thread bugzilla
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

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2017-03-21 Thread bugzilla
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

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2017-03-21 Thread bugzilla
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

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2017-03-21 Thread bugzilla
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

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2017-03-21 Thread bugzilla
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.

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2017-04-21 Thread bugzilla
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

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2017-04-21 Thread bugzilla
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

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2023-10-13 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60848 Jakub changed: What|Removed |Added CC||jakub.vojti...@gmail.com --- Comment #14 from

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2023-10-13 Thread bugzilla
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

Re: [Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2023-10-13 Thread stanton fisque
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

Re: [Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

2023-10-14 Thread Jakub Vojtíšek
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