[Libreoffice-bugs] [Bug 130247] Excel workbook with multiple worksheets changes sheet reference in form control when importing to LibreOffice Calc.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=130247

--- Comment #5 from Willis <wbgp at groupwillis.com> ---
(In reply to Alex Thurgood from comment #3)
> Also confirming that, with the file loaded in Calc, and Form Design mode
> activated, the control in Sheet 2 points to cell references and ranges in
> Sheet1:
> 
> Linked cell : Sheet1.D3
> Source cell range : Sheet1.B11:B16
> 
> 
> I also notice a further difference, FWIW :
> - the value displayed in the linked cell appears to be different between
> Excel and Calc. Excel displays the index number of the entry selected (so
> entry "Selected" = 1, entry 1=2, entry 2=3, etc) , whereas Calc displays the
> actual selected value from the list.

Responding to Alex's comment about different values being displayed in the
linked cell (Sheet2, D3 in the sample file). LibreOffice Calc includes a
feature that allows the linked cell to display either the selected entry, or
the numerical position of the selected entry. The default appears to display
the selected entry. 

MS Excel does not include an equivalent feature to choose what to display in
the linked cell - it displays the position of the selected entry in the linked
cell. To make the linked cell in LibreOffice Calc behave like MS Excel, do the
following:

1.  open test file in LibreOffice Calc
2.  if not already visible, navigate to Sheet 2
3.  display the Form Design Toolbar - View > Toolbars > Form Design
4.  activate Design Mode by clicking on edit tool in the Form Design toolbar
5.  right-click on Combo Box to display Properties dialog box
6.  select Data tab in Properties dialog box
7.  next to the second line 'Contents of the linked cell...' click dropdown
menu to reveal a choice between 'The selected entry' OR 'The position of the
selected entry'
8.  from the dropdown menu, select 'The position of the selected entry'
9.  deselect the edit tool in the Form Design toolbar

It would seem that compatibility when opening a document created in MS Excel
would be best served by LibreOffice Calc defaulting to displaying the position
of the selected entry in the linked cell. 

This topic seems to be a separate issue from my original bug submission. In
fact, what is displayed in a linked cell for a Combo Box might not be a bug,
but a feature request. I am a newbie - the original post is my first ever bug
submission. Any advice about how best to submit this second issue would be most
appreciated.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200217/1a53d91c/attachment-0001.htm>