Ask Your Question
0

Calc Name Box - how can I get it to display relative ranges? [closed]

asked 2012-06-03 07:59:43 +0200

gustep gravatar image

Hi there. I often use the "Name Box" to visually confirm that I have selected an appropriate range of data. For example, when I try to select 551 columns, then a glance at the "Name Box" usually tells me if I got it right during highlighting, i.e. by showing "1R x 551C" or similar. I guess I want it to display the data range in relative units. How can I get this functionality in LibreOffice? It doesn't do me any good if I see LibreOffice's absolute data range like "CR5:GC5", I mean, how many columns is that?? I don't think I can subtract alphanumeric column numbers on the fly in my mind.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-22 11:11:41.493649

Comments

Hi @gustep, Sounds like a neat feature. I don't believe it's currently implemented, so please file an enhancement bug and provide as much information as possible. The QA team will be happy to help you triage your feature request in the bugtracker. Thanks!

qubit gravatar imagequbit ( 2013-01-27 22:05:08 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2012-06-03 10:49:13 +0200

m.a.riosv gravatar image

Maybe using RC notation can help you.

Menu/Tools/Options/LibreOffice Calc/Formula/Formula sintax.

edit flag offensive delete link more
0

answered 2013-02-19 01:58:04 +0200

qubit gravatar image

(question for resolution)

Hi @gustep,

Sounds like a neat feature. I don't believe it's currently implemented, so please file an enhancement bug and provide as much information as possible. Don't forget to mark your bug as an 'enhancement'. The QA team will be happy to help you triage your feature request in the bugtracker.

Please post a link to any bugs you file in a comment below using the format "fdo#123456".

Thanks!

edit flag offensive delete link more
0

answered 2013-02-19 02:07:35 +0200

m.a.riosv gravatar image

image description

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-06-03 07:59:43 +0200

Seen: 594 times

Last updated: Feb 19 '13