[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 #3 from Alex Thurgood <iplaw67 at tuta.io> ---
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.

-- 
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/20200129/96ec4832/attachment.htm>