Page 1 of 1
Show Cell result in Text Box in Spreadsheet
Posted: Thu Feb 07, 2008 5:10 pm
by dadclaude
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
Re: Show Cell result in Text Box in Spreadsheet
Posted: Thu Feb 07, 2008 5:28 pm
by Villeroy
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)
Re: Show Cell result in Text Box in Spreadsheet
Posted: Fri Feb 08, 2008 12:35 am
by dadclaude
Excellent - many thanks it works well!
Re: Show Cell result in Text Box in Spreadsheet
Posted: Fri Feb 08, 2008 6:07 am
by acknak
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.