Apache OpenOffice (AOO) Bugzilla – Issue 57857
linked cell property incorrectly imported for option button form control
Last modified: 2005-12-21 15:03:08 UTC
np->dr Hi you might be interested in this ;-) If you create an option button ( form control ) in xl, change it's properties to set it's linked cell, then subsequently create a number of other option buttons, the imported behavior in calc is quite different from xl. Seems there are two problems with the import 1) only the first cell has the linked cell attribute set, the other ( two option buttons e.g. in the sample doc... which I will attach ) don't have this property set. So I guess in for this, the import dosn't take into account the grouping ( implicit in this case ) 2) the value of the linked cell when the option button is set/unset is incorrect. in calc this is set to true/false, in xl it seems to be set to 1 or 0 or in the case of a an option button group. the value of the linked cell is 1 -> no. of option buttons. e.g. for a set of three option buttons see the expected values in the table below option 1 option 2 option 3 linked cell val X 0 0 1 X x 0 2 0 0 x 3
Created attachment 31463 [details] file to demonstrate issue
of course the table should look like this option 1 option 2 option 3 linked cell val x 0 0 1 0 x 0 2 0 0 x 3
There are two kinds of option buttons in Excel: - Old form controls from MSOffice 5.0/95: If linked to a cell, the cell refers to the entire group and will contain the 1-based index of the selected option button or 0, if no button is selected initially (even in a group; a single option button is just a special case of a group). - New ActiveX form controls (MS Forms 2.0): If linked to a cell, the cell will contain TRUE/FALSE for exactly one option button (not linked to the group). Anyway, the Excel filters lose grouping information for option buttons. This is already addressed in issue 30823. *** This issue has been marked as a duplicate of 30823 ***
closed