Bug 81472 - EDITING: Autocorrection off ,, [comma comma] to : [colon]
Summary: EDITING: Autocorrection off ,, [comma comma] to : [colon]
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Linguistic (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA target:4.4.0
Depends on:
Reported: 2014-07-17 23:10 UTC by Diomedea
Modified: 2014-08-26 14:06 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Diomedea 2014-07-17 23:10:01 UTC
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: release
Comment 1 tommy27 2014-07-20 06:28:21 UTC
Hi Diomedea,
if you upgrade to LibO 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 or wait the end of the month for the forthcoming release.

@László Németh
here is another application of your wildcard autocorrection feature.
nice, isn't it?
Comment 2 Commit Notification 2014-08-26 13:50:41 UTC
Laszlo Nemeth committed a patch related to this issue.
It has been pushed to "master":


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:
Affected users are encouraged to test the fix and report feedback.
Comment 3 László Németh 2014-08-26 14:02:35 UTC
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.”
Comment 4 tommy27 2014-08-26 14:06:52 UTC
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

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?