[Solved] Precision as shown

[TheOldThug]

I have a column of numbers with the numbers set to no decimal point. If the number is 7.5 it rounds to 8. However when I add the numbers in the column it adds them as 7.5 not 8. I believe if I have "Precision as shown" checked it fixes this problem. Is that correct and will it apply to all sheets or just the worksheet I am using. Also am I setting myself up for some type of problem.
Thank you

[robleyd]

The HELP says

Precision as shown
Specifies whether to make calculations using the rounded values displayed in the sheet. Charts will be shown with the displayed values. If the Precision as shown option is not marked, the displayed numbers are rounded, but they are calculated internally using the non-rounded number.

That seems to match what you want? This is a global setting, using Tools | Options... so applies to all your spreadsheets in the document.

Edit: to clarify

[Zizi64]

I have a column of numbers with the numbers set to no decimal point. If the number is 7.5 it rounds to 8.

They are not rounded numbers, but they are FORMATTED ones. The formatting feature never will change the value of the numbers. It will modify only the lookout of the numbers.

The option "Precision as shown" will modify the "value" of the numbers of the cells what will used to other calculations, but when you switch it off, the Calc will remember the original values. The scope of this option is global.

If you want round the numbers partially (in some cells only), then you must use the function ROUND() and others.

[keme]

I have a column of numbers with the numbers set to no decimal point. If the number is 7.5 it rounds to 8. However when I add the numbers in the column it adds them as 7.5 not 8. I believe if I have "Precision as shown" checked it fixes this problem. Is that correct and will it apply to all sheets or just the worksheet I am using.

The setting in question is "global" in that it applies to all worksheets (tabs) in your current file, or "workbook". It is not "universal", i.e. if you set it while working on one workbook, it does not apply to other workbooks when you open them. In other words, the setting is maintained "dynamically" for each file, not "persistently" for the Calc app.

Also am I setting myself up for some type of problem.

Quite possibly.
The process of rounding introduces a deviation from original number. When working with few valid digits, these deviations add up rapidly, particularly with multiplication/division in multiple steps. In most cases it is better to round explicitly (using some rounding function) when required.
In any case, make sure that the rounded figure is really the one you want to base your calculation on.

[TheOldThug]

Thank you everyone, I see that it could cause some problems. It seems I need to use Round function in certain places