Re: [api-dev] getCellAddress() returns garbage
Hi Andrew, Andrew Douglas Pitonyak a écrit : Is the method getCellAddress() deprecated? I am not able to obtain valid results. For example, I ran the following macro on FC6 (with what ever came with the system, which means I am still on 2.04 with a fedora supplied build) it at a 64 bits platform ? Laurent -- Laurent Godard [EMAIL PROTECTED] - Ingénierie OpenOffice.org - http://www.indesko.com Nuxeo Enterprise Content Management http://www.nuxeo.com - http://www.nuxeo.org Livre Programmation OpenOffice.org, Eyrolles 2004-2006 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] getCellAddress() returns garbage
Cor Nouws wrote: Hi Andrew, Andrew Douglas Pitonyak wrote: Is the method getCellAddress() deprecated? I am not able to obtain valid results. For example, I ran the following macro on FC6 (with what ever came with the system, which means I am still on 2.04 with a fedora supplied build) Sub TestCellAddress Dim oCell Dim oAddress oCell = ThisComponent.Sheets(0).getCellByPosition(2, 3) oAddress = oCell.getCellAddress() MsgBox Sheet = oAddress.Sheet CHR$(10) _ Column = oAddress.Column CHR$(10) _ Row = oAddress.Row End Sub Returned: Sheet = -2268 Column = 32767 Row = -1189158716 Returns 0, 2, 3 for me. Thus OK. And when I use oCell = ThisComponent.getCurrentSelection() I also retrieve the correct (selected) address. This with OOo 2.1 / XP So maybe your system is just in need for a little break ;-) Best wishes, Thanks for checking. I will assume that there is an issue with the version built and supplied by the FC6 AMD64 distro. I do know that it has the Novell stuff integrated, so it is not a straight OOo install. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] getCellAddress() returns garbage
Laurent Godard wrote: Hi Andrew, Andrew Douglas Pitonyak a écrit : Is the method getCellAddress() deprecated? I am not able to obtain valid results. For example, I ran the following macro on FC6 (with what ever came with the system, which means I am still on 2.04 with a fedora supplied build) it at a 64 bits platform ? Laurent Yes, FC6 AMD64, standard distro, which means that it also includes the Novell stuff. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] getCellAddress() returns garbage
Hi Andrew Yes, FC6 AMD64, standard distro, which means that it also includes the Novell stuff. may be the problem is related to this http://www.openoffice.org/issues/show_bug.cgi?id=71815 I relayed to Caolan Laurent -- Laurent Godard [EMAIL PROTECTED] - Ingénierie OpenOffice.org - http://www.indesko.com Nuxeo Enterprise Content Management http://www.nuxeo.com - http://www.nuxeo.org Livre Programmation OpenOffice.org, Eyrolles 2004-2006 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] getCellAddress() returns garbage
Andrew Douglas Pitonyak wrote: Cor Nouws wrote: Hi Andrew, Andrew Douglas Pitonyak wrote: Is the method getCellAddress() deprecated? I am not able to obtain valid results. For example, I ran the following macro on FC6 (with what ever came with the system, which means I am still on 2.04 with a fedora supplied build) Sub TestCellAddress Dim oCell Dim oAddress oCell = ThisComponent.Sheets(0).getCellByPosition(2, 3) oAddress = oCell.getCellAddress() MsgBox Sheet = oAddress.Sheet CHR$(10) _ Column = oAddress.Column CHR$(10) _ Row = oAddress.Row End Sub Returned: Sheet = -2268 Column = 32767 Row = -1189158716 Returns 0, 2, 3 for me. Thus OK. And when I use oCell = ThisComponent.getCurrentSelection() I also retrieve the correct (selected) address. This with OOo 2.1 / XP So maybe your system is just in need for a little break ;-) Best wishes, Thanks for checking. I will assume that there is an issue with the version built and supplied by the FC6 AMD64 distro. I do know that it has the Novell stuff integrated, so it is not a straight OOo install. Hi Andrew, it works for me as well. The problem with the distro builds or what ever is that we sometimes have this strange errors and we waste a lot of time with the analysis. It seems that QA for this builds is not in place or simply pure. I strongly recommend to use one of the official builds from OO.org to be sure that you get a tested and working OO.org version. Juergen - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[api-dev] getCellAddress() returns garbage
Is the method getCellAddress() deprecated? I am not able to obtain valid results. For example, I ran the following macro on FC6 (with what ever came with the system, which means I am still on 2.04 with a fedora supplied build) Sub TestCellAddress Dim oCell Dim oAddress oCell = ThisComponent.Sheets(0).getCellByPosition(2, 3) oAddress = oCell.getCellAddress() MsgBox Sheet = oAddress.Sheet CHR$(10) _ Column = oAddress.Column CHR$(10) _ Row = oAddress.Row End Sub Returned: Sheet = -2268 Column = 32767 Row = -1189158716 -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/index.html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [api-dev] getCellAddress() returns garbage
Hi Andrew, Andrew Douglas Pitonyak wrote: Is the method getCellAddress() deprecated? I am not able to obtain valid results. For example, I ran the following macro on FC6 (with what ever came with the system, which means I am still on 2.04 with a fedora supplied build) Sub TestCellAddress Dim oCell Dim oAddress oCell = ThisComponent.Sheets(0).getCellByPosition(2, 3) oAddress = oCell.getCellAddress() MsgBox Sheet = oAddress.Sheet CHR$(10) _ Column = oAddress.Column CHR$(10) _ Row = oAddress.Row End Sub Returned: Sheet = -2268 Column = 32767 Row = -1189158716 Returns 0, 2, 3 for me. Thus OK. And when I use oCell = ThisComponent.getCurrentSelection() I also retrieve the correct (selected) address. This with OOo 2.1 / XP So maybe your system is just in need for a little break ;-) Best wishes, -- Cor Nouws Arnhem - Netherlands nl.OpenOffice.org - marketing contact - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
