Download it now!
Bug 79542 - FORMCONTROLS: .xls - Option buttons contained in group boxes are not grouped.
Summary: FORMCONTROLS: .xls - Option buttons contained in group boxes are not grouped.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Form-Controls XLS
  Show dependency treegraph
Reported: 2014-06-02 11:32 UTC by Marco Borra
Modified: 2019-10-04 03:05 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Sample Document (36.50 KB, application/
2014-06-02 11:32 UTC, Marco Borra
LibreOffice 4.3beta1 Behavoir (Ubuntu 14.04 LTS) (67.88 KB, image/png)
2014-06-02 11:34 UTC, Marco Borra
Microsoft Office 2003 Behavoir (34.74 KB, image/png)
2014-06-02 11:35 UTC, Marco Borra
screenshot from 5.0 (76.76 KB, image/png)
2015-06-10 06:31 UTC, Yousuf Philips (jay) (retired)

Note You need to log in before you can comment on or make changes to this bug.
Description Marco Borra 2014-06-02 11:32:43 UTC
Created attachment 100290 [details]
Sample Document

Option buttons contained in a group box should be grouped.
Option buttons contained in different group boxes must belong to independant groups.
1 - Open sample file with both MS Office and LO. The document contains three groups of option buttons.
2 - In MS Office, the option buttons in each group can be selected independently.
3 - In LO, The selection is mutually exclusive as if they belonged to a single group. When you select one of them the others are deselected. 

Current behavior:
Option buttons must be considered in separated groups if they are contained in distinguished group boxes.

Expected behavior:
All option buttons in the sheet are treated as a single group.

Operating System: All
Version: All from 3.6.x to release.

Operating System: All
Comment 1 Marco Borra 2014-06-02 11:34:26 UTC
Created attachment 100291 [details]
LibreOffice 4.3beta1 Behavoir (Ubuntu 14.04 LTS)
Comment 2 Marco Borra 2014-06-02 11:35:12 UTC
Created attachment 100293 [details]
Microsoft Office 2003 Behavoir
Comment 3 Yousuf Philips (jay) (retired) 2014-06-04 19:04:51 UTC
Confirmed on Windows and Linux Mint on 3.6.7, 4.2.4, and 4.3 beta.
Comment 4 QA Administrators 2015-06-08 14:42:50 UTC Comment hidden (obsolete)
Comment 5 Yousuf Philips (jay) (retired) 2015-06-10 06:31:42 UTC
Created attachment 116434 [details]
screenshot from 5.0

Still doesnt look like the excel output.

Build ID: 587006cac508616f486aea45e265a170bcccdc87
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-06-06_00:16:39
Comment 6 QA Administrators 2016-09-20 10:01:59 UTC Comment hidden (obsolete, spam)
Comment 7 Justin L 2018-10-03 18:10:10 UTC
XLSX has the same problem. That one should be solved by the patch proposed in bug 111980 comment 8. Since the code is very different, that link probably isn't too helpful, but perhaps it will give some inspiration.
Comment 8 QA Administrators 2019-10-04 03:05:51 UTC Comment hidden (spam)