[CWiki] Account Whitelisting

[aarn.wong]

Username: aarn.wong


Name: Aaron Wong

[CWiki] Account Whitelisting

[aarn.wong]

Hi,


I would like to have my account whitelisted.


Thanks,


Aaron

Completed Introduction to Contributing to Apache OpenOffice Module

[aarn.wong]

Hi,


I have completed the introduction to contributing to Apache OpenOffice Module.


Thanks,


Aaron

Re: Heading wise navigation in Structural Navigation

[Alejandro Lopez Rios]

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

Re: macro equivalent of VBA Range()

[JZA]

On Wed, Jul 1, 2015 at 8:57 AM, Andrew Pitonyak  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()
> ThisComponent.Sheets.getByName()
>
> 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

New Dev Volunteer

[aarn.wong]

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()

[FR web forum]

>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=45&t=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