How do I make a text box?

Discuss the spreadsheet application

How do I make a text box?

Postby bobbee25 » Sat Jul 25, 2020 4:37 am

 Edit: Split from [Solved] Lost the input window for the cell data 
That was it, thanks.

How do you make a text box ?
Last edited by MrProgrammer on Sun Jul 26, 2020 5:19 pm, edited 1 time in total.
Reason: New subject in solved topic requires new topic
openoffice 4.1.5 windows 10/64bit
bobbee25
 
Posts: 5
Joined: Sat Jul 25, 2020 12:18 am

Re: Basic Calc setup

Postby robleyd » Sat Jul 25, 2020 5:00 am

What are you trying to achieve?
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.4.6.2 (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3750
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Basic Calc setup

Postby bobbee25 » Sat Jul 25, 2020 1:25 pm

Insert text not within cells, a box of information within the spreadsheet
openoffice 4.1.5 windows 10/64bit
bobbee25
 
Posts: 5
Joined: Sat Jul 25, 2020 12:18 am

Re: Basic Calc setup

Postby keme » Sat Jul 25, 2020 1:46 pm

  • You can insert a cell comment. This will by default pop up when mouse pointer hovers over the cell, but you can set it to display always.
    Comments will not be output when you print your spreadsheet.
  • You can insert a floating frame. The frame must fetch content from external resuorce.
  • You can insert an OLE text object.
    This will be a Writer document and can use all formatting options available to Writer.
  • You can insert a text box from the drawing toolbar (the T icon). To enable the drawing toolbar, select menu item View - Toolbars - Drawing
    This is a kind of graphical object. Less options for text manipulation than with the OLE object, but the text box can be rotated freely and basic formatting may be easier to manage.

There may be other possible solutions, depending on your particular requirements.
User avatar
keme
Volunteer
 
Posts: 3401
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Basic Calc setup

Postby Villeroy » Sat Jul 25, 2020 2:30 pm

keme wrote:There may be other possible solutions, depending on your particular requirements.

Cell validation with an "input help" string about admissible cell entries.
Form controls for specialized data types text, dates, integer numbers, decimals, currencies. These may be bound to a database so the entry goes to a database table.
You can "hide" information in custom properties (File>Properties>Custom) and named values (Insert>Names>Define...)
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.4
User avatar
Villeroy
Volunteer
 
Posts: 29279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: mike.stirton and 14 guests