Bug 153834 - Support dynamically linked cell contents inside objects with “=” formula
Summary: Support dynamically linked cell contents inside objects with “=” formula
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Shapes
  Show dependency treegraph
Reported: 2023-02-25 21:42 UTC by Palongo
Modified: 2023-03-25 07:38 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Example XLSX created in MX Excel (10.13 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-03-25 07:38 UTC, Stéphane Guillou (stragu)

Note You need to log in before you can comment on or make changes to this bug.
Description Palongo 2023-02-25 21:42:13 UTC Comment hidden (obsolete)
Comment 1 Stéphane Guillou (stragu) 2023-03-22 22:49:11 UTC Comment hidden (obsolete)
Comment 2 Palongo 2023-03-23 09:31:56 UTC
Description: Add the “=” function so that a text box can receive data from a cell on the same spreadsheet as the object or not. This means that an object drawn in Calc (in particular a text box) can receive “TEXT” data using the formula bar by inserting the “=” sign into the object. This is very useful for designing a dynamic and interactive dashboard on Calc. After a dynamic cross analysis.

Steps to Reproduce:

Insert a Pivot Table into a new sheet, perform an analysis and insert diagrams.
Design your dashboard space by inserting drawing objects and text boxes to receive the results of the analysis.
Copy the Pivot Table diagrams into your dashboard space. But for now, we cannot retrieve data from the Pivot Table to insert it into a text box in the dashboard. And that’s what I would like to do.
Actual Results: A text box cannot receive a formula or “=” function

Expected Results: I would like a text box to be able to receive data using the formula bar by using the “=” sign. This is very useful for designing a dynamic and interactive dashboard on Calc.

Reproducible: Couldn’t Reproduce

User Profile Reset: No

Additional Info: This feature allows you to create a dynamic and interactive dashboard.
Comment 3 Stéphane Guillou (stragu) 2023-03-23 10:52:58 UTC
This is already possible with Insert > Form Control > Text box. You can then go into right-click > Control Properties > Data, and link the cell you want the data fram.
Thank you!
Comment 4 Palongo 2023-03-24 18:54:48 UTC
Yes, thank you very much, it worked, I just tested it. But in terms of formatting, it’s still limited, we can’t make the background of the text box transparent, and we can’t round the corner or border of the text box yet. But thank you very much.
Comment 5 Stéphane Guillou (stragu) 2023-03-25 07:36:57 UTC
It's true that it's not as flexible.

I realised that MS Excel does offer that option: https://support.microsoft.com/en-us/office/dynamically-display-the-contents-of-a-cell-or-range-in-a-graphic-object-e2e7a629-5662-42d6-9295-06d112c2099f

And we should support that kind of content for interoperability. Currently, importing it into Calc results in static text.

I'm surprised I couldn't find a duplicate.
Comment 6 Stéphane Guillou (stragu) 2023-03-25 07:38:10 UTC
Created attachment 186202 [details]
Example XLSX created in MX Excel

File contains two shapes with dynamic content linked to cells. Importing into Calc breaks the link and results in static text.