[Libreoffice-bugs] [Bug 130247] New: 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

            Bug ID: 130247
           Summary: Excel workbook with multiple worksheets changes sheet
                    reference in form control when importing to
                    LibreOffice Calc.
           Product: LibreOffice
           Version: 6.2.8.2 release
          Hardware: PowerPC
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: wbgp at groupwillis.com

Description:
Form control references created in a multiple worksheet MS Excel workbook are
imported incorrectly by Calc. Sheet references are changed in the Input Range
and Cell Link fields of the Format Control for a Combo Box.

Steps to Reproduce:
1.  0pen a new workbook in MS Excel
2.  add a second worksheet - it will be automatically named Sheet 2
3.  on Sheet 2, create a table of values to populate a dropdown menu
4.  select Developer tab in the ribbon
5.  select Combo Box
6.  draw a rectangle to create a Combo Box anywhere on Sheet 2
7.  right-click on newly created Combo Box
8.  select Format Control from context menu
9.  click on Input Range field
10. highlight table of values created in step 3
11. click on Cell Link field
12. click on any unused cell in Sheet 2
13. click OK
14. click on any unused cell in Sheet 2
15. save, name and close the Excel workbook
16. open workbook in MS Excel
17. if not already visible, navigate to Sheet 2
18. click on Combo Box
19. select an option from the dropdown menu
20. result - values entered in step 3 are displayed, and selection is shown in
cell designated in step 12
21. close the Excel workbook without saving changes
22. open workbook in LibreOffice Calc
23. if not already visible, navigate to Sheet 2
24. click on Combo Box to select an option from the dropdown menu
25. result - no data is displayed in dropdown menu
26. expected result - data from table of values created in step 3 should be
displayed
27. right-click on Sheet 1 tab
28. select Delete Sheet option from context menu
29. click Yes when asked to confirm deletion
30. Sheet 2 is now the only active worksheet
31. click on Combo Box
32. select an option from the dropdown menu
33. result - item is selected as expected, and selection is shown in cell
selected in step 12
34. close workbook without saving changes
35. open workbook in LibreOffice Calc
36. if not already visible, navigate to Sheet 2
37. display the Form Design Toolbar - View > Toolbars > Form Design
38. activate Design Mode by clicking on edit tool in the Form Design toolbar
39. right-click on Combo Box to display Properties dialog box
40. select Data tab in Properties dialog box
41. view Linked Cell field
42. result - shows Sheet1.[cell designated in step 12]
43. expected result - should show Sheet2.[cell designated in step 12]
44. view Source Cell Range field
45. result - shows Sheet1.[cell range designated in step 3]
46. expected result - should show Sheet2.[cell range designated in step 3]

Actual Results:
see actual results described in steps 25, 42 and 45

Expected Results:
see expected results described in steps 26, 43 and 46


Reproducible: Always


User Profile Reset: Yes



Additional Info:
there are no relevant LibreOffice help references

-- 
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/20200128/a3978b5b/attachment.htm>