Bug 119620 - [EDITING] Create sheet during active cell editing puts content on newly created sheet
Summary: [EDITING] Create sheet during active cell editing puts content on newly creat...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
: 128527 129222 143538 (view as bug list)
Depends on:
Blocks:
 
Reported: 2018-08-31 14:26 UTC by Tony Beaumont
Modified: 2023-08-19 04:21 UTC (History)
9 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 Tony Beaumont 2018-08-31 14:26:03 UTC
Description:
If you copy a cell (ctrl-c) in the first worksheet and add a new worksheet, the copied value is pasted into the new worksheet at a random position

Steps to Reproduce:
1. copy a value in a cell on the first worksheet
2. add a new worksheet
3. you will see the copied value pasted into the new worksheet

Actual Results:
your new worksheet has a value entered into it which was not asked for

Expected Results:
you should get an empty worksheet.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Comment 1 Tony Beaumont 2018-08-31 14:31:46 UTC
Actually the steps to reproduce are wrong.  Here is a more accurate reproducible steps

1.  open calc
2.  enter #123 into any cell
3.  click on the cell and in the text box at the top highlight the 123
4.  click the + for add a new worksheet
5.  in the new worksheet you will see the value from the first worksheet pasted in at exactly the same position.
Comment 2 Tony Beaumont 2018-08-31 14:32:12 UTC Comment hidden (duplicate, obsolete)
Comment 3 Oliver Brinzing 2018-08-31 15:31:22 UTC
steps to reproduce:

- enter text in cell A1, e.g.: Hello
- do not complete editing so cursor still flashes
- click [+] to add a new sheet
- "Hello" is inserted at new sheet

Version: 6.2.0.0.alpha0+ (x64)
Build ID: 7cb6dc2652ce7e2e7d9ec7464bb1eed0d93306d7
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: de-DE (de_DE); Calc: threaded
Comment 4 Xisco Faulí 2018-09-03 17:40:42 UTC
Reproduced in

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

but not in

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 5 Aron Budea 2018-09-15 02:43:26 UTC
Bug is already in 3.5.0, but it could be bibisected with bibisect-43all to the following range.

https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=418a35f4861e863feb39eec73f4a39a87fbcb1f3..c5e280b4144d3ed642404079f464a42829be3f80
Comment 6 Markus Mohrhard 2018-09-27 18:57:08 UTC
(In reply to Aron Budea from comment #5)
> Bug is already in 3.5.0, but it could be bibisected with bibisect-43all to
> the following range.
> 
> https://cgit.freedesktop.org/libreoffice/core/log/
> ?qt=range&q=418a35f4861e863feb39eec73f4a39a87fbcb1f3..
> c5e280b4144d3ed642404079f464a42829be3f80

It is way more complicated. This bug and the one mentioned in Bug 42432 and Bug 114228 are related. Fixing one always causes the other one which means that in the last 8 years there have been three times that three times the other bug has been visible and three three times this one.

We need to find a solution that fixes both bugs at the same time.
Comment 7 Vera Blagoveschenskaya 2018-11-08 07:41:29 UTC
(In reply to Oliver Brinzing from comment #3)
> steps to reproduce:
> 
> - enter text in cell A1, e.g.: Hello
> - do not complete editing so cursor still flashes
> - click [+] to add a new sheet
> - "Hello" is inserted at new sheet
> 

Additional info: 'Hello' disappears from the first sheet!

Version: 6.2.0.0.alpha1+
Build ID: bc42b6bfa49cc2b58201a8f6177dd3b1a0c038d8
CPU threads: 4; OS: Linux 4.14; UI render: default; VCL: kde5; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2018-11-06_19:01:37
Locale: ru-RU (ru_RU.UTF-8); Calc: threaded
Comment 8 QA Administrators 2019-11-09 03:53:06 UTC Comment hidden (obsolete)
Comment 9 Oliver Brinzing 2019-11-09 10:30:00 UTC
*** Bug 128527 has been marked as a duplicate of this bug. ***
Comment 10 Oliver Brinzing 2019-12-06 17:25:32 UTC
*** Bug 129222 has been marked as a duplicate of this bug. ***
Comment 11 Oliver Brinzing 2019-12-07 06:59:13 UTC Comment hidden (obsolete)
Comment 12 Ezinne 2021-07-30 15:35:16 UTC
*** Bug 143538 has been marked as a duplicate of this bug. ***
Comment 13 BogdanB 2021-07-31 05:07:49 UTC
Repro in 
Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 5aa74aa1e6fac571f99146ebcb6adc9feb1459ad
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-07-28_19:35:14
Calc: threaded
Comment 14 BogdanB 2023-05-17 15:14:58 UTC
Please retest. Seems solved for me with

Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 247738a9afeeb2f0644fa0307b7023fe115fae83
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 15 BogdanB 2023-08-19 04:21:06 UTC
Again, seems fixed. Please reopen if you can reproduce this bug.

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 34d32740d89876c3d4fd2743a07d6e2578601683
CPU threads: 16; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded