Re: [libreoffice-users] Calc error?

2018-12-28 Thread Johnny Rosenberg
Den fre 28 dec. 2018 kl 19:24 skrev Robert Großkopf < rob...@familiegrosskopf.de>: > Hi Harvey, > > > > 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

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Harvey Nimmo
On Fri, 2018-12-28 at 20:12 +0100, Piet van Oostrum wrote: > Harvey Nimmo writes: > > > 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,

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Harvey Nimmo
On Fri, 2018-12-28 at 19:12 +, Brian Barker wrote: > At 20:06 28/12/2018 +0100, Harvey Nimmo wrote: > > However, I do not have 'Limit decimals for general number format' > > set to anything. (i.e. No tick) > > Good-oh! And what about "Precision as shown"? > > Brian Barker 'Precision as

Re: [libreoffice-users] Calc error? SOLVED

2018-12-28 Thread Harvey Nimmo
; > > > On 28 Dec 2018 at 19:47, Harvey Nimmo wrote: > > > Subject:;Re: [libreoffice-users] Calc error?From:60;Harvey > nimmohar...@nimmo.det; > To:;Robert grokopfrob...@familiegrosskopf.de, >

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Piet van Oostrum
Harvey Nimmo writes: > 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

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Brian Barker
At 20:06 28/12/2018 +0100, Harvey Nimmo wrote: However, I do not have 'Limit decimals for general number format' set to anything. (i.e. No tick) Good-oh! And what about "Precision as shown"? Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Michael D. Setzer II
on screen.The actual numbers could throw off the calcs. If the 0.146 number is display like that, but actually contains 0.146001936490999 it would change the value. On 28 Dec 2018 at 19:47, Harvey Nimmo wrote: Subject:;Re: [libreoffice-users] Calc error?From:60;Harvey nimmohar...@nimmo.det

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Harvey Nimmo
On Fri, 2018-12-28 at 18:41 +, Brian Barker wrote: > At 18:26 28/12/2018 +0100, Harvey Nimmo wrote: > > I'm running LO on OpenSuse and I wonder if anyone else can confirm > > this error on calc. Multiplying 2048.28*.146 yields correctly > > 295.54488, ... > > Er, that wouldn't be correct

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Harvey Nimmo
> 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 > > To:

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Michael D. Setzer II
the 1st number?? Num 1 CalcNum 2Your Value??Rounded 2024.306849315070.146295.5488295.55 On 28 Dec 2018 at 18:26, Harvey Nimmo wrote: Subject:[libreoffice-users] Calc error? From:Harvey nimmohar...@nimmo.de To:Users libreofficeus...@global.libreoffice.org Date sent:Fri, 28 Dec 2018 18:26:17

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Harvey Nimmo
On Fri, 2018-12-28 at 19:22 +0100, Robert Großkopf wrote: > Hi Harvey, > > > > 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. > > Please

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Brian Barker
At 18:26 28/12/2018 +0100, Harvey Nimmo wrote: I'm running LO on OpenSuse and I wonder if anyone else can confirm this error on calc. Multiplying 2048.28*.146 yields correctly 295.54488, ... Er, that wouldn't be correct with my maths. Do you perhaps mean 2024.28 * 0.146 instead? ... but

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Robert Großkopf
Hi Harvey, > > 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. Please have a look at the values you have written. Gives 299.04888 here on Calc and

[libreoffice-users] Calc error?

2018-12-28 Thread Harvey Nimmo
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: