How to change to r1c1 reference style if possible

Post your questions, bug reports and suggestions here for PlanMaker HD for Android.

Moderator: SoftMaker Team

Post Reply
juntjoo
Posts: 8
Joined: Wed Jan 06, 2016 10:42 am

How to change to r1c1 reference style if possible

Post by juntjoo » Wed Jan 06, 2016 10:51 am

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

martin-k
SoftMaker Team
SoftMaker Team
Posts: 2961
Joined: Fri Nov 21, 2003 4:57 pm
Location: Nürnberg, Germany
Contact:

Re: How to change to r1c1 reference style if possible

Post by martin-k » Wed Jan 06, 2016 10:55 am

The old R1C1 style is only supported in arguments to some functions, not in the general spreadsheet.
Martin Kotulla
SoftMaker Software GmbH

juntjoo
Posts: 8
Joined: Wed Jan 06, 2016 10:42 am

Re: How to change to r1c1 reference style if possible

Post by juntjoo » Wed Jan 06, 2016 11:12 am

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!

martin-k
SoftMaker Team
SoftMaker Team
Posts: 2961
Joined: Fri Nov 21, 2003 4:57 pm
Location: Nürnberg, Germany
Contact:

Re: How to change to r1c1 reference style if possible

Post by martin-k » Wed Jan 06, 2016 11:39 am

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.
Martin Kotulla
SoftMaker Software GmbH

juntjoo
Posts: 8
Joined: Wed Jan 06, 2016 10:42 am

Re: How to change to r1c1 reference style if possible

Post by juntjoo » Wed Jan 06, 2016 11:46 am

Oh okay, thanks anyway

Post Reply

Return to “PlanMaker HD”