Hi,
Calc: is it possible to use calculated cell values in textboxes? I want to add calculated measures to drawings.
CU,
Thomas
I located an explanation. The following sequence works for me:
- Enable Form Control Toolbar (Menu: View → Toolbars → Form Controls)
- Turn on design mode (Design Mode On/Off button, 2nd button with finger icon)
- Select Text Box control and draw one. (Text Box button, 6th button with AB icon)
- Open the Context menu on the TextBox, and Select “Control…” menu (4th option, with spanner icon)
- On Properties: Text Box dialog, Switch to Tab:“Data”
- Set the linked cell value as required: ($Sheet1.$A$1 for instance)
- Change other General and Event settings, if needed.
- Group or arrange controls as needed.
- When completed turn off design mode on Form Controls Toolbar(2nd button with finger icon).
I’m on LibreOffice 3.5.2.2 (Build ID: 281b639-6baa1d3-ef66a77-d866f25-f36d45f)
As an aside, I converted my sheet from an original I created in Excel. I think my control type was originally a Label (which Excel let me reference it’s text from a cell value), not a TextBox. So I changed the control type first.
Credit where it’s due: the solution from this old OpenOffice thread from 2008 gave me the core details:
http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=2434
Cheers,
Paul
Hi Thomas!
I have the same question. Did you find a way to do this?
Cheers,
Paul