Version: 24.8.0.3 (X86_64) / LibreOffice Community
Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583
CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: threaded
Why is the “s” in Joey’s capitalised and how do I stop it?
Maybe for the same reason as O'Brien would be?
Same behaviour in
Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 480(Build:1)
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: x11
Locale: en-AU (wbp_AU.UTF-8); UI: en-US
SlackBuild for 24.8.2 by Eric Hameleers
Calc: threaded
You may wish to add a comment to tdf#53146 I note the bug report indicates that this behaviour is also found in Excel and Gnumeric.
Hallo
=REGEX(PROPER(D7);"S\b";"s" )
=REGEX(PROPER(D7);"[’'`´]S\b";"’s" ) # better
Thanks for the suggestion karolus. Will I need to do this multiple times for other letters. e.g T in Ain’t, L in I’ll or is there a way of lowering the case of whatever letter comes after the apostrophe?