Ask Your Question
0

Paste named ranges in data validity dialog?

asked 2018-12-05 16:40:58 +0100

LibOff gravatar image

Is there a way to paste named ranges in the dialog setting up data validity? In data validity Criteria tab you may select a 'cell range' as source. However, I could not find a quick way to enter a named range in the source area of the dialog unless I actually remember what the range name is and I type it out. I recall that by comparison in Excel pressing F3 shows your named ranges and by selecting one named range it is added to the open dialog accordingly.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2018-12-08 10:10:29 +0100

LibOff gravatar image

Thank you for the information. I see that this matter was reported just over a year ago, but I hope that it will be corrected at some time in the future.

edit flag offensive delete link more

Comments

-1- This is not an answer. Askbot rules would require to post this as a comment on the answer by @kompilainenn .
-2- The so called bug is treated like a bug, but actually is an enhancement request. It may only get resolved if a developer chooses to work on it in "cherry-picking" mode.

Lupp gravatar imageLupp ( 2018-12-08 12:38:51 +0100 )edit
0

answered 2018-12-06 10:16:21 +0100

kompilainenn gravatar image

No way , for example there is a bug https://bugs.documentfoundation.org/s...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-12-05 16:40:58 +0100

Seen: 34 times

Last updated: yesterday