Bug 100374 - FILEOPEN: XLSX - Form imported with wrong setting for a list box
Summary: FILEOPEN: XLSX - Form imported with wrong setting for a list box
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:ooxml, filter:xlsx
: 103048 129861 (view as bug list)
Depends on:
Blocks: Form-Controls XLSX-Form-Controls
  Show dependency treegraph
Reported: 2016-06-14 15:43 UTC by Tobias Burnus
Modified: 2023-03-06 15:49 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

xlsx file on which it is possible to reproduce bug (19.95 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-09-29 21:17 UTC, Bartosz

Note You need to log in before you can comment on or make changes to this bug.
Description Tobias Burnus 2016-06-14 15:43:56 UTC
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".
Comment 1 Buovjaga 2016-06-18 12:21:57 UTC
Repro with document.

Arch Linux 64-bit, KDE Plasma 5
Build ID: c13f60e7cd18df6b0ab70289f5b91ee01e4ae126
CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Built on June 18th 2016
Comment 2 Bartosz 2016-09-29 21:17:26 UTC
Created attachment 127728 [details]
xlsx file on which it is possible to reproduce bug
Comment 3 QA Administrators 2018-07-03 02:39:40 UTC Comment hidden (obsolete)
Comment 4 Katka 2021-07-26 10:08:08 UTC
Still repro with:
Version: (x64) / LibreOffice Community
Build ID: cb2827f5f65324f309fa0e3c30d0b19ad237410e
CPU threads: 16; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Comment 5 Gabor Kelemen (allotropia) 2023-02-01 22:20:37 UTC
*** Bug 129861 has been marked as a duplicate of this bug. ***
Comment 6 Gabor Kelemen (allotropia) 2023-02-01 23:06:23 UTC
*** Bug 103048 has been marked as a duplicate of this bug. ***
Comment 7 raal 2023-03-06 15:49:29 UTC
Still repro with Version: (X86_64) / LibreOffice Community
Build ID: 288c0920a8475f9f2c537212e04aa7649192ad8c
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

note: https://ask.libreoffice.org/t/calc-nefunguje-zobrazeni-ovladaci-prvek-formulare/88755/4