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 2018/03/29 11:35:47 UTC
[Bug 62230] New: Formula evaluation fails when using matrix
multiplication within SUM function call with #VALUE!
https://bz.apache.org/bugzilla/show_bug.cgi?id=62230
Bug ID: 62230
Summary: Formula evaluation fails when using matrix
multiplication within SUM function call with #VALUE!
Product: POI
Version: 3.16-FINAL
Hardware: PC
OS: Linux
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: ak.azad@gmail.com
Target Milestone: ---
Created attachment 35823
--> https://bz.apache.org/bugzilla/attachment.cgi?id=35823&action=edit
test cases with screen shots
Similar to bug https://bz.apache.org/bugzilla/show_bug.cgi?id=61116 .
Please check the attached pdf for visual detail.
How could I download the intermediate build to test, I could only test with
3.17-Final where this bug still remains.
--
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 62230] Formula evaluation fails when using matrix
multiplication within SUM function call with #VALUE!
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62230
Alexander Vitkovskiy <sa...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--
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 62230] Formula evaluation fails when using matrix
multiplication within SUM function call with #VALUE!
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62230
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|NEW |RESOLVED
--- Comment #4 from Yegor Kozlov <ye...@dinom.ru> ---
The problem is no longer reproducible with the latest build from trunk. There
have been improvements in evaluation of array formulas which seem to have fixed
this.
Yegor
--
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 62230] Formula evaluation fails when using matrix
multiplication within SUM function call with #VALUE!
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62230
--- Comment #2 from azad <ak...@gmail.com> ---
Created attachment 35835
--> https://bz.apache.org/bugzilla/attachment.cgi?id=35835&action=edit
source and input files
--
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 62230] Formula evaluation fails when using matrix
multiplication within SUM function call with #VALUE!
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62230
--- Comment #3 from azad <ak...@gmail.com> ---
(In reply to Javen O'Neal from comment #1)
> POI array formula support definitely needs some love.
>
> Would you be willing to write a unit test demonstrating the problem? With
> that, we'd be halfway to a solution.
>
> This might be a good place to write it:
> https://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/ss/
> formula/eval/TestFormulaBugs.java?view=log
Hi,
I have added my own test source and input files.
I hope you find it easy to reproduce the situation.
--
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 62230] Formula evaluation fails when using matrix
multiplication within SUM function call with #VALUE!
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62230
Javen O'Neal <on...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Javen O'Neal <on...@apache.org> ---
POI array formula support definitely needs some love.
Would you be willing to write a unit test demonstrating the problem? With that,
we'd be halfway to a solution.
This might be a good place to write it:
https://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/ss/formula/eval/TestFormulaBugs.java?view=log
--
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