Re: [libreoffice-users] Re: R1C1 reference style with LibreOffice

If it's only a matter of rewriting R1C1 in A1 notations, a simple function
could read the Rx and put the appropriate letter, then remove the C.
If you want to reference cells from the basic code, functions alreay exist
to get cells from their numeric coordinates, as said by others.
I think this cover most cases; also know that you can use the INDIRECT()
function directly in a cell with the R1C1 notation.

-- 
Cley Faye
http://cleyfaye.net

2016-01-20 11:35 GMT+01:00 pacopyc pacopyc <pacopyc@gmail.com>:

> Excuse me, I don't understand. Can I rewrite the formulas in R1C1 reference
> style with LibreOffice basic code? How?
>
> 2016-01-20 11:14 GMT+01:00 Andreas Säger <villeroy@t-online.de>:
>
> > Am 20.01.2016 um 10:17 schrieb pacopyc pacopyc:
> > > Ok, but the problem is that I must do it from LibreOffice basic code.
> >
> > If you would spend more than an hour or two with this matter, you would
> > not have to wait days for the answer.
> >
> >
> >
> >
> > > https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=49294
> >
> > >
> http://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1table_1_1XCellRange.html#details
> > > http://www.pitonyak.org/oo.php
> >
> >
> >
> >
> >
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted