Performing calculations in a table within a text document

From NeoWiki

Revision as of 20:05, 1 February 2007 (edit) Sardisson (Talk | contribs) m (Calculation on a table within a text document moved to Performing calculations in a table within a text document: Slightly tweak title; thanks valter!) ← Previous diff		Current revision (13:56, 9 February 2007) (edit) (undo) RoyFocker (Talk | contribs) m (→Calculating with data from cells belonging to different tables - link to spanish version)
(7 intermediate revisions not shown.)
Line 1:		Line 1:
-	==Calculation on a table within a text document==	+	==Calculations in a table within a text document==
-	In Writer, NeoOffice word processor, is possible make simple calculatons directly inside a table, without the need of inserting a Calc Object as OLE object.	+	In [[NeoWriter|NeoOffice Writer]], the word processing component, is possible to perform simple calculations directly inside a table, without having to insert a Calc spreadsheet as an OLE object.
-	[[Image:It_immissione_formule_tabella_testo.png|right|List of mathematic function usable within a table of text]]	+	[[Image:TableFormulas.png|right|List of mathematical functions usable within a table]]
-	To do this task you need to:	+	In order to do this, you need to:
-	*insert a table as you usually do;	+	#Insert a table as you usually do.
-	*type data in the table cells;	+	#Type data in the table cells.
-	*click on the cell where you want to insert a calculation formula;	+	# Then click on the cell where you want to insert a calculation or formula.
-	*than, to insert the formula, you can follow two ways:	+	# To insert the formula, you can either:
-	**press {{key|F2}} key; or	+	#* Press the {{key|F2}} key; or
-	**write "=" (without “) directly inside the cell	+	#* Type <tt>=</tt> directly inside the cell
-	*a typing row will appear just on topo of the page , after "=" (without “) sign type the formula you wish;	+	# 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;
-	*than hit the {{key|Invio}} key	+	# Then hit the {{key|enter}} key
	<br>		<br>
-	Mathematical functions that you can use for formulas can be typed directly or choose from the list that is shown clicking on Formula icon that is present in the toolbar that appear (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==	+
-	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).	+	==Copying a formula to other table cells==
-	Now if you want to repeat the same calculation in cells from C2 to C5 you can do what follow:	+	It's possible to copy and paste a formula from one cell to other cells, keeping relative references. For example, take a table with 5 rows and 3 columns:
-	*click on cell C1;	+	# In cell, A1 type <tt>1</tt>, and in cell B1, type <tt>2</tt>
-	*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;	+	# In cell C1, insert a formula, ''i.e.'' type <tt>=<A1>+<B1></tt>
-	*do a copy as you usually do:	+	#* You could also not type <tt><A1></tt> and <tt><B1></tt>; to insert the cell reference in a formula, after typing <tt>=</tt> or after pressing the {{key|F2}} key, click on cell A1, then hit the {{key|+}} key, and then click on cell B1.
-	**from menu {{menu|Edit/Copy}}; or	+	#To repeat the same calculation in cells C2 to C5, first click on cell C1.
-	**hitting the “copy” icon in Standard toolbar; or	+	#While holding down the (left) mouse button, move to cell B1 and then back to cell C1 (all of cell C1, and only that cell, will be highlighted).
-	**hitting simultenously {{key|⌘}} and {{key|c}} keys.	+	# Copy as you usually do:
-	*Now, select cells from C2 to C5 and	+	#*By choosing {{menu|Copy}} from the {{menu|Edit}} menu; or
-	*paste clipboard content as you usually do:	+	#*Pressing the “Copy” icon in the Standard toolbar; or
-	**from menu {{menu|Edit/Paste}}; or	+	#*Pressing {{key|⌘-C}}.
-	**hitting the “paste” icon in Standard toolbar; or	+	# Now select cells C2 to C5.
-	**hitting simultenously {{key|⌘}} and {{key|v}} keys.	+	# Finally, paste the clipboard contents as you usually do:
		+	#*By choosing {{menu|Copy}} from the {{menu|Edit}} menu; or
		+	#*Pressing the “Paste” icon in the Standard toolbar; or
		+	#*Pressing {{key|⌘-V}}.
	<br>		<br>
-	==Calculation among data from cells that belong to different tables==	+
-	In NeoOffice Writer it's possible to make calculation using data that are written in different tables.	+	==Calculating with data from cells belonging to 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:	+	In NeoOffice Writer, it is also possible to perform calculations using data that are in different tables.
-	*click on a cell of the table where we want to have that the result is displayed;	+	To do this you have to know (or remember) that NeoOffice numbers the tables you insert in a text document in a progressive order. For example, there is a number in cell B2 of the first table, a number in cell A3 of the second table, and you 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:
-	*type {{key|=}} or {{key|F2}};	+	#Click on the cell of the table where you want the result displayed.
-	*insert the formula, for example for an addition, choose on the these ways:	+	#Type <tt>=</tt> or press {{key|F2}}.
-	**type "<Table1.B2>+<Table2.A3>" (without “) and hit {{key|Enter}} key; or	+	#Insert the formula; for example, for a sum, you can either:
-	**click on cell B2 of table 1, type {{key|+}} (without “), click on cell A3 of table 2 and hit {{key|Enter}} key.	+	#*Type <tt><Table1.B2>+<Table2.A3></tt> and hit the {{key|Enter}} key; or
		+	#*Click on cell B2 of Table 1, type {{key|+}}, click on cell A3 of table 2, and hit the {{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).	+	You can omit the table number before references to cells that are in the same table as the forumla; ''e.g.'', if you are inserting the formula in a cell in Table 1, you can omit "Table1" when referring to cell B2 in the above example.
-	{{botlangbarEN|[[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]] [[Es:C%C3%A1lculos_en_una_tabla_de_Writer|Español]]}}
	[[Category:NeoOffice]][[Category:Tips and Hints]]		[[Category:NeoOffice]][[Category:Tips and Hints]]

---

Current revision

Calculations in a table within a text document

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

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).

Copying a formula to other table cells

It's possible to copy and paste a formula from one cell to other cells, keeping relative references. For example, take a table with 5 rows and 3 columns:

1. In cell, A1 type 1, and in cell B1, type 2
2. In cell C1, insert a formula, i.e. type =<A1>+<B1>
   • You could also not type <A1> and <B1>; to insert the cell reference in a formula, after typing = or after pressing the F2 key, click on cell A1, then hit the + key, and then click on cell B1.
3. To repeat the same calculation in cells C2 to C5, first click on cell C1.
4. While holding down the (left) mouse button, move to cell B1 and then back to cell C1 (all of cell C1, and only that cell, will be highlighted).
5. Copy as you usually do:
   • By choosing Copy from the Edit menu; or
   • Pressing the “Copy” icon in the Standard toolbar; or
   • Pressing ⌘-C.
6. Now select cells C2 to C5.
7. Finally, paste the clipboard contents as you usually do:
   • By choosing Copy from the Edit menu; or
   • Pressing the “Paste” icon in the Standard toolbar; or
   • Pressing ⌘-V.

Calculating with data from cells belonging to different tables

In NeoOffice Writer, it is also possible to perform calculations using data that are 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. For example, there is a number in cell B2 of the first table, a number in cell A3 of the second table, and you 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:

1. Click on the cell of the table where you want the result displayed.
2. Type = or press F2.
3. Insert the formula; for example, for a sum, you can either:
   • Type <Table1.B2>+<Table2.A3> and hit the Enter key; or
   • Click on cell B2 of Table 1, type +, click on cell A3 of table 2, and hit the Enter key.

You can omit the table number before references to cells that are in the same table as the forumla; e.g., if you are inserting the formula in a cell in Table 1, you can omit "Table1" when referring to cell B2 in the above example.