Problem description: In calc, German language, it is not possible to change an input like 16,,30 to 16:30 via Autocorrection, because a double comma will only be replaced, if headed and followed by a blank. In standard orthografic control it can be switched after input. In MS Office this works fine. The input is neccessary for typing lots of start and end times without recalculating in decimal or changing position on Keyboard. Can there be made a refinement? Steps to reproduce: 1. German keyboard (comma between 0 and ENTER) in numeric block 2. in Calc or writer: Autocorrection: replace ,, by : 3. type 16,,30 4. for control: type 16[BLANK],,[BLANK]30 Current behavior: output: 16,,30 Expected behavior: output 16:30 Operating System: openSUSE Version: 4.1.6.2 release
Hi Diomedea, if you upgrade to LibO 4.2.5.2 you can use the new "wildcard autocorrection" feature to obtain what you are looking for. see LibO 4.2 release notes at this link https://wiki.documentfoundation.org/ReleaseNotes/4.2 and go at the end of Writer section. what you have to do is to set 24 autocorrection wildcard entries about time followed by double comma... click on "Tools/Autocorrect Options/Replace" and start entering: 00,,.* --> 00: 01,,.* --> 01: 02,,.* --> 02: 03,,.* --> 03: and so long till: 23,,.* --> 23:00 then, anytime you digit a time with format HH,,MM it will be converted into HH:MM. this feaure is not available in LibO 4.1.x which are you using but has reached end of life and will not receive new updates. 4.2.x is quite stable right now and you are encouraged to upgrade to 4.2.5.2 or wait the end of the month for the forthcoming 4.2.6.2 release. @László Németh here is another application of your wildcard autocorrection feature. nice, isn't it?
Laszlo Nemeth committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=3faab36347837d4168d12893b7e47f58d6440c68 fdo#81472 example for autocorrection within words The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
You can use the single pattern .*,,.*, too, with the development code. Thanks for your bug report! tommy27: thanks for your help and the tip! I added this bug report, as a fine example, to the help of LibreOffice: „To replace word parts or characters within words, you can use starting and terminating wildcard character sequences in the same pattern. For example, entering time values can be faster using only numerical keys, and double decimal separators as colons in the following way: set the pattern ".*...*" or ".*,,.*" (double dots or commas within words) and the replacement text ":", and entering "10..30" or "10,,30" results "10:30" automatically.”
yes, in LibO 4.4.x wildcard autocorrection has been improved and allows to use "in the middle" patterns such as .*,,.* so in 4.4.x you will need just one autocorrect entry like: .*,,.* to : instead of the 24 replacements described in comment 1 that you need in LibO 4.2.x and 4.3.x @Lazlo sorry if I'm asking this over and over again (but you've never replied to that) are there any chances that the middle wildcard pattern is going to be cherry-picked to the 4.3.x branch as well?