To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=46743 Issue #:|46743 Summary:|Range Names dont work across Sheets Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|kevingreiner
------- Additional comments from [EMAIL PROTECTED] Tue Apr 5 10:36:09 -0700 2005 ------- Using 1.9.79 on Windows XP Pro with all current patches as of 4/5/2005. Using a Named Range (Ctrl-F3) doesn't work across sheets. 1. Create a new blank spreadsheet. 2. Enter a value in Sheet1.A1. 3. Press Ctrl-F3 and give it this name: RangeOne. 4. In cell A2, type this text: =RangeOne. Press Enter. This works as expected. 5. Switch the Sheet2. 6. In cell A1, type this text: =$Sheet1.RangeOne. Press Enter. 7. You will see a "#NAME?" error in the cell. Observations 1. On both Sheet1 and Sheet2, the "type ahead" suggestion is displayed correctly and in the correct case. 2. On Sheet2, observe how the name of the sheet and range name are changed to lowercase. This does not occur on Sheet1. However, modifying the sheet and range names to be lowercase does not resolve this problem. --------------------------------------------------------------------- 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]
