Ask Your Question

Reference Cell values in TextBox [closed]

asked 2012-09-14 08:49:31 +0100

molle gravatar image

Hi, Calc: is it possible to use calculated cell values in textboxes? I want to add calculated measures to drawings.

CU, Thomas

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 13:42:20.579893

2 Answers

Sort by » oldest newest most voted

answered 2012-12-14 02:52:27 +0100

paulzee gravatar image

I located an explanation. The following sequence works for me:

  1. Enable Form Control Toolbar (Menu: View -> Toolbars -> Form Controls)
  2. Turn on design mode (Design Mode On/Off button, 2nd button with finger icon)
  3. Select Text Box control and draw one. (Text Box button, 6th button with AB icon)
  4. Open the Context menu on the TextBox, and Select "Control..." menu (4th option, with spanner icon)
  5. On Properties: Text Box dialog, Switch to Tab:"Data"
  6. Set the linked cell value as required: ($Sheet1.$A$1 for instance)
  7. Change other General and Event settings, if needed.
  8. Group or arrange controls as needed.
  9. When completed turn off design mode on Form Controls Toolbar(2nd button with finger icon).

I'm on LibreOffice (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:



edit flag offensive delete link more

answered 2012-12-14 01:49:29 +0100

paulzee gravatar image

Hi Thomas!

I have the same question. Did you find a way to do this?



edit flag offensive delete link more

Question Tools


Asked: 2012-09-14 08:49:31 +0100

Seen: 2,633 times

Last updated: Dec 14 '12