[sc-issues] [Issue 84667] Range Naming non-consecuti ve cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84667 User webweaver64 changed the following: What|Old value |New value Version|OOo 2.3.1 |OOo 3.1 --- Additional comments from webweave...@openoffice.org Sat Jun 6 21:05:06 + 2009 --- This is still true for 3.1 - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 84667] Range Naming non-consecuti ve cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84667 User drking changed the following: What|Old value |New value CC|''|'drking' --- Additional comments from [EMAIL PROTECTED] Tue Jan 29 08:38:33 + 2008 --- I am unable to name a range that includes non-consecutive cells. From issue 25769: Calc doesn't allow a multi-selection to be defined as a name I also lose any ranges that are named when importing from excel. I am able to import ranges from Excel97 to OOo2.3.1 (WinXP). They do not show in the Data-Select Range... dialogue - but they do work in formulae. This even applies to non-contiguous ranges, so having imported an Excel generated file with a non-contiguous range called 'myxlrange' I can do =AREAS(myxlrange) to count the number of non-contiguous ranges. Unfortunately, I can then enter the same name 'myxlrange' in the Data-Define range dialogue, which enables me to select that new range via Data-Select Range... - however any formulae still use the Excel defined range. webweaver64, are you able to confirm that you get this behaviour too? I'm anxious to be sure that this is not just my system. - 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]
[sc-issues] [Issue 84667] Range Naming non-consecuti ve cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84667 User webweaver64 changed the following: What|Old value |New value OS/Version|Windows XP|Windows, all --- Additional comments from [EMAIL PROTECTED] Tue Jan 29 17:14:11 + 2008 --- Yes I can confirm this. I can create a range in excel (2003). Open it in OOo (2.3.1 Dev 2.4.0m4). The range is not listed in DataSelect Range, nor can you type the name in the location box. Any formula that used the name, doesn't change. I can create a range in OOo with the same name, and use DataSelect to select this range. If I create a new formula with the range name it uses the one originally created in excel, not the range created in OOo. When reopened in excel, it adds a _1 to the new range; e.g.: range_1. I'm changing this to Windows all as I was using both Vista and XP to check this. I would bet this is not OS specific. - 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]
[sc-issues] [Issue 84667] Range Naming non-consecuti ve cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84667 --- Additional comments from [EMAIL PROTECTED] Sun Jan 6 06:07:43 + 2008 --- It looks like the following issues also are about this issue, however they are from version 1.x and again this effect spreadsheets being imported from excel. Until this is fixed I'm unable to stop using excel. I-10754 I-25769 I-25770 I-25771 - 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]
[sc-issues] [Issue 84667] Range Naming non-consecuti ve cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84667 Issue #|84667 Summary|Range Naming non-consecutive cells Component|Spreadsheet Version|OOo 2.3.1 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|webweaver64 --- Additional comments from [EMAIL PROTECTED] Mon Dec 17 19:51:18 + 2007 --- I am unable to name a range that includes non-consecutive cells. I also lose any ranges that are named when importing from excel. - 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]