Is it possible to get and set formulae in a Calc cell using R1C1 rather than A1 strings? I found that even if the option to use R1C1 is set in the Tools | Options menu, the value of Cell.Formula is still in A1 format.
If not, I'll suggest it as an option. As I recall from many years ago using VBA there was a FormualR1C1 (or something like it) property, and when setting up a formula which references many items on the same row or column it's a lot easier to use (IMHO). ----- Peter -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
