How to view an image only after clicking on a description

In calc I want to have a description for a gemstone and then be able to see that gemstone only after clicking on it’s description.

… and where are your images stored (withing the same Calc document, in a directory structure of your [unknown] operating system, on the internet)? What should happen afterwards (disappear - if yes, when)? Do you want it to be shown in an external application or, if embedded, being brought into foreground?


Right now your idea seems to need some further explanation (regardless of my opinion that Calc is not the tool to use for any kind of image management, photo album and the like).

There recently was a somehow related question under How do you select a cell and have a image highlighted and brought to the foreground?.

My answer assumes the images to either be embedded or linked to as images (not as hyperlinks) anchored to cells referencing them in one or another way by textual content inside the Calc document also containing the descriptions.

The answer was based on my judgement that the task cannot be done in Calc without resorting to user code (simple, but of limited efficiency). The limits mainly are due to the fact that “the cells don’t know what graphical objects are anchored to them”. More precisely: The API doesn’t provide access to anchored objects based on the cell objects. You need to search the DrawPage shape by shape.

Study the linked thread if interested.