Re: macro equivalent of VBA Range()
Range( ) is supported in AOO Basic, when the VBA compatibility mode is on. It can be used within a function, but can't be used as a parameter... On 3 July 2015 at 10:26, JZA acolor...@gmail.com wrote: On Wed, Jul 1, 2015 at 8:57 AM, Andrew Pitonyak and...@pitonyak.org wrote: On 30.06.2015 14:54, Mark Polczynski wrote: I am an absolute beginner to OpenOffice macros, but have some knowledge of VBA. What is the OpenOffce macro equivalent of the VBA statement: x = Range(Y) Also, what is the equivalent of: x = Cells(1,1) Thanks! Mark Polczynski I assume that you posted this to the forum as suggested, but, I did not see your question there (it is a better place to answer these questions) You get cells from the sheet containing them. I am unsure what Range(Y) does, but a rough guess is that it is a defined range. Doing some googling this seems to explain what range is: https://msdn.microsoft.com/en-us/library/office/ff836512.aspx Just as Andrew mentioned, is the same as GetCellRangeBy[Position, Name]. So, if you just want the currently active sheet in a Calc document, you can do something like this: ThisComponent.CurrentController.getActiveSheet() If you want a specific sheet, you can use ThisComponent.Sheets.getByIndex(insert sheet index here) ThisComponent.Sheets.getByName(insert sheet name here) Now, assume that you want cell A1, you can use ThisComponent.CurrentController.getActiveSheet().getCellByPosition(0, 0) The first 0 means the first column and the second 0 means the first row. You can also use: getCellByPosition(left, top) Get a cell within the range. getCellRangeByPosition(left, top, right, bottom) Get a cell range within the range. getCellRangeByName(name) Get a cell range within the range based on its name. The string directly references cells using the standard formats — such as “B2:D5” or “$B$2” — or defined cell range names. Hope this helps. Oh, and you can find some examples here: http://www.pitonyak.org/oo.php http://www.pitonyak.org/AndrewMacro.odt http://www.pitonyak.org/OOME_3_0.odt - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614
Re: macro equivalent of VBA Range()
I assume that you posted this to the forum as suggested, but, I did not see your question there (it is a better place to answer these questions) https://forum.openoffice.org/en/forum/viewtopic.php?f=45t=77925 But no feedback from the author. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: macro equivalent of VBA Range()
On Wed, Jul 1, 2015 at 8:57 AM, Andrew Pitonyak and...@pitonyak.org wrote: On 30.06.2015 14:54, Mark Polczynski wrote: I am an absolute beginner to OpenOffice macros, but have some knowledge of VBA. What is the OpenOffce macro equivalent of the VBA statement: x = Range(Y) Also, what is the equivalent of: x = Cells(1,1) Thanks! Mark Polczynski I assume that you posted this to the forum as suggested, but, I did not see your question there (it is a better place to answer these questions) You get cells from the sheet containing them. I am unsure what Range(Y) does, but a rough guess is that it is a defined range. Doing some googling this seems to explain what range is: https://msdn.microsoft.com/en-us/library/office/ff836512.aspx Just as Andrew mentioned, is the same as GetCellRangeBy[Position, Name]. So, if you just want the currently active sheet in a Calc document, you can do something like this: ThisComponent.CurrentController.getActiveSheet() If you want a specific sheet, you can use ThisComponent.Sheets.getByIndex(insert sheet index here) ThisComponent.Sheets.getByName(insert sheet name here) Now, assume that you want cell A1, you can use ThisComponent.CurrentController.getActiveSheet().getCellByPosition(0, 0) The first 0 means the first column and the second 0 means the first row. You can also use: getCellByPosition(left, top) Get a cell within the range. getCellRangeByPosition(left, top, right, bottom) Get a cell range within the range. getCellRangeByName(name) Get a cell range within the range based on its name. The string directly references cells using the standard formats — such as “B2:D5” or “$B$2” — or defined cell range names. Hope this helps. Oh, and you can find some examples here: http://www.pitonyak.org/oo.php http://www.pitonyak.org/AndrewMacro.odt http://www.pitonyak.org/OOME_3_0.odt - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614
Re: macro equivalent of VBA Range()
On 30.06.2015 14:54, Mark Polczynski wrote: I am an absolute beginner to OpenOffice macros, but have some knowledge of VBA. What is the OpenOffce macro equivalent of the VBA statement: x = Range(Y) Also, what is the equivalent of: x = Cells(1,1) Thanks! Mark Polczynski I assume that you posted this to the forum as suggested, but, I did not see your question there (it is a better place to answer these questions) You get cells from the sheet containing them. I am unsure what Range(Y) does, but a rough guess is that it is a defined range. So, if you just want the currently active sheet in a Calc document, you can do something like this: ThisComponent.CurrentController.getActiveSheet() If you want a specific sheet, you can use ThisComponent.Sheets.getByIndex(insert sheet index here) ThisComponent.Sheets.getByName(insert sheet name here) Now, assume that you want cell A1, you can use ThisComponent.CurrentController.getActiveSheet().getCellByPosition(0, 0) The first 0 means the first column and the second 0 means the first row. You can also use: getCellByPosition(left, top) Get a cell within the range. getCellRangeByPosition(left, top, right, bottom) Get a cell range within the range. getCellRangeByName(name) Get a cell range within the range based on its name. The string directly references cells using the standard formats — such as “B2:D5” or “$B$2” — or defined cell range names. Hope this helps. Oh, and you can find some examples here: http://www.pitonyak.org/oo.php http://www.pitonyak.org/AndrewMacro.odt http://www.pitonyak.org/OOME_3_0.odt - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: macro equivalent of VBA Range()
For this kind of question, the best way is to go on the community forum: https://forum.openoffice.org/en/forum/viewforum.php?f=20 - Mail original - De: Mark Polczynski mhp.techfo...@gmail.com À: dev@openoffice.apache.org Envoyé: Mardi 30 Juin 2015 20:54:43 Objet: macro equivalent of VBA Range() I am an absolute beginner to OpenOffice macros, but have some knowledge of VBA. What is the OpenOffce macro equivalent of the VBA statement: x = Range(Y) Also, what is the equivalent of: x = Cells(1,1) Thanks! Mark Polczynski - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
macro equivalent of VBA Range()
I am an absolute beginner to OpenOffice macros, but have some knowledge of VBA. What is the OpenOffce macro equivalent of the VBA statement: x = Range(Y) Also, what is the equivalent of: x = Cells(1,1) Thanks! Mark Polczynski