To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95630 Issue #|95630 Summary|Range reference including same cell always converts to | absolute Component|Spreadsheet Version|OOO300m9 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|editing Assigned to|spreadsheet Reported by|cheros
------- Additional comments from [EMAIL PROTECTED] Thu Oct 30 09:27:42 +0000 2008 ------- What I did: Cell A9, formula "=max(a$8:a8)+1", aim was to copy it down the column (hence the absolute reference). When copied, did not work. Inspection showed that Calc had changed "=MAX(A$8:A8)" to "=MAX(A$8:A$8)". This is impossible to change, as soon as edit is saved Calc changes it back. Behaviour is consistent and repeatable and appears to be triggered by the range reference being the same cell). Tested on OOo 3.0.0m9 build 9358 on Win XP Pro Intel dual core. --------------------------------------------------------------------- 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]