On 31/12/2008, Johnny Rosenberg wrote:
View | Toolbars | Form controls
Design mode on
Draw a couple of Option buttons.
I tried this with two different versions of
OpenOffice.org, with different kinds of failureĀ
Version a: 3.0.0 OOOO300m7 (Build:9354), OS=Mandriva Linux Free 2009.0
Version b: 3.0.0 OOO300m9 (Build:9358), OS=Ubuntu 8.10
First version a:
Create an option button, place it in a cell.
Copy it to a couple of more cells in one row and
then copy all of them to cells in another row.
Right click a option button, select ControlĀ
Edit some fields, like the Linked cell field in
the Data tab and some fields in the General field.
There is a field called Group name. Make sure
the option buttons in the same row has the same
Group name, for example 1. Then set the Group name to 2 for the other row.
If you don't do this, only ONE option button can
be selected. What you probably want to do is to
select one button for EACH ROW, right? That's
probably what the Group names are for, at least it seems to work that way.
When you verified that this actually works, save
the spreadsheet. Then shut down OpenOffice.org
and then open the spreadsheet again. What
happened to the Group names? In my case they
disappeared, which made my spreadsheet unusable!
And I had a LOT of option buttons on it! 8 rows,
five in each row. I certainly don't want to redo
that job each time I open the spreadsheet.
Now version b:
When I try to do the same thing on my Ubuntu
machine, OpenOffice.org 3.0.0 installed from the
OpenOffice.org official web site, not from the
repositories, the Group name option is MISSING!
So how am I supposed to be able to use option buttons at all then?
Maybe I just missed something important, that's
why I write to the list before writing a bug report.
So, to make this a question:
How can I create a couple of rows with a few
option buttons on each row, letting me select
ONE option PER ROW? Not only one option per spreadsheet.
I'm using 3.0.0 for Windows XP. As in your
version b, I see no "Group name" option in the
Properties panel for an individual option
button. So I also cannot do what you need this way.
At 11:29 01/01/2009 +0100, Johnny Rosenberg wrote:
Seems like no one is interested in trying this,
so I will attach an example file to this thread.
Open it with OpenOffice.org 3 (or any version I
guess, it seems like OpenOffice.org 2 has the
same bug or lacking of feature) and try to
answer the three silly questions in the file by
clicking the option buttons. If you can make
this simple test work, please tell me how you
did it. Especially if it still works after
saving the file, ending OpenOffice.org and then opening the file again.
As you suggest, your example file opened for me
with all nine option buttons mutually exclusive:
behaving as if they were in a single group,
though Calc didn't appear to see them as such.
I really want this to work, so if anyone can
tell me how to do it (if I missed something), I would highly appreciate it.
In my version, it appears that you have to group
the items explicitly first, before giving the
group a name. And I think you may have to give
one group a name before grouping others, in order
not to attach the new controls to the existing
group. I'm *not* an expert in these matters, but here's what I found works:
o Create the separate controls.
o In Design Mode, click and shift-click the
controls in a group to select them together.
o Right-click the group and go to Group > Group.
o Right-click again and go to Control...
. (This panel looks like the panel for an
individual control but is actually for the group.)
o Enter your desired name at General | Name.
o Repeat for other groups.
You can alternatively access the Group function
at Format | Group > Group. And there are buttons
for Group and similar functions on the Form
Design toolbar, but they appear not to be visible by default.
(I'm sending you a modified version of your example file privately.)
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
