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 OOO300m7 (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. Thanks Johnny Rosenberg
