On Thursday 03 January 2008 07:30:36 Harold Fuchs wrote:
> On 31/12/2007, [EMAIL PROTECTED] <
>
> [EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > In Calc, is there a way to display a checkbox - checked or
> > unchecked instead of a TRUE/FALSE for a Yes/No boolean statement?
> >
> > Thanks
> >
> > *Jean-Claude Destruel*
> >
> > [EMAIL PROTECTED]
>
> The nearest to a check mark I can get is the mathematical symbol for square
> root ("√") which you can get via Insert>Special Symbol and which you could
> use in an IF function such as =IF(A1>5;"√";" ")
>
> Hopefully someone else can do better ...
Open the Form Controls toolbar (View > Toolbars > Form controls). Click
the checkbox icon. Then use the cursor to draw in the checkbox in the cell or
cells where you want it or them.
VERY IMPORTANT: In order to use the checkbox or checkboxes, you must
first click the Edit file icon in the Standard toolbar to make the
spreadsheet "Read-only". (It should be just to the right of the Save icon.)
The checkboxes will only change from unchecked to checked or vise versa for
a "Read-only" spreadsheet in my experience.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
