Description: Function EXPREG don't treat escape dot character correctly in regex. Steps to Reproduce: 1. Put a cell the value 0.9999 2. In another cell use this formula escaping dot: EXPREG(cell;"[0-9]+(\.[0-9]+)?") Expected Results: 0.9999 Reproducible: Always User Profile Reset: No Additional Info: If take out the metacharacter to scape and use only dot it is works.
Please what is your decimal separator '.' or ',' Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Created attachment 194232 [details] sample Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: pt-BR (pt_BR.UTF-8); UI: pt-BR Flatpak Calc: threaded
My decimal separator is ','.
Created attachment 194233 [details] sample 2 I created other spreadsheet and the bug not appear.
[Automated Action] NeedInfo-To-Unconfirmed
REGEX() is a _text_ function. When you convert (by any of several ways) a numeric value into a text value, you can define whichever "fake decimal separator" you want. With that converted-to-text value, you can use REGEX(). This is not a bug.
(In reply to aldrinpdscastro from comment #3) > My decimal separator is ','. The search for '\,' instead '\.', when there is a number in the cell, not a text as number.