To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97755 Issue #|97755 Summary|=SUM(a1;c1;e1) returnes "err:508" Component|Spreadsheet Version|OOo 3.0 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|changedsoul
------- Additional comments from changeds...@openoffice.org Sun Jan 4 21:25:31 +0000 2009 ------- When trying to sum cells that are not adjacent to each other ( using ; and not : ), the result is "err:508" The program automatically includes the ";" (semi-colon) when holding down the "ctrl" key and clicking cells to auto populate the equation. When you place the final closing bracket and press enter, the result is "err:508". I have found that when you use a "," instead of a ";" the equation works as expected, so it appears the function SUM() works but the spread sheet is auto placing the wrong cell separator when you click a cell. Example: open a new spreadsheet and place a number 1 in cell A1, a number 2 in C1, and a number 3 in E1. Then in Cell A2, enter =SUM( and then click cell A1, then hold the "ctrl" key down, and click the two remaining cells (C1 and E1). You will notice that the software will automatically fill in the Cell names separated by a ";" when in fact it should be a ",". The spread sheet documentation for the SUM() function is also incorrect as it shows examples using the ";" and not a ",". --------------------------------------------------------------------- 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