2008/5/19 TechAdmin @ VibrantLivingMinistries < [EMAIL PROTECTED]>: > From: Johnny Rosenberg [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 18, 2008 1:25 AM > To: [email protected] > Subject: Re: [users] Small problem with Calc. > > 2008/3/16, Alex Janssen <[EMAIL PROTECTED]>: > > > > Радимир Мирчев said the following on 03/15/2008 10:02 AM: > > > >> Hello Sun :) > >> > >> I use OpenOffice.org [Calc] and is very happy with its functionality. > But > >> I had a problem, I hope for your help. When I enter the sum, for example > - > >> 164,848, the program rounds off the sum on 164,85, tell please how to > switch > >> off this function, these figures - the prices, and they should not will > be > >> brief. > >> > >> Best regards! > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > >> When entering, don't enter the comma (,). > > Just the numbers 164848. > > The comma is being interpreted as the beginning of the fractional part of > > whole units of money. > > Check your language settings for monetary input and display under > > Tools->Options->Language Settings->Languages, decimal separator key and > > default currency. > > > > HTH, > > > > Alex > > > > > > The Russian comma (I guess the OP is Russian due to his/her email > address) > is a decimal comma, just like in many other countries (like my country, > Sweden), right? So the comma is absolutely not supposed to be omitted. And > it seems to work too, since 164,848 is correctly rounded to 164,85. If you > don't want the comma to be a decimal comma, but rather a thousands > separator, then you can select another language or whatever, but I am not > sure if that's the problem. > > Радимир Мирчев, > > Look at the buttons on the top of the Calc window, on my system I will look > at the second row of buttons. There is a button with some coins on it. The > third button to the right of that one and also the fourth one is for > setting > how many decimals you want (again, on my system, maybe those are located > different on yours). One of them increases and the other one decreases the > number of decimals. There are also may other ways to change it. > > You can also set whether or not the set number of decimals should be used > in > calculations. Click Tools → Options... → OpenOffice.org Calc → Calculate > → > Make sure that the checkbox for "Precision as shown" is NOT ticked. > > If you now enter 164,848 in A1, 254,245 in A2, and then sum these in A3, A3 > will now show 419,09 (if all cells are set to showing 2 decimals). Tick the > "Precision as shown" box and A3 will show 419,10, and I guess that is not > what you want. So just make sure it's unticked. > > Johnny Rosenberg > -------------------------- > I find this conversation helpful, thanks to all. Question: Can someone > explain what "Precision as shown" actually does? > Thanks, > Elchanan > > I thought that was what I tried to explain, but I'll try to put it in other words:
Let's assume that A1=5,4 and A2= 4,4. Now, input the following into A3: =A1+A2 The result in A3 will now probably be 9,8. Now, highlight all the three cells and make them show no decimals at all. What we will see now is the following: 5 4 10 Everything is rounded to the nearest integer: 5,4→5 4,4→4 9,8→10 Easy so far? Now enable "Precision as shown" as I described the other day. The result will now be as follows: 5 4 9 Why? Because the formula in A3 now calculates A1+A2 as they are shown. NOT 4,4+5,4 any more, but rather 4+5. Still everything is rounded to the nearest integer, but since A3 is calculated differently, this is how things are rounded: 5,4→5 4,4→4 9,0→9 (since A3=A1 as shown + A2 as shown = 5+4 = 9,0) So if you want to keep all the decimals, even those which are not shown in each cell, the "Precision as shown" check box should NOT be ticked. Or in other words: The "Precision as shown" checkbox makes sure that all calculations are made, based on what you SEE in the cells, rather than what's actually in them. I don't know how to explain it better. If this isn't clear enough I hope someone else can explain it better. Johnny Rosenberg
