XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Picture Links

Revision as of 08:49, 3 September 2019 by CFrance (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Version 7.5 added support for Picture Links. These are pictures that can be inserted into a workbook that provide the same functionality as the XL3Link formula.


To insert a picture link, go to Insert Formula -> XL3PictureLink.


Picture file to insert

Select the image to display in the picture link. You can search from the provided icon set, or load or paste your own image.

Link To

Select the destination cell for where the user will be taken when the image is clicked on (this can be the same sheet if the picture link is controlling something on this sheet or a different sheet to allow report navigation)

Perform a "Submit Changes" on Web

With this enabled and the report has been published, any writable cells or "Delayed Slicers" will be submitted when the picture is clicked on, it acts the same as the "Submit" toolbar button on the web

Cells to update

You can provide a list of cells to update with either a value or the contents of another cell. This can be used to drive a selection or copy ranges of values between worksheets or cells on the same sheet.

Toolbar buttons

From Version 9.1 you can use a picture to trigger toolbar buttons. To do this the picture must link to a cell with the trigger text XL3Toolbar:ButtonName, for example:



To edit an existing Picture Link, hold the "Shift" key when clicking and the standard Picture Link form will be displayed

Linking to a web report

To link to another web report from a picture link, first write an an XL3WebReportLink that doesn’t have a ‘link text’ value, e.g. =XL3WebReportLink("/Testing/Book2.wbsql", , 0).

The picture link then needs to link to the cell containing this formula and select the option ‘Use address from link to cell’.


Using Camera Objects

To use a camera object as the source for an image, first insert the Picture Link selecting a temporary picture. Then right-click on the picture to highlight it and then type the source range for the image in the formula bar, i.e. Sheet2!a1:f10 would change the picture link to show the contents of the range, it can then resized and re-positioned as required.

See Also