[CWiki] Account Whitelisting
Hi, I would like to have my account whitelisted. Thanks, Aaron
[CWiki] Account Whitelisting
Username: aarn.wong Name: Aaron Wong
Completed Introduction to Contributing to Apache OpenOffice Module
Hi, I have completed the introduction to contributing to Apache OpenOffice Module. Thanks, Aaron
New Dev Volunteer
Hi, My name is Aaron. I am from Brooklyn, NY. I just graduated from the Ohio State University with a bachelor’s degree in mathematics. Working on programming projects has been a hobby of mine since I started college. Most of what I know is self taught. I hope to learn a lot more by participating in open office. Thanks, Aaron Wong
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: Heading wise navigation in Structural Navigation
El jueves, 2 de julio de 2015, 0:54:32 (UTC-5), Dhairyashil Bhosale escribio: Hola a todos,estoy trabajando en la rúbrica de navegación sabio en LibreOffice. Para que hice algunos cambios en 'soffice / structural_ navigation.py 'en escritura de lector de pantalla Orca, los cambios son los siguientes: 1) añadido enabledTypes = StructuralNavigation.HEADING 'en' soffice / script.py ' para permitir la rúbrica de navegación inteligente . es SN (navegación estructural) para LibreOffice 2) añade clase MatchCriteria ', en' structural_navigation.py '. 3) métodos como añadido: 'findNextObject ()', 'findPrevByMatchRule ()', 'findNextByMatchRule ()', 'headingLevels () ',' headingCriteria () ',' headingPredicate () ',' headingPresentation () ', 'getHeadingLevel ()', 'getDocument ()', etc. relacionada con SN en LibreOffice. Pero me di cuenta de que cuando pulso ' h 'después de habilitar SN para LibreOffice se hablará de que, 'messages.WRAPPING_TO_TOP', significa que no puede identificar el título en el documento. Así que para permitir la partida de navegación sabio en libreoffice usando lector de pantalla Orca, que las cosas que necesito para poner en práctica, Yo could't entender el flujo de trabajo o método de secuenciación vocación en la navegación estructural para Libreoffice. así que por favor cualquiera hubiera idea relacionada esta responda. Con Saludos, Dhairyashil B. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org