To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4695
------- Additional comments from [EMAIL PROTECTED] Thu Apr 19 13:26:44 +0000 2007 ------- Hi Michel, Relative references are displayed without the dollar character, in the names dialog you may define them by editing the reference and removing the dollars, for example modify $Sheet1.$A$1 to $Sheet.A1 The relative reference generated then depends on the position of the cell cursor when you opened the name dialog, for example if the current cell is B2, a reference of A1 actually means "one row up and one column to the left". If you reopen the dialog on a different cell the reference of that named range displayed is adjusted accordingly. Note that the requirement I copied above actually has an error stating "(ScInterpreter::aPos member variable)", for Excel compatibility this is exactly not the case, but named relative references for the INDIRECT function are based on A1 instead. Weird, and IMHO wrong, but that's how Excel does it. Excel doesn't know relative sheet references in named ranges, but Calc does, so the address to pass from within ScInterpreter::ScIndirect() probably should be ScAddress( aPos.Tab(), 0, 0) > Heck, 3 lines for return, you're hard with me, I don't like code too > long :). Well, the more common errors have convenience functions, such as SetIllegalArgument() that sets the error and pushes a value, so one line less to code, an errUnknownState just isn't that usual.. > I will do the change to pData and for premature return in a patch. My > CWS is not here, but it's coming nicely and surely, thanks Sophie ^_^. Huh? Does hat mean you want to create your own CWS for this? Do you already have CVS write access, which is needed to do so? Eike --------------------------------------------------------------------- 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]
