How to change to r1c1 reference style if possible
How to change to r1c1 reference style if possible
Just learning this more advanced reference style which works partially using the "indirect" function but I cannot do equations with it, no matter which app in Android I use. So in guessing I need to change the program/app preferences to the r1c1 style which I'm having trouble doing in most apps for android. Was thinking/hoping this app could do it as it appears to be desktop program based. Anyone know if this is possible? Thanks
-
- SoftMaker Team
- Posts: 2874
- Joined: Fri Nov 21, 2003 4:57 pm
- Location: Nürnberg, Germany
- Contact:
Re: How to change to r1c1 reference style if possible
The old R1C1 style is only supported in arguments to some functions, not in the general spreadsheet.
Martin Kotulla
SoftMaker Software GmbH
SoftMaker Software GmbH
Re: How to change to r1c1 reference style if possible
Oh. So is it possible to have two cells referenced in this format relate to each other in an equation like "=r[1]c[1]+r[1]+c[2]"?
Not sure if you implied the answer there. Thanks!
Not sure if you implied the answer there. Thanks!
-
- SoftMaker Team
- Posts: 2874
- Joined: Fri Nov 21, 2003 4:57 pm
- Location: Nürnberg, Germany
- Contact:
Re: How to change to r1c1 reference style if possible
No. I was referring to functions that take a string argument, and that string argument represents a cell address. I think that INDIRECT is the only function that does this:
=INDIRECT("R5C3", FALSE)
(The argument FALSE tells PlanMaker that the first argument uses the old Multiplan addressing style R1C1.)
There is no more support than that, and it is unlikely that there will ever be. This is really an outdated addressing type.
=INDIRECT("R5C3", FALSE)
(The argument FALSE tells PlanMaker that the first argument uses the old Multiplan addressing style R1C1.)
There is no more support than that, and it is unlikely that there will ever be. This is really an outdated addressing type.
Martin Kotulla
SoftMaker Software GmbH
SoftMaker Software GmbH
Re: How to change to r1c1 reference style if possible
Oh okay, thanks anyway