aschott-looker opened a new pull request #229: URL: https://github.com/apache/poi/pull/229
* Negative numbers do not work as expected if they are used in the conditional part of a format string. For example, using `[<-10]#" Wow"` will blow up (poi thinks it is an elapsed time format). * The fix was pretty straightforward but Excel itself does not seem to support this case very well either. If you do `=TEXT(-20, [<-10]#" Wow")`, you'd expect an output of `-20 Wow` but you actually get `20 Wow`. Oddly enough, `>` works just fine. For example, `=TEXT(-5, [>-10]#" Wow")` correctly outputs `-5 Wow`. ---------------------------------------------------------------- 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: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
