Show Cell result in Text Box in Spreadsheet

Discuss the spreadsheet application

Show Cell result in Text Box in Spreadsheet

Postby dadclaude » Thu Feb 07, 2008 5:10 pm

I have a sketch of a beam in a spreadsheet, in the Excel version I have a text boxes on the sketch to show the beam dimensions which are entered in a table. This function does not seem to work in openoffice spreadsheet. In Excel I just select the text box and then copy the relevant cell reference into the formula bar. The sketch drawing then shows the dimensions used for the calculation.
Any ideas?
Thanks
dadclaude
 
Posts: 4
Joined: Thu Feb 07, 2008 5:00 pm

Re: Show Cell result in Text Box in Spreadsheet

Postby Villeroy » Thu Feb 07, 2008 5:28 pm

View>Toolbars>Form Controls
Turn on design mode (button #2)
Pick a text box and draw it. (cancel the database wizard when it pops up)
Context menu: "Control...", tab:"Data", linked cell: $Sheet1.$A$1 for instance
Select your other drawing object together with the new text box and group them, so you can move them around as one object.
Turn off design mode (button #2)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26852
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Show Cell result in Text Box in Spreadsheet

Postby dadclaude » Fri Feb 08, 2008 12:35 am

Excellent - many thanks it works well! :D
dadclaude
 
Posts: 4
Joined: Thu Feb 07, 2008 5:00 pm

Re: Show Cell result in Text Box in Spreadsheet

Postby acknak » Fri Feb 08, 2008 6:07 am

Wow--what an amazing workaround. I would never have thought of that. Nice one, Villeroy!

However, this seems a long way from being able to display cell results in a graphic--which would be a very nice feature.

E.g., be aware that the text box form control is actually an input field: if the user clicks on the control, he can enter a value, which will replace the contents of the cell containing the result! You may want to set the form control to read-only.

PS: Here is the request for this feature: Issue 71994: Calc, no support for formulas in textboxes. You can register and add a comment or vote for the request.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: No registered users and 16 guests