Bug 70618 - Rows modified by spellchecking function
Summary: Rows modified by spellchecking function
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) rc
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Spell-Checking Cell-Management
  Show dependency treegraph
Reported: 2013-10-18 13:48 UTC by Urmas
Modified: 2021-06-10 08:08 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:

starting point for bug demonstration (8.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-18 15:57 UTC, Terrence Enger
typescript of demonstration starting with previously attached file (1.26 KB, text/plain)
2013-10-18 15:58 UTC, Terrence Enger

Note You need to log in before you can comment on or make changes to this bug.
Description Urmas 2013-10-18 13:48:22 UTC
When table rows are removed during the spellchecking, pressing 'Skip' button may make deleted rows to re-appear or existing rows to get duplicated.
Comment 1 Terrence Enger 2013-10-18 15:57:29 UTC
Created attachment 87827 [details]
starting point for bug demonstration

Note that these steps are fragile: merely visiting another application
to refer to the steps can change the result.  Anyway, to show the bug:

(*) Open attached workbook.  Or, enter the following into a new
    worksheet; note the deliberate typo in cell B4.

           |  A       B
         - +  ------  -----
         1 |  The	quick
         2 |  brown	fox
         3 |  jumps	over
         4 |  the	lzay
         5 |  dog	

(*) Type <F7>.  Program presents dialog "Spelling: English (USA)"
    showing "Not in dictionary" = "lzay" and four suggestions.

(*) In the worksheet, right click on the header for row four.  The
    dialog remains visible but the program gives focus to the
    worksheet, highlights row 4, and presents a pop-up menu.

(*) From the pop-up menu select "Delete selected rows".  Cell A4
    contains "dog" and B4 is blank; rows 5 and following are blank.

(*) In the spellcheck dialog, click <Ignore Once>.

    Result expected : in the worksheet, A4 has "dog" and B4 has blank.

    Result observed : in the worksheet, A4 has "dog" and B4 has "lzay".

(*) After dismissing the message and dialog boxes, "Save As...",
    Close, and Open, cell B4 still has "lzay".

These observations are from master commit 95e95e0, pulled 2013-09-19,
configured with:


built on ubuntu-natty (11.04) 32-bit, and executing on ubuntu-quantal
(12.10) 64-bit.
Comment 2 Terrence Enger 2013-10-18 15:58:35 UTC
Created attachment 87828 [details]
typescript of demonstration starting with previously attached file
Comment 3 Terrence Enger 2013-10-18 16:27:52 UTC
I am not supplying keyworkd "bibisected" because (to the resolution of
the 40 bibisect) the bug appears at the same time that the spellcheck
recognizes "lzay" as an error.  So I figure that the result is not
very interesting.  Still, from `git bisect`:

    897cb6dda02ae841cd1831e132de2aba7821a601 is the first bad commit

and from `git bisect log`:

    # bad: [5b4b36d87517a6ea96ff8c84c46b12f462fc9a1a] source-hash-8450a99c744e9005f19173e4df35d65640bcf5c4
    # good: [65fd30f5cb4cdd37995a33420ed8273c0a29bf00] source-hash-d6cde02dbce8c28c6af836e2dc1120f8a6ef9932
    git bisect start 'latest' 'oldest'
    # bad: [16b0b88cbd4ef0f51816e97277e40c5cf78f7bf9] source-hash-099198a4224778fe6e43f5dc13b5b9b1b4dc828c
    git bisect bad 16b0b88cbd4ef0f51816e97277e40c5cf78f7bf9
    # good: [598083cdb5699e7f45183da8b750815f62ff5485] source-hash-ecb1599ad00e71dfe05f3ae9a71bdce5f7540a40
    git bisect good 598083cdb5699e7f45183da8b750815f62ff5485
    # good: [cc1fc072dd691da3da43742dfc3fdd126157257b] source-hash-18c661f715a0b6850d30b374e5556dc14a377d2b
    git bisect good cc1fc072dd691da3da43742dfc3fdd126157257b
    # bad: [fb0ce84a03588593a081ac3a26b2ada2d960b76c] source-hash-1aa91a2d8e7db5cebff5b47f3005f1acff64d25e
    git bisect bad fb0ce84a03588593a081ac3a26b2ada2d960b76c
    # good: [971746fd36818460b8a85a28b87a480808635f79] source-hash-7e6e16ba6de2d3ef2b130d1ad5ffeabfdb37918e
    git bisect good 971746fd36818460b8a85a28b87a480808635f79
    # bad: [3dd564c99651edb7fc45bea4afec8e98f7a8aa19] source-hash-0bbf79005a697c6781047c01f05eb660836a18e1
    git bisect bad 3dd564c99651edb7fc45bea4afec8e98f7a8aa19
    # bad: [dda5f411582f8cab90cb3f9abc456fdadb972afb] source-hash-5553dfe2060cb4a02a827c9774a60e4408d20c33
    git bisect bad dda5f411582f8cab90cb3f9abc456fdadb972afb
    # bad: [897cb6dda02ae841cd1831e132de2aba7821a601] source-hash-212c18430864f110e5a3549c0279b1a2ea4bb6bd
    git bisect bad 897cb6dda02ae841cd1831e132de2aba7821a601
Comment 4 QA Administrators 2015-04-01 14:42:11 UTC Comment hidden (obsolete)
Comment 5 Buovjaga 2015-04-24 12:33:33 UTC
Repro with attachment 87827 [details]

Ubuntu 15.04 64-bit 
Build ID: 40m0(Build:2)
Locale: en_US
Comment 6 QA Administrators 2016-09-20 09:33:02 UTC Comment hidden (obsolete)
Comment 7 Terrence Enger 2016-09-23 18:26:03 UTC
I still see the bug on debian-stretch, both in daily Linux dbgutil
bibibsect repository version 2016-09-20 and in LibreOffice
Comment 8 QA Administrators 2018-07-25 02:40:52 UTC Comment hidden (obsolete)
Comment 9 Terrence Enger 2018-07-28 18:24:08 UTC
I still see the reported problem in LibreOffice as delivered with

    Build ID: 1:6.0.6~rc1-1
    CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2; 
    Locale: en-CA (en_CA.utf8); Calc: group
Comment 10 QA Administrators 2019-07-30 03:15:37 UTC Comment hidden (obsolete)
Comment 11 Terrence Enger 2019-07-31 17:10:25 UTC
I still the reported problem in bibisect-linux-64-6.4 version
committed 2019-07-29 running on debian-buster.
Comment 12 Shantanu 2021-06-10 08:08:30 UTC
reproduced using...

Version: (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 1; OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded