Bug 148160 - Return carriage in a cell in Calc breaks french autocorrect
Summary: Return carriage in a cell in Calc breaks french autocorrect
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Whiteboard: target:7.4.0 target:7.3.3
Depends on:
Reported: 2022-03-24 10:33 UTC by remi.bernadac
Modified: 2022-03-25 08:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Initial creation of the file, with correct underline (2.20 KB, image/png)
2022-03-24 10:37 UTC, remi.bernadac
Wrong autocorrect after re-opening (2.36 KB, image/png)
2022-03-24 10:38 UTC, remi.bernadac

Note You need to log in before you can comment on or make changes to this bug.
Description remi.bernadac 2022-03-24 10:33:57 UTC
Using French LibreOffice, since v7, when opening a calc file, if a cell contains text with a line break (ctrl+enter), it seems the English autocorrect is used, instead of french.
After editing the cell (keeping the line break), it switches back to french, until next opening of the file.

Steps to Reproduce:
1. Create new calc file, insert french text with return carriage ("Bonjour, ceci est un [return carriage] texte en français", for example)
2. Save file and close LO
3. Open the file saved to see autocorrect in english
4. Edit the cell to see the switch back to french

Actual Results:
In the cell wich contains french text and return carriage, every french word is underlined in red.
In a cell wich contains english text and return carriage, nothing is underlined

Expected Results:
French spelled words shouldn't be underlined
English word should be underlined

Reproducible: Always

User Profile Reset: Yes

OpenGL enabled: Yes

Additional Info:
Version: (x64) / LibreOffice Community
Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: CL
Comment 1 Mike Kaganski 2022-03-24 10:35:30 UTC
I would expect it to be what https://git.libreoffice.org/core/+/dd25fd6bf9b9637d4f1efcfcc642efa4be7f62b1 fixed recently.
Comment 2 remi.bernadac 2022-03-24 10:37:27 UTC
Created attachment 179073 [details]
Initial creation of the file, with correct underline
Comment 3 remi.bernadac 2022-03-24 10:38:12 UTC
Created attachment 179074 [details]
Wrong autocorrect after re-opening
Comment 4 Commit Notification 2022-03-24 17:02:01 UTC
Szymon Kłos committed a patch related to this issue.
It has been pushed to "libreoffice-7-3":


tdf#148160 Use correct language for spellchecking in calc

It will be available in 7.3.3.

The patch should be included in the daily builds available at
https://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 5 remi.bernadac 2022-03-25 08:12:48 UTC
Bug seems to be corrected in the latest 7.3.3 daily build.
Thanks a lot guys