Bug 100374

Summary: FILEOPEN: XLSX - Form imported with wrong setting for a list box
Product: LibreOffice Reporter: Tobias Burnus <tobias.burnus>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: dgbates2, ilmari.lauhakangas, kelemeng, libreoffice, raal
Priority: medium Keywords: filter:ooxml, filter:xlsx
Version: 5.1.2.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 107742, 133999    
Attachments: xlsx file on which it is possible to reproduce 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
Version: 5.3.0.0.alpha0+
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: 7.3.0.0.alpha0+ (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: 7.6.0.0.alpha0+ (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