Public bug reported:
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)
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug focal
** Summary changed:
- COUNTIF function does not work using regex as described in
+ COUNTIF(S) functions do not work using regex
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2069786
Title:
COUNTIF(S) functions do not work using regex
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/2069786/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
