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

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org



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

[GitHub] [poi] asfgit closed pull request #181: make Value function work with arrays

[GitBox <gi...@apache.org>]

asfgit closed pull request #181:
URL: https://github.com/apache/poi/pull/181


   


----------------------------------------------------------------
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:
users@infra.apache.org



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