Difference between revisions of "Talk:Documentation/OOo3 User Guides/Calc Guide/Creating formulas"
(New page: 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 calcul...) |
|||
| Line 1: | Line 1: | ||
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. | 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. | ||
| − | |||
| − | |||
[[User:Regina|Regina]] 00:04, 27 May 2009 (UTC) | [[User:Regina|Regina]] 00:04, 27 May 2009 (UTC) | ||
| + | |||
| + | |||
| + | 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.) | ||
| + | |||
| + | [[User:Regina|Regina]] 22:54, 2 June 2009 (UTC) | ||
Revision as of 22:54, 2 June 2009
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)
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)
