Issue 122427 - Unable to edit image once set as background in cell
Summary: Unable to edit image once set as background in cell
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.0.0-dev
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-05-31 12:12 UTC by Greg
Modified: 2018-06-03 18:07 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: 4.0.0
Developer Difficulty: ---

Numbered Tickets in Calc with text & formaula over background image (398.64 KB, image/png)
2013-05-31 12:12 UTC, Greg
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Greg 2013-05-31 12:12:43 UTC
Created attachment 80751 [details]
Numbered Tickets in Calc with text & formaula over background image

Similar to 38352 (closed), but definitely reproducible.  Occurs with OOO Calc 3.4.1 build 9593 and OOO Calc 4.0.0 build 9700, 21 May 13.  Running Windows 7 Home Premium SP1 32 bit on Dell 745 Pentium D 3.4GHz, 4G RAM.

I wanted to have formula and text in several cells over a background image to create sequentially numbered tickets on microperforated business cards -- see attached Tickets.png (cell borders shown).

Open Calc. Click on a cell to select, click INSERT on menu bar, click option Picture|From File. Pictures Library opens. Click a folder to open, then an image file name to select, click Open button.  A full size image appears over many cells.

Right click image, click Position and Size, set Width to (say) 5cm, check Keep Ratio, click OK. Smaller image appears, covering several cells. Right click image, click Arrange, click To Background.  Cell borders now visible over the image, text/formulas may be entered.

BUT image can no longer be selected for further editing, such as to adjust size or position.

'Undo' will restore the image attributes to make it editable again.

If Send to Back is clicked, text can be entered which shows over the image, but is not subsequently editable.

Also, adjusting row or column size stretches the image.
Comment 1 Edwin Sharp 2013-06-02 17:44:55 UTC
Image can not be selected once Arrange To Background.

AOO400m2(Build:9701)  -  Rev. 1484819
2013-05-22_04:11:58 - Rev. 1485058
Comment 2 Regina Henschel 2013-06-02 18:25:47 UTC
Use the Navigator and double-click the corresponding item in the group Graphics.

I think it is no bug, but a request for enhancement. In Writer it is possible to select a background image with Ctrl-click. In Calc that short cut is already used, but for example Alt-click seems to be free and Alt-click is used in Draw to select deeper objects in the stack.
Comment 3 Edwin Sharp 2013-06-03 06:27:41 UTC
Change to enhancement according to Regina.
Comment 4 Regina Henschel 2018-06-03 18:07:30 UTC
Or you can use the selection tool (white arrow) from the Drawing toolbar.