https://bugs.documentfoundation.org/show_bug.cgi?id=161015
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #2 from Mike Kaganski <[email protected]> --- (In reply to b. from comment #0) > roundup of small values to digits like -309 shouldn't result > in '0' but rather in a meaningful ERR, This is reasonable. > IMHO also roundup( 1.2E+308, -308 ) -> 1.2E+308 isn't correct, It should give an overflow (#NUM!), same way as e.g. '=1e308 * 5'. In my testing, gnumeric gave even more questionable '1e308' here, but that doesn't matter. > also round( 1.7E+308, -308) -> 1.7E+308 is questionaböe from > a math POV. This is the same. Should give an overflow. For testing: 1. Try formula =ROUNDUP(1;-309) which is "round number 1 up to the next multiple of 1e309", which mathematically is 1e309, which is out of representable range. 2. Try formula =ROUNDUP(1.2E+308;-308) which is "round 1.2e308 up to the next multiple of 1e308", which mathematically is 2e308, which is out of representable range. -- You are receiving this mail because: You are the assignee for the bug.
