Well, ISBLANK() is an Excel function - https://support.office.com/en-us/article/IS-functions-0f2d7971-6019-40a0-a171-f2d869135665 - that will indicate whether or not a cell is blank. In addition, there is nothing at all preventing you from creating your own version of POI with that change made to the dereferenceResult() method. All you would need to do is obtain the source for the project, modify it and build your own local version. This page will get you started - https://poi.apache.org/howtobuild.html - and it may be a better option than waiting for a change to the project itself as that may require some discussion.
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/Import-Excel-How-to-get-a-blank-when-the-result-of-a-formula-is-blank-tp5721160p5721173.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
