To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104108 Issue #|104108 Summary|OpenOffice Calc doesn't calculate Component|Spreadsheet Version|OOo 3.0 Platform|Other URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|ubiquity2009
------- Additional comments from ubiquity2...@openoffice.org Sat Aug 8 19:18:43 +0000 2009 ------- I cannot get OpenOffice Calc to calculate a sum. Help states: "SUM "Adds all the numbers in a range of cells. "Syntax "SUM(Number1; Number2; ...; Number30) "Number 1 to Number 30 are up to 30 arguments whose sum is to be calculated. "Example "If you enter the numbers 2; 3 and 4 in the Number 1; 2 and 3 text boxes, 9 will be returned as the result. "=SUM(A1;A3;B5) calculates the sum of the three cells. =SUM (A1:E10) calculates the sum of all cells in the A1 to E10 cell range. "Conditions linked by AND can be used with the function SUM() in the following manner: "Example assumption: You have entered invoices into a table. Column A contains the date value of the invoice, column B the amounts. You want to find a formula that you can use to return the total of all amounts only for a specific month, e.g. only the amount for the period >=2008-01-01 to <2008-02-01. The range with the date values covers A1:A40, the range containing the amounts to be totaled is B1:B40. C1 contains the start date, 2008-01-01, of the invoices to be included and C2 the date, 2008-02-01, that is no longer included." I also went to Tools, Cell Contents & AutoCalculate, to no avail. I am not good at math. I hope that my selections of "code" as the subcomponet and "defect" as the issue type are appropriate but I am not sure they are. I am not a programmer. I have been using spreadsheets since 1975 (Lotus, then ExcelI). I use logic to solve problems, not math. The Help text quoted above does not tell me if the correct expression of the formula to add cell contents (for example, add the contents of cell A1 to those of cell A2) or variables (for example, add plus 3 to minus 4). Should an equal sign precede the word "sum"? If yes, should a space separate the equal sign and the word "sum"? Should the word "sum" be lower-case, all caps or just start with a capital letter? Should cell addresses or variables be surrounded by parentheses? Should a space follow the word "sum"? When referring to a variety of cell addresses, should a space follow the semi-colon? Does the inability to calculate a sum lie with a problem in syntax? Or is another function used? I am a new OpenOffice Calc user; am I just missing something else the mathematically-adept find obvious? Lotus used @SUM(a1+a2) while Excel uses =SUM(a1+a2). I tried the plus symbol, also to no avail. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
