Bug 34519 - Cell comments should be above a split in freeze
Summary: Cell comments should be above a split in freeze
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 56311 73898 95308 121372 (view as bug list)
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
 
Reported: 2011-02-21 01:03 UTC by Stevie24680
Modified: 2024-03-20 15:24 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
sheet showing the described phenomena (67.79 KB, image/jpeg)
2020-06-25 00:15 UTC, b.
Details
screenshot illustrating comment textboxes far off from referenced cell (70.95 KB, image/jpeg)
2020-06-25 00:17 UTC, b.
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Stevie24680 2011-02-21 01:03:17 UTC
Hi, 

i have set the window fixed that the first line and also the first column dont scroll away with the other lines/columns. The fixed line/column office shows marked with a thicker gridline.  When i add a comment right over the border of the fixed part and moving part i can still see that line through the comment. 

The comments usually scroll together with the cells. So they disappear with the cells under the fixed lines/columns. That is like it is meant to be. But when the comment box is just partly over the fixed part and i scroll the other cells away the commentbox will be splitted in two parts.

When trying out this i found another bug with those comment boxes. That box doesnt keep its position where i moved it to. When its set that the comment only comes visible when i point the mouse on the cell the position of the comment is still there where i created it at the beginning. But when i use the right-click menu and choose show comment the box is at the place where i moved it to. 

regards,
Stevie
Comment 1 Björn Michaelsen 2011-12-23 11:45:07 UTC Comment hidden (obsolete)
Comment 2 Roman Eisele 2012-05-03 08:44:37 UTC Comment hidden (obsolete)
Comment 3 Florian Reisinger 2012-08-14 13:58:34 UTC Comment hidden (obsolete)
Comment 4 Florian Reisinger 2012-08-14 13:59:49 UTC Comment hidden (obsolete)
Comment 5 Florian Reisinger 2012-08-14 14:04:27 UTC Comment hidden (obsolete)
Comment 6 Florian Reisinger 2012-08-14 14:06:38 UTC Comment hidden (obsolete)
Comment 7 b. 2020-06-21 14:21:21 UTC
rechecked that bug, pls. recheck and comment whether intended / ok: 

> i have set the window fixed that the first line and also the first column dont 
> scroll away with the other lines/columns. The fixed line/column office shows 
> marked with a thicker gridline.  When i add a comment right over the border of 
> the fixed part and moving part i can still see that line through the comment. 

is as described in ver. 7.1.0.0.a0+ winx64 and linx64, ok? 

> The comments usually scroll together with the cells. So they disappear with 
> the cells under the fixed lines/columns. That is like it is meant to be. But 
> when the comment box is just partly over the fixed part and i scroll the other 
> cells away the commentbox will be splitted in two parts.

thats´seems 'off' in above mentioned ver., 

> When trying out this i found another bug with those comment boxes. That box 
> doesnt keep its position where i moved it to. When its set that the comment 
> only comes visible when i point the mouse on the cell the position of the 
> comment is still there where i created it at the beginning. But when i use the 
> right-click menu and choose show comment the box is at the place where i moved 
> it to. 

behaviour as described in OP, two different positions for comment, one - automatic? - for 'mouseover', one - setable - for 'show comment', ok? 

while playing around i spotted that comments for rows below 66053 are created far far away from their reference cell, e.g. at A198158 for A66054, ok? new bug? handele here? 

and that on creating comments for rows below 520163 the arrow / pointer on create points below the sheet, for cells below row 520189 the creating textbox is below the sheet, and below row 520209 the textbox isn't shown on the screen, probably because too far off from the sheet, intended? ok? handele here? new bug? 

tested with win 6.1.6.3 and 7.1.0.0.a0+, lin 6.4.4.2 has different behaviour, but neither 'clean', e.g. comments for row 1048576 are shown at row 1048526 on mouseover,
Comment 8 Timur 2020-06-24 07:45:30 UTC
This was set Invalid in 2012 and Newbie reopened im 2020.
You should have a good reason for that and clear repro steps with some screenshot or Screencast.
Comment 9 b. 2020-06-25 00:15:47 UTC
Created attachment 162390 [details]
sheet showing the described phenomena

@Timur: 

> You should have a good reason for that and clear repro steps with some screenshot or Screencast.

created attachement: 

1.) comment 'Test' showing splitted display of comment, 

2.) comment 'Test2' active by 'show comment' (in difference to comment 'Test' shown by mouseover) appears at at 'setted' position, while 'Test' appears at a standard position right to the referenced cell, 

both not a problem for me, just the question if intended or if OP was right to make a bug for it, 

bug was closed formerly regarding 'no info', i have just tried and found most of the criticized behavior unchanged, thus the question bug or not, 

the other behaviour constructing the textboxes far away from the referenced cells i consider 'bug', it's quite easy to test, for your convenience i'll provide a screenshot in attachment with next comment, i right clicked and selected 'add comment' on cell A396310, the yellow box appeared near to cell A792622, 

feel free to ask if you need more info ...
Comment 10 b. 2020-06-25 00:17:36 UTC
Created attachment 162391 [details]
screenshot illustrating comment textboxes far off from referenced cell
Comment 11 Timur 2020-06-25 13:13:33 UTC
*** Bug 95308 has been marked as a duplicate of this bug. ***
Comment 12 Timur 2020-06-25 13:14:37 UTC
*** Bug 121372 has been marked as a duplicate of this bug. ***
Comment 13 b. 2020-07-01 09:11:32 UTC
'split line drawn in layer above comment': still repro, is affecting comments shown by mouseover, comments shown by 'right click - show comment' have better behaviour, 

'comment box splitted in two parts': no repro or i didn't find the right steps, 

'comment positioning not respected by show on mouseover': still repro, but something between 'very little problem' or 'good feature', 

'comments created far away from referenced cells below row 66053': linux not affected, 

'comments shown with mouseover appear at wrong places in the bottom of a sheet': no repro, 

'comments are hidden by form controls too' from tdf#121372: still repro, 

Version: 7.1.0.0.alpha0+
Build ID: 7b00fbddfb1cd55a68ed7481ebd4a5d5f60c6128
CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: gtk3
Locale: en-US (en_US.utf8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF-dbg, Branch:master, Time: 2020-06-30_22:29:48
Calc: threaded
Comment 14 Timur 2020-09-04 10:33:58 UTC
*** Bug 56311 has been marked as a duplicate of this bug. ***
Comment 15 Timur 2020-09-04 10:34:28 UTC
*** Bug 73898 has been marked as a duplicate of this bug. ***
Comment 16 QA Administrators 2022-09-05 03:37:33 UTC
Dear Stevie24680,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug