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
I think you have put your finger on it, Michael. The 2024.28 figure is calculated but displayed to only 2 decimal places. It is, to 4 decimal places, 2024.2829 which results in 295.5452888. So, thanks for the enlightenment!! Cheers Harvey On Sat, 2018-12-29 at 05:11 +1000, Michael D. Setzer

Re: [libreoffice-users] Building failed: "testN777345::Import equality assertion failed"

2018-12-28 Thread Regina Henschel
Hi Mickael, Mickael Jackson schrieb am 28-Dec-18 um 07:34: After 6 hours of building, it ends with a failure... (cppunittester:32480): Gdk-WARNING **: 16:30:37.605: gdk_window_set_icon_list: icons too large image-hyperlink.docx: 116 testImageHyperlink::Import finished in: 125ms

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
=With the updated first number I get the 295.54 as it should be. Third position is a 4, it doesn't change the 2nd position. Num 1 Num 2 Num 1 * Num 2 Rounded 2024.28 0.146 295.54488 295.54 Are the values you show for the Num 1 and Num 2 entered link that or are that what is displayed on

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
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. > >

Re: [libreoffice-users] Calc error?

2018-12-28 Thread Michael D. Setzer II
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

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: