https://bugs.documentfoundation.org/show_bug.cgi?id=147822
--- Comment #7 from [email protected] --- Quoting a message from 2005-11-14 ( https://bz.apache.org/ooo/show_bug.cgi?id=57857#c3 ) : > 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 > https://bz.apache.org/ooo/show_bug.cgi?id=30823 . >From my point of view "loosing grouping information" for "option buttons" = "single choice radio buttons" = "xor-choice buttons" while saving to Excel-file-formates is true for LibreOffice (and OpenOffice) with current versions in year 2022. And if you open a xls, xlsx created with MS Excel containing grouped or ungrouped single choice radio buttons with LibreOffice Calc, change some choice and store it again, than in Excel and LibreOffice the choose-logic is broken (grouping information was lost while saving). -- You are receiving this mail because: You are the assignee for the bug.
