Dear Michael, I have to apologise for providing the wrong example. It should have been 2024.28*.146(I was distracted while writing, and forgot to check!!) CheersHarvey
On Sat, 2018-12-29 at 04:54 +1000, Michael D. Setzer II wrote: > Your numbers don't seem to match up on a bigger scale. > > Unfortunately, ths list reformats text, so headings will not > directly match with > the columns. > > > > > > Using the values in message gave in message the result is 299.04888 > as > shown, and the 3 digit of 8 causes it to round the 4 up to a 5, which > is > correct. > > Num 1 Num 2 Num 1 * Num 2 Rounded > > 2048.28 0.146 299.04888299.05 > > > > > > Here I recalculated the 2nd number to get the result you > show instead of the 0.146 value. Again Rounding is > correct. > > > > > > Num 1 Num 2 Calc Your Value?? Rounded > > 2048.28 0.144291210186107 295.5488 295.55 > > > > > > Same as above, but recalculated the 1st number?? > > > > > > Num 1 Calc Num 2 Your Value?? Rounded > > 2024.30684931507 0.146 295.5488 295.55 > > > > > > > > > > On 28 Dec 2018 at 18:26, Harvey Nimmo wrote: > > > > > > Subject: [libreoffice-users] Calc error? > > From: Harvey Nimmo <har...@nimmo.de> > > To: Users LibreOffice <users@global.libreoffice.o > rg> > > Date sent: Fri, 28 Dec 2018 18:26:17 +0100 > > > > > > > I'm running LO on OpenSuse and I wonder if anyone alse can confirm > this > > > error on calc. > > > > > > Multiplying 2048.28*.146 yields correctly 295.54488, but when > rounding > > > down to 2 decimal places, 295.55 is displayed (instead of > > > 295.54)(either using ROUND(2048.28*.146,2) or with field format. > > > > > > My LO Version: > > > Version: 6.0.5.2 > > > Build ID: 00m0(Build:2) > > > CPU threads: 2; OS: Linux 4.12; UI render: default; VCL: gtk3; > > > Locale: en-GB (en_GB.UTF-8); Calc: group > > > > > > Cheers > > > Harvey > > > -- > > > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > > > Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to > -unsubscribe/ > > > Posting guidelines + more: https://wiki.documentfoundation.org/Neti > quette > > > List archive: https://listarchives.libreoffice.org/global/users/ > > > Privacy Policy: https://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
