[Libreoffice-bugs] [Bug 108795] New: Cannot enter colon or semicolon in formula bar ( French version)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108795

            Bug ID: 108795
           Summary: Cannot enter colon or semicolon in formula bar (French
                    version)
           Product: LibreOffice
           Version: 5.3.0.3 release
          Hardware: x86 (IA32)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mjulier at free.fr

Created attachment 134298
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134298&action=edit
screenshot showing the bug

You may know that in French typography, a non-breakable space is normally
inserted before any colon or semicolon sign. So does LibreOffice Writer for
French language, with no big trouble.

In LibreOffice Calc, French version, the same happens even in the cells
configured in English language. OK, this is not the problem.

Let me click on a cell and type the text "List: one; two; three". Some spaces
are correctly inserted and the cell now contains the text "List : one ; two ;
three". If I don't want these spaces, I can now delete them: no problem.

Now, let me click on the formula bar and, again, type the text "List: one; two;
three". The formula bar will show exactly this, but the cell will show "List 
one  two  three;;:". Which means: spaces were inserted before the colons and
semicolons, and then the colons and semicolons were transferred to the end of
the string, in reverse order. This is bad!

OK then, I type Enter, go back to the same cell, and try to fix the problem in
the formula bar. I remove the extra spaces, remove the colons and semicolons at
the end, and try to insert colons and semicolons at the correct place, so that
the formula bar shows "List: one; two; three". But now, the cell contains the
text "List : on :  t :o  three", which is even worse and very strange.

I think that this bug exists since quite a long time, but I never took the time
to report it before since there is a workaround (typing into the cell).

Since it is related to a French typographic rule, I suspect that it exists just
in some languages, maybe just in the French version.

I am attaching a montage of screenshots

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170626/61c5515d/attachment.html>