To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68207 Issue #|68207 Summary|Using a range to select a row/column Component|Spreadsheet Version|OOo 2.0.2 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|diamondmagic
------- Additional comments from [EMAIL PROTECTED] Sun Aug 6 19:54:28 -0700 2006 ------- Unlike Excel, OOo Calc has no real way to have a range cover an entire row or column. The docs (Help->Spreadsheets->Formulas and Calculations->Calculating With Formulas) suguest instead to use a very wide range: =SUM(B1:B65536) Sums all numbers in column B. However this can be unsuitable in some cases. If you use the suguested solution (lets say in cell A1), and extend it to a row below by dragging, the second row cell (A2) will take a value of "=SUM(B2:B#REF!)", obviously not the desired result (to keep selecting the entire column). I would enjoy it if (similar to Excel) omitting the column or row specifier means select all of the cells. As a variation, omitting only the first or last means select all from the start until one cell or from a cell onwards (so A2:A means all column A cells starting at row 2). This would also need to be worked into the equation editor so you can click a row/column header (If there is a solution like this, it isn't implemented into the equation editor). --------------------------------------------------------------------- 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]
