| View previous topic :: View next topic |
| Author |
Message |
djenkins99
Newbie
Joined: 09 Feb 2011
Posts: 3
|
 Posted: Wed Feb 09, 2011 3:01 am Post subject: Adding checkbox cell |
 |
|
Dear Calc experts,
I'm new to Calc and would like to create a spreadsheet that contains several columns represented by a checkbox in each cell. (I'm the race directory for a cross-country ski club and want to use Calc to record which of 3 events the racers register for. They can register for more than one event.) I have the Form Controls toolbar visible; in it is a checkbox. I left-click the checkbox in Form Controls; the cursor changes to a plus sign and a small rectangle. I then move the cursor so that it is over the cell I want the checkbox to appear in and left click--but no checkbox. What am I doing wrong? Any help would be greatly appreciated. (I'm using OpenOffice 3.2 on Ubuntu Linux 10.04) |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
djenkins99
Newbie
Joined: 09 Feb 2011
Posts: 3
|
| Posted: Wed Feb 09, 2011 3:46 am Post subject: |
|
|
Thank you for the reply! I did not even have OO Base installed; now I do! and I see the check boxes in your example.
I gather from your answer that check boxes in Calc cells are not possible. Is that correct?
I will read up on Base before asking any more embarrassing questions! |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed Feb 09, 2011 4:41 am Post subject: |
|
|
You can draw one checkbox from toolbar "Form Controls" and bind it to one cell. The checkbox may utilized to influence one parameter of a calculation model. Alternative: =IF(A1) returns TRUE when "something with a value" is in A1, FALSE otherwise.
Nowadays hardly anybody uses a spreadsheet for the calculation modeling it has been designed 30 years ago. Virtually everybody tries to organize data in it which will certainly fail at some point.
A spreadsheet has no records. Even tables are an unknown concept. There is just a playground of atomic cells, each one with exactly the same capabilities. A table is the rectangle of cells you are refering to.
If you want to keep flat unrelated lists without cross references to other lists you may be better off with a dBase table which supports some fields with distinct types, such as booleans.
http://www.oooforum.org/forum/viewtopic.phtml?t=113530
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org
Last edited by Villeroy on Thu Feb 10, 2011 1:35 am; edited 1 time in total |
|
| Back to top |
|
|
djenkins99
Newbie
Joined: 09 Feb 2011
Posts: 3
|
| Posted: Thu Feb 10, 2011 1:32 am Post subject: |
|
|
| Villeroy wrote: | You can draw one checkbox from toolbar "Form Controls" and bind it to one cell. The checkbox may utilized to influence one parameter of a calculation model. Alternative: =IF(A1) returns TRUE when "something with a value" is in A1, FALSE otherwise.
Nowadays hardly anybody uses a spreadsheet for the calculation modeling it has been designed for 30 years ago. Virtually everybody tries to organize data in it which will certainly fail at some point.
A spreadsheet has no records. Even tables are an unknown concept. There is just a playground of atomic cells, each one with exactly the same capabilities. A table is the rectangle of cells you are refering to.
If you want to keep flat unrelated lists without cross references to other lists you may be better off with a dBase table which supports some fields with distinct types, such as booleans.
http://www.oooforum.org/forum/viewtopic.phtml?t=113530 |
Thank you again for the message. I did eventually figure out how to create a check box in a Calc cell: its outline (width and height) must be dragged open, similar to the way I remember creating graphic components in Visio.
You're right about spreadsheets today not being used as a calculation tool. At work spreadsheets are used for everything but making calculations (requirements, application design documents, etc.) It drives me nuts (why not use a word processor?) but that's how it is.
I am happily learning Base and will use it instead for my project. Thank you for putting me on the right track. |
|
| Back to top |
|
|
|
