To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96724 Issue #|96724 Summary|cannot enter mixed absolut and relative references for | range definition Component|Spreadsheet Version|OOo 3.0 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|andreschnabel
------- Additional comments from [EMAIL PROTECTED] Sun Nov 30 11:55:38 +0000 2008 ------- under some circumstances it is not possible to mix absolut and relative cell references in formulas that operate on a range. If a range definition is only one row / column the reference type for the row/ column will be taken from the first part of the range definition. some examples, how Calc will change range definitions: Enter -> converted to =SUM(C1:$C$1) =SUM(C1:C1) =SUM($C$1:C1) =SUM($C$1:$C$1) =SUM(C1:$C$5) =SUM(C1:C$5) =SUM(C1:$D$1) =SUM(C1:$D1) --------------------------------------------------------------------- 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]