Description: Sub list_iteration Dim item For Each item in Array(0) Next End Sub Runtime Error: "Inadmissible value or data type. Data type mismatch." Steps to Reproduce: Run the Macro above Actual Results: Runtime error Expected Results: No error Reproducible: Always User Profile Reset: No Additional Info: There was no bug in versions prior to 7.x
it's a regression as was wrote here https://forumooo.ru/index.php/topic,7953.30/msg,55434.html
Regression introduced by: https://cgit.freedesktop.org/libreoffice/core/commit/?id=5760c94b8847164f9a7a181f031c7c86643944af author Mike Kaganski <mike.kaganski@collabora.com> 2020-07-10 19:06:10 +0300 committer Mike Kaganski <mike.kaganski@collabora.com> 2020-07-10 20:05:25 +0200 commit 5760c94b8847164f9a7a181f031c7c86643944af (patch) tree eec33567fa521f17a8431508791b2375063ccefe parent 2490559b6cddb0815808055dc7f32c733a48c44b (diff) tdf#134576: proper handling of For/For Each with On Error Resume Next Bisected with: bibisect-linux64-7.1 Adding Cc: to Mike Kaganski
https://gerrit.libreoffice.org/c/core/+/100258
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e67ffd5a62c8c27697da594a0fea2362317f221f tdf#135470: Fix checks It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 7.1.0.0.alpha0+ Build ID: 6ad2f463784a24c566477cdd60ae729651bb8564 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded @Mike Kaganski, thanks for fixing this issue!!
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/82ab191a074141aafa7567fc3c3cad9bc7ea0b24 tdf#135470: Fix checks It will be available in 7.0.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 136367 has been marked as a duplicate of this bug. ***
I can confirm that the bug is fixed in LO 7.0.1.2 (tested on Linux Ubuntu 20.4.1). Thanks!