Re: [libreoffice-users] Calc error?

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 <harvey@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+unsubscribe@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+unsubscribe@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