Bug 157198 - French guillemets quotation marks replacement half-messed up if added in formula bar
Summary: French guillemets quotation marks replacement half-messed up if added in form...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected, regression
Depends on:
Blocks: GTK3 AutoCorrect-Complete Calc-Formula-Bar
  Show dependency treegraph
Reported: 2023-09-11 23:02 UTC by Jeff Fortin Tam
Modified: 2023-09-28 12:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Demonstration video (926.35 KB, video/webm)
2023-09-11 23:06 UTC, Jeff Fortin Tam

Note You need to log in before you can comment on or make changes to this bug.
Description Jeff Fortin Tam 2023-09-11 23:02:30 UTC
Since recent versions of LibreOffice (7.5 at least, and also happens on 7.6) on Linux, with my French locale, I am utterly unable to type anything with "quotes" or « guillemets » inside a cell's contents, because it gets auto-converted to « whatever ".

Note that while my LibreOffice documents may be set to the relevant French locale (fr_CA), my system's locale is an English one (en_CA)

Steps to Reproduce:
1. Launch LibreOffice calc
2. Type this in a cell: banana apple pineapple
3. Set the document's language "for all document" to "French (Canada)"
4. Edit the cell's contents, try typing quotation marks around apple

Actual Results:
It becomes:

banana « apple" pineapple

Expected Results:
banana « apple » pineapple

..or at least:
banana "apple" pineapple

Not a mix of both.

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (X86_64) / LibreOffice Community
Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265
CPU threads: 8; OS: Linux 6.4; UI render: default; VCL: gtk3
Locale: fr-CA (en_CA.UTF-8); UI: en-US
Calc: threaded
Comment 1 Jeff Fortin Tam 2023-09-11 23:06:59 UTC
Created attachment 189506 [details]
Demonstration video

Preuve irréfutable 🧐
Comment 2 Jeff Fortin Tam 2023-09-11 23:18:55 UTC
Note that it is impossible for the user to correct the string even by re-editing it, it always keep re-autocorrecting incorrectly.

My smart quotes / autocorrection settings are (re)set at the defaults.
Comment 3 Stéphane Guillou (stragu) 2023-09-26 22:41:38 UTC
Thank you Jeff!

If I use the formula bar to insert the quotes, I can reproduce. I can't reproduce when editing the cell directly.
There is a mismatch between what is shown on canvas and in the formula bar.

Reminds me of bug 154623.

Tested with:

Version: (X86_64) / LibreOffice Community
Build ID: 19e9fe7c8c89399753ac1730e1c76378b18418bc
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

As expected, no repro with gen VCL plugin.

My steps:
0. make sure language for all documents is French (Canada) or French (France)
1. write in cell A1: a b c
2. press Enter
3. up arrow back to A1
4. click into formula bar to add quotes before and after the letter b

Bibisected with linux-64-7.2 repo to first bad commit 6369dbd4a2915435b19c43ef4db47139279b71c7 which points to core commit:

commit e388a4d6d7ab355fc7aa5fca05e06070693847e9
author	Caolán McNamara Tue Mar 01 16:50:37 2022 +0000
committer	Adolfo Jayme Barrientos Wed Mar 02 04:30:47 2022 +0100
Resolves: tdf#145580 need to use gtk_im_context_filter_keypress
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/130802

Caolán, can you please have a look?
Comment 4 Caolán McNamara 2023-09-27 20:16:09 UTC
its probably the same underlying problem as bug #155453 with some problem around input method input