Bug 152373 - Spell check on cell fails to apply correction if dialog closed after clicking Correct (see comment 3)
Summary: Spell check on cell fails to apply correction if dialog closed after clicking...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Linguistic (show other bugs)
Version:
(earliest affected)
5.2.0.4 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Spell-Checking
  Show dependency treegraph
 
Reported: 2022-12-04 18:13 UTC by MEI
Modified: 2023-04-19 05:21 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description MEI 2022-12-04 18:13:06 UTC
Description:
2nd Occurrence.  Spreadsheet with 87xG cells.  4 spreadsheets open in different windows.  Left open overnight.  Editing text in cells next day.  After editing spell check on the cell with cell selected but not editing text in cell.  Spellcheck finds word.  I correct it and when I close the spellcheck window the cell reverts to its original state.  I went to another cell and the spellcheck worked properly.  Both cells had been edited.  Failed cell 123 words 712 char, working cell 66 words, 436 char.  Cloned formatting from working cell to failed cell, still failed. Saved sheet, still fails.  Closed sheet reopened, still fails.  (1st time it happened closed and reopen fixed, something fixed it don't remember for sure, maybe only 1 window open?)  Saved as .xltx closed, reopened, fails.  Cut and pasted in new cell, new cell failed.  Put new spelling error in old cell and spell correction worked.  Pasted content into cell in new sheet, failed.  Closed all calc windows, reopened sheet, failed.  Restart in safe mode, failed.

Steps to Reproduce:
1.?leave sheet overnight
2.paste this content into cell

Another innovation to provide you with an economical alternative to standard containers its widely known as our BucketMann.  The 5-gallon translucent (see fluid level) graduated pail is a popular choice for its durability and ease in cleaning and use.  Why lift the contianer when you can stir and ladle out what you need?  Two lids are provided, one for sampling and one for transport.  The large opening means no specialized brush to clean and easy inspection of the interior.  With a handle and out easy on and off lid your samples can be transported and emptied with complete ease. It is made of the same rugged Polyethylene (Nalgene) as our other bottles so you get the same quality, but for far less money.

3.F7 to spell check cell

Actual Results:
corrects cell until spell check window is closed.  Cell reverts to uncorrected state.

Expected Results:
corrects cell.


Reproducible: Sometimes


User Profile Reset: Yes

Additional Info:
Version: 7.3.0.3 (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 MEI 2022-12-04 18:15:36 UTC
In safe mode a note came up after I submitted the bug.
You are running version 7.3 of LibreOffice for the first time. Do you want to learn what's new?
I have been using libre and have not updated in the last week.
Comment 2 MEI 2022-12-04 23:02:36 UTC
I see it was marked as invalid.  Is there some reason for this?  I can not find any explanation.
Comment 3 MEI 2022-12-05 05:38:58 UTC
When I was correcting the spelling I only corrected the word container.  the other 2 words it targeted were spelled correctly.
It appears that if you ignore the first word, correct the second word and then close the window it does not update the cell.
If you ignore the 3rd word rather than closing the window then it does update the cell.  Every word in the cell targeted by the spell check must be address or the cell is not updated.
I don't know if this was the intent or is a bug.
Comment 4 Buovjaga 2023-03-10 15:31:41 UTC
(In reply to MEI from comment #3)
> When I was correcting the spelling I only corrected the word container.  the
> other 2 words it targeted were spelled correctly.
> It appears that if you ignore the first word, correct the second word and
> then close the window it does not update the cell.
> If you ignore the 3rd word rather than closing the window then it does
> update the cell.  Every word in the cell targeted by the spell check must be
> address or the cell is not updated.
> I don't know if this was the intent or is a bug.

I reproduce. Also in version 5.2.

I used this dictionary: https://extensions.libreoffice.org/en/extensions/show/english-dictionaries

Arch Linux 64-bit, X11
Version: 7.5.1.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
7.5.1-1
Calc: CL threaded