https://bugs.documentfoundation.org/show_bug.cgi?id=100374
Bug ID: 100374
Summary: FILEOPEN: .xlsx form imported with wrong setting for a
list box
Product: LibreOffice
Version: 5.1.2.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Keywords: filter:ooxml, filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
There is an XLSX form import bug for list controls, where the value instead of
the position is used.
To reproduce:
1. Open the Excel form from
http://www.sailing.org/tools/documents/FirstRaceTCFCalculationofWSEHafterIRCvalidation-[20842].xlsx
2. Choose View > Toolbars -> Form Controls - and ensure that the second button
in upper row ("OK", Toggle Design Mode) is *not* set.
[Side note: It is not very intuitive to get into this mode; with Excel, one is
by default in this mode - and a right click can nonetheless be used to modify
the form control.]
3. Choose a value from the lists on the left.
EXPECTED: The values in column "L" change to 1...5 and a value shows up in the
red box.
ACTUAL: The L column contains "1 = ..." values and the red box remains
unchanged.
SOLUTION (as a user, it should happen automatically): Go into the Design Mode
(toggle the Form Control "OK" button), click on each list box widget and then:
a) Right click and choose Control
b) In the "Properties: List Box" window, go to the "Data" tab
c) Choose in "Content of the linked cell:" the value "Position of the selected
entry". The value when imported was "The selected entry".
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
