Performing calculations in a table within a text document

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 20:45, 1 February 2007 (edit)
Sardisson (Talk | contribs)
(some polish to valter's text; thanks, valter!)
← Previous diff		 Revision as of 23:34, 1 February 2007 (edit) (undo)
Lorinda (Talk | contribs)
(polished the text a little more)
Next diff →
Line 12: Line 12:
#* Type <tt>=</tt> directly inside the cell #* Type <tt>=</tt> directly inside the cell
# An area for formula entry will appear in the toolbar, just above the top of the page (like in Calc); after the <tt>=</tt> sign, type the formula you wish to use; # An area for formula entry will appear in the toolbar, just above the top of the page (like in Calc); after the <tt>=</tt> sign, type the formula you wish to use;
-# Then hit the {{key|Invio}} key <!-- enter? -->+# Then hit the {{key|enter}} key
<br> <br>
Mathematical functions that you can use for formulas can be typed directly or chosen from the list that is shown when clicking on Formula icon in the toolbar that appears (on the left of the formula-typing field). Mathematical functions that you can use for formulas can be typed directly or chosen from the list that is shown when clicking on Formula icon in the toolbar that appears (on the left of the formula-typing field).
<br> <br>
-==Copy of a formula in other table cells==+==Copy a formula to other table cells==
It's possible to copy and paste a formula from a cell to others, keeping relative references. I'm going to explain this. Let's have a table with 5 rows and 3 coloumns. In cell A1 type 1; in cell B1 type 2; in cell C1 insert a formula, i.e. "=A1+B1" (without “; you could also not type A1 and B1: to insert the cell reference in a formula, after you have typed "=" or after you have hitted {{key|F2}} key, click on cell A1, then hit {{key|+}} key and than click on cell B1). It's possible to copy and paste a formula from a cell to others, keeping relative references. I'm going to explain this. Let's have a table with 5 rows and 3 coloumns. In cell A1 type 1; in cell B1 type 2; in cell C1 insert a formula, i.e. "=A1+B1" (without “; you could also not type A1 and B1: to insert the cell reference in a formula, after you have typed "=" or after you have hitted {{key|F2}} key, click on cell A1, then hit {{key|+}} key and than click on cell B1).
-Now if you want to repeat the same calculation in cells from C2 to C5 you can do what follow:+Now if you want to repeat the same calculation in cells from C2 to C5 you can do the following:
*click on cell C1; *click on cell C1;
-*keeping left-bottom-key of your mouse (or the only key) move to B1 cell and than back to C1: the entire and only C1 cell will be highlighted;+*holding down the (left) mouse button, move to B1 cell and then back to C1: the entire and only C1 cell will be highlighted;
*do a copy as you usually do: *do a copy as you usually do:
**from menu {{menu|Edit/Copy}}; or **from menu {{menu|Edit/Copy}}; or
Line 31: Line 31:
**hitting simultenously {{key|⌘}} and {{key|v}} keys. **hitting simultenously {{key|⌘}} and {{key|v}} keys.
<br> <br>
-==Calculation among data from cells that belong to different tables==+==Calculating with data from cells belonging to different tables==
-In NeoOffice Writer it's possible to make calculation using data that are written in different tables.+In NeoOffice Writer, it is possible to perform calculations using data that are written in different tables.
-To do this you have to know (or remember) that NeoOffice numbers tables you insert in a text in a progressiv order. So if you have inserted a number in cell B2 of the first table, a number in cell A3 of the second table and want to make a calculation betwen these to numebr and put the result in a cell of a third table, you have to follow these instructios:+To do this you have to know (or remember) that NeoOffice numbers the tables you insert in a text document in a progressive order. Say you have inserted a number in cell B2 of the first table, and a number in cell A3 of the second table and want to make a calculation involving these two numbers and put the result in a cell of a third table. You can do so by following these instructions:
-*click on a cell of the table where we want to have that the result is displayed;+*click on the cell of the table where you want the result displayed;
*type {{key|=}} or {{key|F2}}; *type {{key|=}} or {{key|F2}};
-*insert the formula, for example for an addition, choose on the these ways:+*insert the formula, for example for a sum, you can either:
-**type "<Table1.B2>+<Table2.A3>" (without “) and hit {{key|Enter}} key; or+**type <tt><Table1.B2>+<Table2.A3></tt> and hit {{key|Enter}} key; or
-**click on cell B2 of table 1, type {{key|+}} (without “), click on cell A3 of table 2 and hit {{key|Enter}} key.+**click on cell B2 of table 1, type {{key|+}}, click on cell A3 of table 2 and hit {{key|Enter}} key.
<br> <br>
-If the formula is been written in a cell of table 1 you can omit to write "Table1" before cell reference (in this case B2); again, if the formula is been written in a cell of table 2 you can omit to type "Table2" before cell reference alla casella (i n this case A3).+If you are inserting the formula in a cell of table 1 you can omit "Table1" before cell reference (in this case B2); again, if the formula is being inserted in a cell of table 2, you can omit to type "Table2" before cell reference (in this case A3).
{{botlangbarEN|[[Fr:Calculs_dans_un_tableau_d'un_document_de_texte|Français]] [[It:Calcoli_in_una_tabella_di_un_documento_di_testo|Italiano]]}} {{botlangbarEN|[[Fr:Calculs_dans_un_tableau_d'un_document_de_texte|Français]] [[It:Calcoli_in_una_tabella_di_un_documento_di_testo|Italiano]]}}
[[Category:NeoOffice]][[Category:Tips and Hints]] [[Category:NeoOffice]][[Category:Tips and Hints]]

Revision as of 23:34, 1 February 2007

This article is not up to date, or it needs structural or stylistic changes to conform with the rest of this wiki.

Calculations in a table within a text document

In NeoWriter, the word processing component, is possible to make simple calculations directly inside a table, without having to insert a Calc spreadsheet as an OLE object.

List of mathematical functions usable within a table

In order to do this, you need to:

  1. Insert a table as you usually do.
  2. Type data in the table cells.
  3. Then click on the cell where you want to insert a calculation or formula.
  4. To insert the formula, you can either:
    • Press the F2 key; or
    • Type = directly inside the cell
  5. An area for formula entry will appear in the toolbar, just above the top of the page (like in Calc); after the = sign, type the formula you wish to use;
  6. Then hit the enter key


Mathematical functions that you can use for formulas can be typed directly or chosen from the list that is shown when clicking on Formula icon in the toolbar that appears (on the left of the formula-typing field).

Copy a formula to other table cells

It's possible to copy and paste a formula from a cell to others, keeping relative references. I'm going to explain this. Let's have a table with 5 rows and 3 coloumns. In cell A1 type 1; in cell B1 type 2; in cell C1 insert a formula, i.e. "=A1+B1" (without “; you could also not type A1 and B1: to insert the cell reference in a formula, after you have typed "=" or after you have hitted F2 key, click on cell A1, then hit + key and than click on cell B1). Now if you want to repeat the same calculation in cells from C2 to C5 you can do the following:

  • click on cell C1;
  • holding down the (left) mouse button, move to B1 cell and then back to C1: the entire and only C1 cell will be highlighted;
  • do a copy as you usually do:
    • from menu Edit/Copy; or
    • hitting the “copy” icon in Standard toolbar; or
    • hitting simultenously ⌘ and c keys.
  • Now, select cells from C2 to C5 and
  • paste clipboard content as you usually do:
    • from menu Edit/Paste; or
    • hitting the “paste” icon in Standard toolbar; or
    • hitting simultenously ⌘ and v keys.


Calculating with data from cells belonging to different tables

In NeoOffice Writer, it is possible to perform calculations using data that are written in different tables. To do this you have to know (or remember) that NeoOffice numbers the tables you insert in a text document in a progressive order. Say you have inserted a number in cell B2 of the first table, and a number in cell A3 of the second table and want to make a calculation involving these two numbers and put the result in a cell of a third table. You can do so by following these instructions:

  • click on the cell of the table where you want the result displayed;
  • type {{{1}}} or F2;
  • insert the formula, for example for a sum, you can either:
    • type <Table1.B2>+<Table2.A3> and hit Enter key; or
    • click on cell B2 of table 1, type +, click on cell A3 of table 2 and hit Enter key.


If you are inserting the formula in a cell of table 1 you can omit "Table1" before cell reference (in this case B2); again, if the formula is being inserted in a cell of table 2, you can omit to type "Table2" before cell reference (in this case A3).


This article in other languages: Français Italiano
Retrieved from "https://neowiki.neooffice.org/index.php/Performing_calculations_in_a_table_within_a_text_document"
Personal tools