Am 20.01.2016 um 11:35 schrieb pacopyc pacopyc:
> Excuse me, I don't understand. Can I rewrite the formulas in R1C1 reference
> style with LibreOffice basic code? How?
>
No, you can't. But since you are a programmer, this should be no problem
at all.
Instead of "R"& row &"C"& col you can simply u
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 cov
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 :
> 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
You can select it for the spreadsheet in:
Menu/Tools/Options/LibreOffice calc/Formula - Formula Options - Formula
syntax
Miguel Ángel.
--
View this message in context:
http://nabble.documentfoundation.org/R1C1-reference-style-with-LibreOffice-tp4172305p4172334.html
Sent from the Users mailing
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=
