https://bugs.documentfoundation.org/show_bug.cgi?id=161069
Bug ID: 161069
Summary: The script for adding a drop-down list to cells does
not work correctly
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Description:
The file "test_add_list.xlsm" has a script for the Workbook_Open event, which,
when opening the file, re-binds the drop-down list to the column cells (through
data validation).
The lists are linked with the usual VBA code.
The problem is that, for reasons I don't understand, this script works
correctly in Excel, and in Calc it works without errors, but the necessary
directory is not linked. (screenshot)
There are no problems when opening in Calc a file with an already linked list.
If I save a file in which the script worked incorrectly, and then try to open
it again, as in Excel and Calc, the file opens with errors, and the
Workbook_open script does not work completely.
If I understood correctly, then the whole difficulty is that Calc addresses
other sheets in a different way.
in Excel = guides!$A$3:$A$9
in Calc = $guides.$A$3:$A$9
Steps to Reproduce:
1. Open a file containing the workbook_open script that adds lists to cells.
2. Allow macros to be executed.
3. We get an incorrect result.
Actual Results:
We get an incorrect result (on screenshot).
Expected Results:
The lists must be added correctly in accordance with the VBA code.
Reproducible: Always
User Profile Reset: No
Additional Info:
The presence of this problem has been tested on LibreOffice version 7.6.4.1, on
Windows 10/11 and Linux Mint 21.3 operating systems.
Resetting the user profile settings was not applied.
--
You are receiving this mail because:
You are the assignee for the bug.
