From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- .../source/text/scalc/guide/rounding_numbers.xhp | 84 ++++++++++++++++++++++ 1 file changed, 84 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/rounding_numbers.xhp (limited to 'helpcontent2/source/text/scalc/guide/rounding_numbers.xhp') diff --git a/helpcontent2/source/text/scalc/guide/rounding_numbers.xhp b/helpcontent2/source/text/scalc/guide/rounding_numbers.xhp new file mode 100644 index 000000000..b9ebc4ac7 --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/rounding_numbers.xhp @@ -0,0 +1,84 @@ + + + + + + + + +Using Rounded Off Numbers +/text/scalc/guide/rounding_numbers.xhp + + +Sun Microsystems, Inc. + + + +numbers; rounded off +rounded off numbers +exact numbers in $[officename] Calc +decimal places; showing +changing;number of decimal places +values;rounded in calculations +calculating;rounded off values +numbers; decimal places +precision as shown +rounding precision +spreadsheets; values as shown +mw reduced "tables in spreadsheets;" to "tables;" + +Using Rounded Off Numbers + +In $[officename] Calc, all decimal numbers are displayed rounded off to two decimal places. +To change this for selected cells + + +Mark all the cells you want to modify. + + +Choose Format - Cells and go to the Numbers tab page. + + +In the Category field, select Number. Under Options, change the number of Decimal places and exit the dialog with OK. + + +To change this everywhere + + +Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc. + + +Go to the Calculate page. Modify the number of Decimal places and exit the dialog with OK. + + +To calculate with the rounded off numbers instead of the internal exact values + + +Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc. + + +Go to the Calculate page. Mark the Precision as shown field and exit the dialog with OK. + + +
+Numbers +Calculate +
+ + -- cgit v1.2.3