COUNTIF(S) functions do not work using regex

[Nathan Pennie]

See https://help.libreoffice.org/6.4/en-US/text/scalc/01/func_countifs.html?&DbPAR=WRITER&System=UNIX

The following examples from that link will never produce a nonzero result, but they should when used with the provided spreadsheet:
=COUNTIFS(B2:B6;"[:alpha:]*")
=COUNTIFS(A2:A6;"pen.*";B2:B6;"<"&MAX(B2:B6))

See the example spreadsheet (attached)

ProblemType: Bug
DistroRelease: Ubuntu 20.04
Package: libreoffice-calc 1:6.4.7-0ubuntu0.20.04.10
ProcVersionSignature: Ubuntu 5.15.0-107.117~20.04.1-generic 5.15.149
Uname: Linux 5.15.0-107-generic x86_64
ApportVersion: 2.20.11-0ubuntu27.27
Architecture: amd64
CasperMD5CheckResult: skip
CurrentDesktop: ubuntu:GNOME
Date: Tue Jun 18 16:08:49 2024
InstallationDate: Installed on 2021-10-24 (968 days ago)
InstallationMedia: Ubuntu 20.04.3 LTS "Focal Fossa" - Release amd64 (20210819)
ProcEnviron:
 TERM=xterm-256color
 PATH=(custom, no user)
 XDG_RUNTIME_DIR=<set>
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)