Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Excel report bug?
-
Placing function "PROPER" in one cell causes Mango to fail report creation:
Failure: Error evaluating cell
I do not know if other functions are also causing this but easily repeatable by placing "=PROPER(A2)" in cell A1 and running the report.
I dont think Mango should care for the contets of cells? It should only be looking for named ranges as I understand it....
-
Hi sjobbe,
These functions are implemented in apache-poi, and it looks like by version 3.10-FINAL (the one we package with Mango at the moment) these are not implemented.
The good news for you, however, is that that function is implemented in the current stable version, 3.13! I will make an issue for us to consider packaging that version of the apache poi library into the next Mango release, but in the meantime you can download version 3.13 from https://poi.apache.org/ and swap the Mango/lib/poi-3.10-FINAL.jar and two poi-ooxml jar files with the versions in the poi 3.13 release (such that you only have jars for one version in your lib folder). Hope this helps!
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login