Created attachment 161901 [details] A test case for broken parameter-type inference When a Basic function has a parameter without a specified type, its type is automatically set to variant. However, passing an integer constant as the value of such parameter makes its type integer rather than variant/integer. This is a change in LO 7.0 beta1 compared to LO 6.4 and I'm pretty sure its a bug. I'm reporting it, because it actually broke some macros I use in production. A document with a test-case macro is attached. This bug may be related to https://bugs.documentfoundation.org/show_bug.cgi?id=132563 but I don't think it's the exact same thing.
(In reply to Eltomito from comment #0) > This is a change in LO 7.0 beta1 compared to LO 6.4 and I'm pretty sure its > a bug. confirming, macro will fail with: Version: 7.1.0.0.alpha0+ (x64) Build ID: 59939d2490726336546c7ad05082d23031074e12 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded but works with: Version: 6.4.4.2 (x64) Build-ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff CPU-Threads: 4; BS: Windows 10.0 Build 18363; UI-Render: Standard; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc:
I checked the issue and it should not be related to https://bugs.documentfoundation.org/show_bug.cgi?id=132563 but I think it has to do with https://bugs.documentfoundation.org/show_bug.cgi?id=36737.
After some investigations I found the culprit: https://bugs.documentfoundation.org/show_bug.cgi?id=131296
Andreas Heinisch committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0f6e012057bf0d1cc339154e8af6586d9615a37f tdf#133913 - create variable with Variant/Type in StepLOADNC 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.
Andreas Heinisch committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/b62d73ccb04da2c4cf7f68a23742d0670ef7eb90 tdf#133913 - create variable with Variant/Type in StepLOADNC It will be available in 7.0.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.
I can confirm it's fixed in Version: 7.1.0.0.alpha0+ Build ID: a3c8ea5e644ca2fc04de9f01ba9f8ace47f520f0 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2020-06-17_02:21:20 Calc: threaded