Thanks for your replies. It is encouraging to see that there really are some advanced Calc users out there. Is there a better forum for such an animal to make a nest?
On 10/22/05, Mark Kirchner <[EMAIL PROTECTED]> wrote: > On Friday, October 21, 2005, 10:46:01 PM, Bryce Schober wrote: > > R1C1 is a completely different style of range addressing that excel > > supports. It looks like "R3C8:R6C9", meaning "include cells in the > > 3rd to 6th rows and the 8th to 9th columns, inclusive". > > Like the others have pointed out, there seems to be no "real" support > for R1C1-addressing. But it seems to me, that there is a (quite clumsy) > workaround. Nevertheless, it should work in most cases: > > You have to use a combination of the INDIRECT and ADDRESS functions. > (Since I'm using the German version of OOo, I'm not totally sure if my > translations of the function-names are correct, but I hope they'll > point into the right direction at least.) > > So, to translate an Excel-like > > =SUM(R3C8:R6C9) > > to Calc, use > > =SUM(INDIRECT(ADDRESS(3;8) & ":" & ADDRESS(6;9))) > > Regards, > Mark Kirchner > > -- > ______________________________________________________________________ > My OpenPGP-Key: http://www.mark-kirchner.de/keys/key-mk.asc > Fingerprint: 583E 298D 8C0C 11C3 9882 5654 FEF6 675C 172C 073C > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Bryce Schober --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
