[sc-issues] [Issue 115860] oSheets.getCellRangesByNa me("Sh.eet2.A1") fails with c.s.s.lIllegalArgu mentException
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115860 --- Additional comments from brinz...@openoffice.org Thu Dec 2 14:11:44 + 2010 --- @er what about adding your comments to http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangesAccess.html ? - 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 115860] oSheets.getCellRangesByNa me("Sh.eet2.A1") fails with c.s.s.lIllegalArgu mentException
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115860 --- Additional comments from brinz...@openoffice.org Thu Dec 2 13:15:05 + 2010 --- thanks for the lesson ;-) added a small test for common special characters REM * BASIC * OPTION EXPLICIT Sub TestSheetNames On Local Error Goto ErrorHandler Dim oDoc as Object Dim oSheets as Object Dim mChars as String Dim i as Integer Dim s as String Dim sName as String Dim mRanges() i = 1 mChars = "*:[]/\'? $.;°!§%&()=<>|,-_#+~`´²³...@µ^{}ß""" oDoc = ThisComponent oSheets = oDoc.getSheets() s = "can not insert sheets with chars: " For i = 1 To Len(mChars) sName = Mid(mChars, i, 1) If oSheets.hasByName(sName) Then oSheets.removeByName(sName) EndIf oSheets.insertNewByName(sName, oSheets.getCount()) Next i s = s & Chr(13) & Chr(13) & "failed to access cellranges without quoting: " For i = 0 To oSheets.getCount()-1 sName = oSheets.getByIndex(i).getName() mRanges() = oSheets.getCellRangesByName(sName & ".A1") Next i s = s & Chr(13) & Chr(13) & "failed to access a cellrange without quoting: " For i = 0 To oSheets.getCount()-1 sName = oSheets.getByIndex(i).getName() oSheets.getByName(sName).getCellRangeByName(sName & ".A1") Next i MsgBox (s, 64, "Check characters") Exit Sub ErrorHandler: s = s & sName Resume Next End Sub - 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 115860] oSheets.getCellRangesByNa me("Sh.eet2.A1") fails with c.s.s.lIllegalArgu mentException
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115860 User er changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from e...@openoffice.org Wed Dec 1 13:13:54 + 2010 --- If the sheet name contains dots or operators or blanks it needs to be enclosed in single quotes => "'Sh.eet2'.A1" To be on the safe side enclose it in single quotes if not all characters are alphanumeric. If the sheet name contains single quotes it shall be enclosed in single quotes and the single quotes enclosed shall be escaped by doubling them: "'Sh''eet2'.A1" - 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 115860] oSheets.getCellRangesByNa me("Sh.eet2.A1") fails with c.s.s.lIllegalArgu mentException
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115860 User er changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from e...@openoffice.org Wed Dec 1 13:14:10 + 2010 --- Closing. - 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 115860] oSheets.getCellRangesByNa me("Sh.eet2.A1") fails with c.s.s.lIllegalArgu mentException
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115860 Issue #|115860 Summary|oSheets.getCellRangesByName("Sh.eet2.A1") fails with c |.s.s.lIllegalArgumentException Component|Spreadsheet Version|OOO330m15 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|brinzing --- Additional comments from brinz...@openoffice.org Wed Dec 1 09:53:22 + 2010 --- steps to reproduce: - open new spreadsheet - rename "Sheet2" to "Sh.eet2" - run macro result: com.sun.star.lang.IllegalArgumentException if dots "." are valid for sheet names, oSheet.getCellRangeByName() and oSheets.getCellRangesByName() should use the *last* occuring "." as separator for SheetName and Range. REM * BASIC * OPTION EXPLICIT Sub Main Dim oDoc as Object Dim oSheets as Object oDoc = ThisComponent oSheets = oDoc.getSheets() Dim mRanges() mRanges() = oSheets.getCellRangesByName("Sheet1.A1") MsgBox "Sheet Index: " & mRanges(0).getRangeAddress().Sheet ' oSheet.getCellRangeByName("Sh.eet2.A1") is also affected mRanges() = oSheets.getCellRangesByName("Sh.eet2.A1") MsgBox "Sheet Index: " & mRanges(0).getRangeAddress().Sheet End Sub - 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