Open Office Calc and small numbers (using Ubuntu)
Discussion
Chaps,
A quickie.
I am using Open Office (on Ubuntu, so no MS option available*.)
And I am struggling to use division for small numbers. For instance, I am trying to divide 12.5 by 100 (to multiply another number by, as a percentage). However, if I put 12.5 in one cell (B2, for instance), and get another cell to calculate "=B2/100", it gives 0.10. I can increase the decimal places and leading zeros in the Cell Format setting, but it still remains at 0.10 (or 000.10000000, if you please.)
Ensuing calculations using this result are then incorrect, as they use the figure as displayed, so are multiplying by 0.1 not by 0.125. (I know about the "Precision as shown" setting.)
What am I doing wrong? All help welcomed - thanks.
Oli.
-*- Yes, I know about WINE, but have never dared tackle it. And it's beside the point of this thread. OK?
A quickie.
I am using Open Office (on Ubuntu, so no MS option available*.)
And I am struggling to use division for small numbers. For instance, I am trying to divide 12.5 by 100 (to multiply another number by, as a percentage). However, if I put 12.5 in one cell (B2, for instance), and get another cell to calculate "=B2/100", it gives 0.10. I can increase the decimal places and leading zeros in the Cell Format setting, but it still remains at 0.10 (or 000.10000000, if you please.)
Ensuing calculations using this result are then incorrect, as they use the figure as displayed, so are multiplying by 0.1 not by 0.125. (I know about the "Precision as shown" setting.)
What am I doing wrong? All help welcomed - thanks.
Oli.
-*- Yes, I know about WINE, but have never dared tackle it. And it's beside the point of this thread. OK?
OK - I'm suggesting this from NeoOffice on MacOS - but there's a preferences setting under Calculations which controls the Decimal Places. Since NeoOffice is based on OO.o I'm guessing there should be a similar setting for your version on Ubuntu.
Edited by marshalla on Monday 18th October 20:15
zcacogp said:
Chaps,
A quickie.
I am using Open Office (on Ubuntu, so no MS option available*.)
And I am struggling to use division for small numbers. For instance, I am trying to divide 12.5 by 100 (to multiply another number by, as a percentage). However, if I put 12.5 in one cell (B2, for instance), and get another cell to calculate "=B2/100", it gives 0.10. I can increase the decimal places and leading zeros in the Cell Format setting, but it still remains at 0.10 (or 000.10000000, if you please.)
Ensuing calculations using this result are then incorrect, as they use the figure as displayed, so are multiplying by 0.1 not by 0.125. (I know about the "Precision as shown" setting.)
What am I doing wrong? All help welcomed - thanks.
Oli.
-*- Yes, I know about WINE, but have never dared tackle it. And it's beside the point of this thread. OK?
I have the same problem. Nearly. Mine goes to 0.125 when I increase the precision.A quickie.
I am using Open Office (on Ubuntu, so no MS option available*.)
And I am struggling to use division for small numbers. For instance, I am trying to divide 12.5 by 100 (to multiply another number by, as a percentage). However, if I put 12.5 in one cell (B2, for instance), and get another cell to calculate "=B2/100", it gives 0.10. I can increase the decimal places and leading zeros in the Cell Format setting, but it still remains at 0.10 (or 000.10000000, if you please.)
Ensuing calculations using this result are then incorrect, as they use the figure as displayed, so are multiplying by 0.1 not by 0.125. (I know about the "Precision as shown" setting.)
What am I doing wrong? All help welcomed - thanks.
Oli.
-*- Yes, I know about WINE, but have never dared tackle it. And it's beside the point of this thread. OK?
If it helps I think OOCalc is s
t. Try gnumeric.Chaps,
OK, I've discovered that it is definitely a function of the individual file, not of a setting of calc as a whole. I now have two files open on this machine, side-by-side, and one appears to be working as it should in this respect and the other is misbehaving.
Here is a screenshot:
Column F is column E over 100 (as in the formula bar), copied down.
It's not a matter of the decimal places displayed; you can increase this as much as you like and it will just display more '0's in the cell.
I have tried mimicing the Cell Properties from the cell in the spreadsheet that is working to the cells in the spreadsheet that aren't working and while they appear to be set identically, one works and the other one doesn't.
All ideas welcomed - thanks.
Oli.
OK, I've discovered that it is definitely a function of the individual file, not of a setting of calc as a whole. I now have two files open on this machine, side-by-side, and one appears to be working as it should in this respect and the other is misbehaving.
Here is a screenshot:
Column F is column E over 100 (as in the formula bar), copied down.
It's not a matter of the decimal places displayed; you can increase this as much as you like and it will just display more '0's in the cell.
I have tried mimicing the Cell Properties from the cell in the spreadsheet that is working to the cells in the spreadsheet that aren't working and while they appear to be set identically, one works and the other one doesn't.
All ideas welcomed - thanks.
Oli.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff