Form fields
List
boxes in Calc can either have multi-selection or not, whereas Excel
has two multi-selection modes: multi and extend. In Excel a
multi-selection listbox’s link to a cell
is ignored. In Calc the link works, but if more than one item is
selected the cell’s value is set to #N/A.
In
Calc each option button has its own link to a cell, setting its value
to true or false depending on whether the option is selected. In
Excel the cell link returns the number of the selected option button.
