Summary: | Calc ROUND() don't use default IEEE 754 method (-> statistical error). | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | lo_bugs |
Component: | LibreOffice | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | himajin100000, robinson.libreoffice |
Priority: | medium | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=126481 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108827 |
Description
lo_bugs
2013-02-26 15:28:00 UTC
Because the standard 5/4 rounding is more useful for spreadsheets. (In reply to comment #1) > Because the standard 5/4 rounding is more useful for spreadsheets. What's more "useful" is given by the use case. However, the word "useful" is not even correct here. In statistical problems, for which you can use LO Calc, the "always round up on .5" method is simply wrong, not just unuseful! If you feel better, then take this as a simple feature request, not as a bug. Or if you want to be more "bureaucratic": Currently LO Calc is not IEEE 754 conform (pretty bad for a computer program, IMHO), because it only has the three non-default methods of IEEE 754: round always down, round always up and round up on ".5" But it is completly missing the IEEE 754 rounding of on .5 round to the even number (and this is even the default of IEEE 754). Perhaps there could be an option to select IEEE-754 mode in spreadsheets? Marking as enhancement Status -> NEW seems the enum value rtl_math_RoundingMode_HalfEven is used nowhere https://opengrok.libreoffice.org/s?refs=rtl_math_RoundingMode_HalfEven&project=core Don't use default information. I am fetch many https://www.superiorpapers.com/programming.php files because these files are ever have something necessary and important for us which can be good whenever we use where it is good to handle this whole information. Sharing information with others is good. Good work! Always fascinated with these kind of content and proofreading-practice https://essaysbank.com/proofreading-practice Get over here to download the free solutions of the NCERT book class 10 ncert solutions. This website provides us with complete solutions of NCERT class 10th at free cost. https://fullncertsolutions.in/ncert-solutions-for-class-10 If you are looking for a professional who will write an essay for you, go to this site https://ca.essaywritingstore.com/ . I recommend it because I work there as a freelancer and write essays for students. |