https://bugs.documentfoundation.org/show_bug.cgi?id=161069
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #4 from Mike Kaganski <[email protected]> --- Repro using Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 24; OS: Windows 10.0 Build 22631; UI render: default; VCL: win Locale: en-GB (ru_RU); UI: en-GB Calc: CL threaded Changing the Workbook_Open macro to use "=guides.$A$3:$A$9" instead of "=guides!$A$3:$A$9", and executing it manually, fixes the Validity drop-down to list items from 2019 to 2025. To require Calc syntax in VBA-specific calls is a bug, it must take Excel-specific syntax, and convert internally. The code pointer is ScVbaValidation::Add [1], which eventually calls XSheetCondition::setFormula1 / setFormula2 UNO API, which indeed takes Calc-standard syntax. The strings must be converted prior to passing there (see e.g. ScVbaRange::setFormulaValue [2], which is used in ScVbaRange::setFormula / setFormulaR1C1 / setFormulaLocal). [1] https://opengrok.libreoffice.org/xref/core/sc/source/ui/vba/vbavalidation.cxx?r=b3a90323#233 [2] https://opengrok.libreoffice.org/xref/core/sc/source/ui/vba/vbarange.cxx?r=0cd07e1f#1677 -- You are receiving this mail because: You are the assignee for the bug.
