I have the VBA macros with 'For Each' statements, perfectly working in LO 6.4 and earlier versions. But when I upgraded LO to 7.0.3 I've found, that this macros gives an error: "Inadmissible value or data type. Data type mismatch.". I've tried an example from LO help (https://help.libreoffice.org/7.0/en-US/text/sbasic/shared/03090202.html?DbPAR=BASIC#bm_id3149205): Sub list_iteration cutlery = Array("fork", "knife", "spoon") For Each item in cutlery Print item Next ' item End Sub I't doesn't work and gives me exactly the same error. I've also tried LO unit test (https://git.libreoffice.org/core/+/0444fbe7515501a7997516e05329e2b2fda00dd3/core/basic/qa/basic_coverage/test_For_loops.vb): Function doUnitTest Dim s1 As Integer, s2 As Integer, value As Integer ' FOR EACH numbers = Array(3,4,5,6,7,8,9,10,11) For Each value in numbers s1 = s1 + value Next value ' FOR .. TO .. STEP .. For value = 5 To 21 Step 3 s2 = s2 + value Next value If s1<>9*7 Or s2<>3*25 Then doUnitTest = 0 Else doUnitTest = 1 'Ok End If End Function It also produces the same error. I've checked this problem in Linux under Debian Buster: Distributor ID: Debian Description: Debian GNU/Linux 10 (buster) Release: 10 Codename: buster and using LO win64 build under Windows 10 x86-64 - errors are the same.
I cannot reproduce with Version: 7.1.0.0.alpha0+ Build ID: 6ad2f463784a24c566477cdd60ae729651bb8564 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Please can you test in dev version? Thank you http://dev-builds.libreoffice.org/daily/master/
I've checked latest dev version: Version: 7.1.0.0.alpha0+ Build ID: <buildversion> CPU threads: 4; OS: Linux 5.6; UI render: default; VCL: kf5 Locale: ru-RU (ru_RU.UTF-8); UI: ru-RU TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2020-08-11_15:13:29 Calc: threaded Both provided test scripts work without errors. My original ods file with 'for each' macros also works fine. I've double checked my LO 7.0 installation: Version: 7.0.0.3 Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e Потоков ЦП: 4; ОС: Linux 5.6; Отрисовка ИП: по умолчанию; VCL: kf5 Locale: ru-RU (ru_RU.UTF-8); ИП: ru-RU Calc: threaded LO 7.0 in safe mode gives the same error.
[Automated Action] NeedInfo-To-Unconfirmed
Thanks for the test. Closing the bug.