How to change to r1c1 reference style if possible

[juntjoo]

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]

The old R1C1 style is only supported in arguments to some functions, not in the general spreadsheet.

[juntjoo]

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]

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.

[juntjoo]

Oh okay, thanks anyway