<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Cannot enter colon or semicolon in formula bar (French version)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=108795#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Cannot enter colon or semicolon in formula bar (French version)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=108795">bug 108795</a> from <a class="email" href="mailto:mjulier@free.fr" title="Miguel <mjulier@free.fr>"> Miguel</a> <pre>I have LANGUAGE=fr_FR LANG,LC_ADDRESS,LC_IDENTIFICATION,LC_MEASUREMENT,LC_MONETARY,LC_NAME,LC_NUMERIC,LC_PAPER,LC_TELEPHONE,LC_TIME=fr_FR.UTF-8 Could it be related to the UTF-8 encoding? You tried with fr_FR, which I think is an 8-bit encoding. Non-breaking space is 2 bytes in UTF-8, 1 byte in 8-bit encoding. I tried and saved into CSV (UTF-8), see in second file. The inserted space actually is a non-braking space (UTF-8: C2 A0) $ cat colon.csv Type in cell =>,List : one ; two ; three Type in formula bar =>,List one two three;;: Type and correct in formula bar =>,"List on , t wo th;;:" $ hexdump -C colon.csv 00000000 54 79 70 65 20 69 6e 20 63 65 6c 6c 20 3d 3e 2c |Type in cell =>,| 00000010 4c 69 73 74 c2 a0 3a 20 6f 6e 65 c2 a0 3b 20 74 |List..: one..; t| 00000020 77 6f c2 a0 3b 20 74 68 72 65 65 0a 54 79 70 65 |wo..; three.Type| 00000030 20 69 6e 20 66 6f 72 6d 75 6c 61 20 62 61 72 20 | in formula bar | 00000040 3d 3e 2c 4c 69 73 74 c2 a0 20 6f 6e 65 c2 a0 20 |=>,List.. one.. | 00000050 74 77 6f c2 a0 20 74 68 72 65 65 3b 3b 3a 0a 54 |two.. three;;:.T| 00000060 79 70 65 20 61 6e 64 20 63 6f 72 72 65 63 74 20 |ype and correct | 00000070 69 6e 20 66 6f 72 6d 75 6c 61 20 62 61 72 20 3d |in formula bar =| 00000080 3e 2c 22 4c 69 73 74 c2 a0 c2 a0 20 6f 6e c2 a0 |>,"List.... on..| 00000090 2c c2 a0 20 74 c2 a0 77 6f c2 a0 20 74 68 3b 3b |,.. t..wo.. th;;| 000000a0 3a 22 0a |:".| 000000a3</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>