https://bugs.freedesktop.org/show_bug.cgi?id=64436
Priority: medium
Bug ID: 64436
CC: [email protected]
Assignee: [email protected]
Summary: FILEOPEN MSOffice document import List/ComboBox does
not track boundcolumn vs display column correctly
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 79104
--> https://bugs.freedesktop.org/attachment.cgi?id=79104&action=edit
application/vnd.ms-excel
Consider the attached Microsoft Excel file.
In Excel, the ListBox displays a choice between
one
two
three
four
etc
but stores in the linked cell (that is, D4) values
1
2
3
4
etc
Open this file in LibreOffice.
The ListBox displays one of
1
2
3
4
etc
This Excel ComboBox should be imported as a LibreOffice ListBox. Because it has
property "MatchRequired" to True. Here are the translation rules:
MSO ComboBox ----> LibO control with property "dropdown" set to true
MSO ListBox ----> LibO control with property "dropdown" set to false
MSO Control with property "MatchRequired" set to true ----> LibO ListBox
MSO Control with property "MatchRequired" set to false ----> LibO ComboBox
Now, a LibO Base Form ListBox (that is, a data-aware ListBox?) has a property
"BoundColumn" which more-or-less mirrors (with an offset of one) the MSOffice
Combo/ListBox property "BoundColumn". But It seems a LibO Calc ListBox has this
greyed out (?).
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
