How do I do math calculations in Writer in a table. ie: in cell A3, I want the total of cell A1 plus A2. Same idea as in MS Excel.
Just as in Excel (or Calc), place the cursor at the intended cell (A3 in this case), then click Table > Formula (or just F2). Then you’ll see the Formula bar. I think you know the rest.
If this is the right answer for you, please mark it as correct.
Btw, you title is missing a “?”.
We shouldn’t conceal that text-tables (tables in Writer) only support a very limited set of means to compose formulae, and also a next to unusable formula editor.
This is obviously due to the “need” to be compatible with silly MS ‘Word’ which is a different “product” than ‘Excel’. LibO which not is a “product” but real software might easily offer the complete power of ‘Calc’ in ‘Writer’ tables.
Fortunately you can insert a spreadsheet/view of into a ‘Writer’ document as an OLE object
The help about formulae in text tables also is next to unusable.
Who can tell me how to use a conditional expression (“alternative”, “IF-fumction”) and where this is described? Calculated alternatives is one of the most basic features you need for calculations in tables.
The ‘Writer’ (4.0: 468 pages) guide doesn’t tell anything useful about calculating in tables. Moreover it is misleading.
Lupp, it’s open source. If you think something isn’t good enough, you’re welcome to improve it.
@Prince: “Lupp, it’s open source… you’re welcome to improve it.”
I well know this statement. However, I wouldn’t either confirm it to be relevant in this case or start a detailed discussion about it here. If you want to pull this to the private level, you can mail me via jag…psilosoph.de (you know…).
(I also know where to report bugs and feature requests. My name on bugs.documentfoundation.org is ‘Wolfgang Jäger’.)