To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=41853
Issue #:|41853
Summary:|Help text for function SUMIF lacks details
Component:|Spreadsheet
Version:|OOo 1.1
Platform:|PC
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|ENHANCEMENT
Priority:|P3
Subcomponent:|ui
Assigned to:|spreadsheet
Reported by:|ms2
------- Additional comments from [EMAIL PROTECTED] Tue Feb 1 16:05:54 -0800
2005 -------
In the help text to the functions SUMIF there is no example of embedding the
criteria in the formula directly. This should get added.
e.g. as a second exmple
To sum up only negative numbers, this will do:
SUMIF(A1:A10;"<0")
or one hint in the description like this:
If the criteria is written into the formula, it has to be surrounded by
double quotes.
I tell you why:
I'm using calc only for simple things like summing up rows and having
data in columns and rows. One day I wanted to sum up only the negative
numbers of a column and with my small background in using calc formulas
i was stuck. Because I did not know and was not told that if the criteria
is written into the formula directly, it has to be wrapped in double quotes.
I don't know for sure, but I can imagine that some more help texts are
lacking examples showing all possible cases...
All this relates to the english version of OOo1.1.0.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]