2009/1/1 Brian Barker <[email protected]> > 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.
Thank you for solving my problem and for the example file you sent me off list. It works great, and I also found that it's even easier than you described. It seems to be the Name itself that is the key! I didn't have to group anything, as long as I used the same name for those buttons on the same line it worked! So the Group Name field in the OOo300m7 version isn't needed, at least not for this purpose. Maybe that's why they removed it for 300m9, I don't know. Your step by step instruction can obviously be shortened a bit, like this: o Create the separate controls. o In Design Mode, click and shift-click the controls in a group to select them together (or use the Select tool at View → Toolbars… → Format controls). o Right-click again and go to Control… (this panel looks like the panel for an individual control but is actually for all the selected controls). o Enter your desired name at General | Name. o Repeat for other multi selected controls. If you don't close the control dialogue, you don't need the third step from now on. Well, it's just about the same as your steps, but the group step doesn't seem to be needed, as I mentioned earlier. I noticed this by studying your file. After ungrouping, it still worked the same way as when they were grouped. Even when I grouped everything it still worked the same way, so I figured that the group thing doesn't matter. Then I opened my old file and just changed the names of the controls so every control of the same line had the same name, but different from other lines, and this also worked. By the way, you answered one of my silly questions wrong: The Beatles "Rubber Soul" album <http://en.wikipedia.org/wiki/Rubber_Soul> was released 1965-12-03 (which is the only release date of any album I remember by heart… and I wasn't even born then…). Thanks again, and I will not write a bug report about this, since it seems to work perfectly. Maybe it wasn't very intuitive (since I couldn't figure it out immediately), but it works. Johnny Rosenberg > > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
