Talk:Documentation/OOo3 User Guides/Calc Guide/Creating formulas

From Apache OpenOffice Wiki
Jump to: navigation, search

Delete the chapter " Break formulas into parts and combine the parts"! The formula editor (Insert > Object > Formula) is for typesetting formulas in texts and is very different from calculating formulas.

Regina 00:04, 27 May 2009 (UTC)

Indeed they are different and the bit on Math should not have been there. But I think the idea is correct: several cells can each hold part of a formula, with another cell combining the results from those cells into another calculation.

Jean 14 Sept 2009

I think the structure of the chapters is not good. If the user does not know anything, he first needs to learn how to use simple expressions, using functions are the second step.

Using expressions should cover entering an expression, distinguish the shown expression result and the formula itself, using cell references, absolute and relative addressing, drag-fill, series, using labels and names and distinguish the use of them, access to external data, remarks on accuracy, precision and binary-format.

The next chapter can be about functions. The description has to cover simple functions like SUM, the real array functions, forcing expressions to array mode, the group of the Database functions and SUBTOTAL, calculating with date and time, functions with conditions like COUNTIF and the group of LOOKUP-functions, working with texts, creating named expressions and BASIC functions. (Not necessary in that order.)

Regina 22:54, 2 June 2009 (UTC)

Just completed an initial cleanup of this page, and have eliminated the more obvious errors and problems. I will probably do a more complete going next after I done an initial cleanup of the other sections. In the meantime feel free to spot and/or cleanup anything that I've missed, while I work on the other pages in this chapter. --Kirk 05:28, 18 September 2009 (UTC)

Personal tools