We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

In calc how do i select background object [closed]

asked 2017-10-31 21:17:04 +0200

stu gravatar image

I cannot select it, so I cannot bring it to the foreground.

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 2020-10-19 13:20:10.492175

2 Answers

Sort by » oldest newest most voted

answered 2017-10-31 21:47:29 +0200

Lupp gravatar image

updated 2017-11-01 10:23:00 +0200

Sorry. My original answer was misleading and incomplete.
-1- Unfortunately the white pointing arrow always looks exactly the same though it has different functionalities. In Calc it selects cells by default. A foreground object where covering the area of cells can also be selected.
-2- Wanting to select background objects you need to first activate the 'Select' functionality from the 'Drawing' toolbar. This is also needed if you want to create a frame for selection.
-3- To select an object then by pointing is surely simpler then than by catching it with a frame.

(Original Answer:)
Draw a selecting frame completely containing the object. You may even need to change the zoon for the action.

edit flag offensive delete link more


Because of the community's stupid rules, I can't get enough points in order to upvote answers although I've been a member of this community for the last couple of years. Hence, currently I'm unfortunately still unable to upvote good answers like yours. Anyway, congratulations: your answer did help me solving the problem.

Yuri R. Sucupira gravatar imageYuri R. Sucupira ( 2018-11-08 12:36:57 +0200 )edit

If you ask a question like "How to get entitled to upvote contributions?" someone might upvote that question an you would get "karma".
From your user page I see that you only posted one answer to date, and unfortunately nobody upvoted it. (I cannot do it in this case because I lack knowledge needed to judge if that answer was good.)

Lupp gravatar imageLupp ( 2018-11-08 13:00:17 +0200 )edit

Thanks, this is the solution!

Rmano gravatar imageRmano ( 2020-08-24 13:25:39 +0200 )edit

answered 2017-11-01 00:57:07 +0200

m.a.riosv gravatar image

Use the navigator on the side bar or Menu/View/Navigator [F5]

edit flag offensive delete link more


For me (V 5.4.2 currently) this only works based on the names of the objects. Images get a default name (numbering them). Shapes don't. They aren't selectable from the 'Navigator' therefore. However, shapes can get assigned a name explicitly and will then also be listed.

We might consider the lack of automatic naming a bug. On the other hand documents may contain dozens or even hundreds of shapes...

Lupp gravatar imageLupp ( 2017-11-01 10:34:49 +0200 )edit

Surely a bug: A previously named shape that once was grouped and later made independent again does neither show its name nor show up in the 'Navigator'. The original name is locked as used though not displayed. The shape doesn't get accessible again if a new name is assigned.
Groups cannot be named at all.

Lupp gravatar imageLupp ( 2017-11-01 10:43:20 +0200 )edit

Thanks @Lupp, sure a bug, images are showed even with with a default name, but now draw objects. There is a reported about Draw https://bugs.documentfoundation.org/s....

Seems that objects are created without default name, so not showed on the navigator.

m.a.riosv gravatar imagem.a.riosv ( 2017-11-01 16:02:24 +0200 )edit

Since Draw shapes in a document tend to get very numerous, the exclusion of unnamed shapes from the navigator may be a blessing,in disguise. Definitely bad is the behaviour mentioned under "Surely a bug" and concerning former members of resolved groups. I did not yet serch for a related bug report.
BTW (just tested): in Calc shapes don't get automatic names. In Writer they get. In Draw they even haven't (shown?) such a property. Not a mess?

Lupp gravatar imageLupp ( 2017-11-01 16:42:48 +0200 )edit

Question Tools

1 follower


Asked: 2017-10-31 21:17:04 +0200

Seen: 2,678 times

Last updated: Nov 01 '17