https://bz.apache.org/bugzilla/show_bug.cgi?id=62738
--- Comment #2 from Yegor Kozlov <ye...@dinom.ru> --- I think we can return java.util.concurrent.ThreadLocalRandom.current().nextDouble(bottom, top + 1). It is the right way to generate a random number in a range in Java 1.7+. Also, the code sets bottom to top if it is greater than it: if(bottom > top) { top = bottom; } This check changes the semantics of RANDBETWEEN. Excel returns #NUM! in such a case -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org