[GitHub] [poi] RemboL opened a new pull request #181: make Value function work with arrays

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[GitHub] [poi] RemboL opened a new pull request #181: make Value function work with arrays

GitBox

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:
[hidden email]



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]