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)
Version:
(earliest affected)
5.1.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:ooxml, filter:xlsx
Depends on:
Blocks: Form-Controls XLSX-Form-Controls
  Show dependency treegraph
 
Reported: 2016-06-14 15:43 UTC by Tobias Burnus
Modified: 2021-07-26 10:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
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
Details

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
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