Bug 56311 - UI: Cell Comments do not play well with Frozen Cells
Summary: UI: Cell Comments do not play well with Frozen Cells
Status: CLOSED DUPLICATE of bug 34519
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.2.2 release
Hardware: Other All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: Calc-Comments
  Show dependency tree / graph
 
Reported: 2012-10-23 03:07 UTC by tustin2121
Modified: 2020-09-04 10:34 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description tustin2121 2012-10-23 03:07:06 UTC 
Problem description: 
Comments of frozen cells are subject to really annoying flickering, overzealous selection, and rejection of the enter key, making editing comments impossible until it decides to stop.

Steps to reproduce:
1. Open a new Calc Spreadsheet.
2a. Right click a cell A3 (or any cell will do) and select "Insert Comment".
2b. Type a multi-line comment. Resize the box bigger if need be.
2c. Repeat these steps until you have a few cells (A5, A10, B4, C2, B1, etc) with comments. No text needs to be in the cells themselves.
3. Select a cell B2 and select Window > Freeze to freeze the cells.
4. Now right click on cell A3 (or any cell part of the frozen cells) and select "Insert Comment" to edit (...insert to edit, right...).

Current behavior:
The comments of cells under the freeze are difficult to edit. The cursor may not appear immediately. Clicking on any text inside the cell will SELECT ALL TEXT from the beginning of the comment to the point of the click. Moving the cursor around may free up the selection, but it won't redraw properly and still appear selected. If you open a comment and click to the end of the first line (and move the cursor to free the inadvertent selection) and type enter, you'll see the cursor momentarily jump to the next line and then jump back without inserting any new lines. Some clicking around inside the box may return the comment to a workable state.

Expected behavior:
Like any comment NOT in a cell under freeze 
(though maybe better than that, considering I can click inside a just-popped-up comment and get it to vanish as if I clicked outside it - but that's another bug).

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4
Comment 1 bfoman (inactive) 2013-03-04 11:02:10 UTC 
(In reply to comment #0)
> The comments of cells under the freeze are difficult to edit. The cursor may
> not appear immediately. Clicking on any text inside the cell will SELECT ALL
> TEXT from the beginning of the comment to the point of the click. Moving the
> cursor around may free up the selection, but it won't redraw properly and
> still appear selected.

Confirmed with:
LO 4.0.0.3
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit
Comment 2 A (Andy) 2014-09-21 15:28:07 UTC 
Reproducible with LO 4.3.1.2 (Win 8.1)
Comment 3 QA Administrators 2015-10-14 19:57:17 UTC Comment hidden (obsolete)
Comment 4 Buovjaga 2016-01-29 14:34:23 UTC 
I confirm editing comment below freeze is still wonky.

Note: new location of Freeze: View - Freeze rows and columns

Win 7 Pro 64-bit Version: 5.2.0.0.alpha0+
Build ID: 259c1ed201f4277d74dfd600fed8c837cbf56abc
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-01-27_00:45:12
Locale: fi-FI (fi_FI)
Comment 5 QA Administrators 2017-11-30 06:27:48 UTC Comment hidden (obsolete)
Comment 6 Buovjaga 2017-12-16 13:07:53 UTC 
Still silly.

Arch Linux 64-bit
Version: 6.1.0.0.alpha0+
Build ID: 1390c91c7584a89298906849cdabae131f8a6191
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded
Built on December 14th 2017
Comment 7 Holger Klene 2018-04-03 22:47:14 UTC 
*** Bug 73898 has been marked as a duplicate of this bug. ***
Comment 8 funnyjokes 2018-05-17 04:18:11 UTC Comment hidden (spam)
Comment 9 muneebkhatri1 2018-12-05 12:32:20 UTC Comment hidden (spam)
Comment 10 judy mitchel 2019-07-16 10:34:55 UTC Comment hidden (spam)
Comment 11 Jacob Oram 2019-11-06 06:37:50 UTC Comment hidden (spam)
Comment 12 Jacob Oram 2019-11-06 06:40:06 UTC Comment hidden (obsolete, spam)
Comment 13 Lily Johnson 2020-03-13 17:19:53 UTC Comment hidden (spam)
Comment 14 Timur 2020-09-04 10:33:58 UTC 
Although very old, seems duplicate of even older. 
Even if older one doesn't say all this from here, it's better to have it duplicated and hope some volunteer will take it. 
During work or after status may be reviewed to see if more work is needed. 
And, unfortunately, this bug is spammed anyway.

*** This bug has been marked as a duplicate of bug 34519 ***