RemboL opened a new pull request #181:
URL: https://github.com/apache/poi/pull/181


   I noticed that value function doesn't work well (or at all) with array 
formulas. It was pretty frustrating when we tried to evaluate array formula 
like "=SUM(VALUE($B$2:$B$4))" and got error, when in Ms Excel and in Libre 
Office it works fine.
   
   Side note: I see that there are already multiple functions implementing 
similar solution, maybe this should be a generic mechanism in Fixed1ArgFunction?


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to