Regex structures not in ICU project

[LobaLuna]

Hi, guys. I am helping in the translation to Spanish of Calc Guide 6.2

In chapter 7 about Functions and Formulas (page 244) there is a sentence like this:

«This case-insensitivity also applies to the regular expression structures ([:lower:]) and ([:upper:]), which match characters irrespective of case.»

But these structures [:lower:] and [:upper:] are not described in ICU project, which is the source for regex in Calc. Maybe I am mistaken, but I think that sentence must be go off. At least in the Spanish 6.2 (and later) version I'm planning no to include it, unless some one advice me against it.

Celia

[Steve_Fanning]

Hi Celia,

I think you are correct to delete the sentence mentioning the [:lower:] and [:upper:] character classes - these may refer to other flavours of regex (such as the IEEE POSIX standard). There is no equivalent sentence in the 7.0 Calc Guide.

For your information, the paragraph you refer to makes the point that regular expression searches within functions are always case insensitive, which at the time of LO 6.2 was true. However the behaviour is different in current versions of Calc, following the implementation of Bug 78840 <https://bugs.documentfoundation.org/show_bug.cgi?id=78840>. Now it is possible to search in functions using regular expressions in a case sensitive mode, using the appropriate flag option within the regular expression.

Regards,

Steve Fanning