Consider this BASIC code: Option VBASupport 1 Sub Test_IsNumeric() MsgBox IsNumeric(True) End Sub This code must show "True", because that's what VBA does. Currently, this gives "False" in LibreOffice. A different question is, if maybe it should also give "True" in LibreOffice *without* VBASupport; but that needs an own bug, and considered separately, because that is potentially a breaking change.
I confirmed it gives false Version: 25.2.0.1 (X86_64) / LibreOffice Community Build ID: ddb2a7ea3a8857aae619555f1a8743e430e146c9 CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
https://gerrit.libreoffice.org/c/core/+/179866
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b76d70338258811bb0ca516d01c6cfe7a222ca76 tdf#164600: Return true from IsNumeric for booleans in VBASupport mode It will be available in 25.8.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.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-25-2": https://git.libreoffice.org/core/commit/8f41d6650f4d11fafc4e50c75d75df34dbd07a40 tdf#164600: Return true from IsNumeric for booleans in VBASupport mode It will be available in 25.2.0.2. 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.