---------- Forwarded Message ---------- Date: Wed, 12 Jun 2013, 15:18:47 From: Andreas Guelzow <aguel...@pyrshep.ca>
I wrote: ---------------------------------------------------------- While the reporter is correct that there is a problem with exporting floor(x) as floor(x), the solution of exporting it as floor(x,1) is incorrect. In 2008 one could have exported it as floor(x,sign(x)) but under certain circumstances (for example if x involves a random number function) that would have been incorrect. As of Excel 2010, the correct solution would be to export it as FLOOR.PRECISE(x). ---------------------------------------------------------- This isn't right. FLOOR(x) should be exported as ROUNDDOWN(x,0), which would have worked in 2008 too. Andreas -- Andreas Guelzow <aguel...@pyrshep.ca> ----------------------------------------- -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
