I want to get the current column letter [closed]

asked 2013-09-24 04:06:23 +0100

mythicalprogrammer gravatar image

For example:

instead of

=AVERAGE(T1:T21)

I want

=AVERAGE(currentColumnLetter1:CurrentColumnLetter21)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-04 23:08:53.699231

Comments

Don't really understand what is your real problem? Why can't you write =AVERAGE(T1:T21) instead? If you would like to copy formula, then references will automatically change to current column/row. Please write more what are you trying to achieve. Also provide the version of LibreOffice and operating system you are using.

L-user gravatar imageL-user ( 2013-09-24 09:30:35 +0100 )edit