Bug 55133 - COMMENT - added comment text gets invisible when fist row is set as header (MENU WINDOW FREEZE)
Summary: COMMENT - added comment text gets invisible when fist row is set as header (M...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: high minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 102314 108647 118061 (view as bug list)
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
 
Reported: 2012-09-20 09:18 UTC by th
Modified: 2023-04-12 08:43 UTC (History)
10 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot comment text (147.14 KB, image/png)
2012-09-20 09:18 UTC, th
Details
ScreenshotStep5 (6.30 KB, image/png)
2012-09-21 11:38 UTC, pierre-yves samyn
Details

Note You need to log in before you can comment on or make changes to this bug.
Description th 2012-09-20 09:18:26 UTC
Created attachment 67429 [details]
screenshot comment text

if i set the first ROW of my worksheet as header line (menu WINDOW / FREEZE), comment text in first row cell becomes invisible if larger than comment window

Steps to reproduce:
1. open empty spreadsheet
2. define first row as header row (menu WINDOW / FREEZE)
3. insert comment in first row cell (right click "insert comment")
4. write some comment text that is longer than the comment window, the part of the text that is longer will not break to second comment line but becomes invsible.

This only happens when the first row is frozen (menu WINDOW / FREEZE)

*******CHECK SCREENSHOT ATTACHED******
Comment 1 pierre-yves samyn 2012-09-21 10:09:27 UTC
Hello

What I reproduce:

1. File> New> Spreadsheet
2. In A1 Insert>Comment, Type "Comment text long enouth to cause line breaks"
3. Right Click on A1> Show Comment
4. Select A2
5. Window> Freeze
6. Double click in the comment on "Comment"

Expected result: edit the comment, see the all text
Actual result: edit the comment, only the first line is visible

7. Click outside the comment to quit edit mode
8. Double click in the comment on the last word "breaks"

Expected & actual result: edit the comment, see the all text

The following may not be a bug:

1. File> New> Spreadsheet
2. In A1 Insert>Comment, Type "Comment text long enouth to cause line breaks"
3. Right Click on A1> Show Comment
4. Select A2
5. Window> Freeze
6. Scroll down (mouse wheel or vertical scroll bar)

Only the first line of the comment remains visible...

Platform: Version 3.6.2.1 (Build ID: ba822cc) & Windows 7 64bits

Regards
Pierre-Yves
Comment 2 th 2012-09-21 10:29:57 UTC
OK. try it with freezing the first line FIRST (from A2 window / freeze), then add a comment to cell A1.

In my interpretation this is a bug, since it works when the first line is not "frozen".

rgds
tom
Comment 3 pierre-yves samyn 2012-09-21 11:37:35 UTC
(In reply to comment #2)
> OK. try it with freezing the first line FIRST (from A2 window / freeze), then
> add a comment to cell A1.

Ok I understand now... Probably two effects of the same bug when entering and when editing.

Steps to reproduce:
1. File> New> Spreadsheet
2. Select A2
3. Window> Freeze
4. Select A1
5. Insert>Comment, Type "Comment text long enouth to cause line breaks"

Expected result: the text must remain visible when it passes the line.
Actual result: the text after the newline is invisible when entering (becomes visible when you click outside the comment)

See ScreenshotStep5 (text after the newline is invisible)

Regards
Pierre-Yves
Comment 4 pierre-yves samyn 2012-09-21 11:38:58 UTC
Created attachment 67493 [details]
ScreenshotStep5
Comment 5 Fredrik Lonn 2013-04-06 23:27:31 UTC
I can confirm bug in LibreOffice 4.0.2.2. I have never seen any version on Windows, Linux or Mac OS X where this doesn't happen.
Comment 6 dE 2014-06-05 04:53:30 UTC
*** Bug 56619 has been marked as a duplicate of this bug. ***
Comment 7 dE 2014-06-05 04:56:57 UTC
Confirmed 4.1.4.2 Linux
Comment 8 Joel Madero 2015-01-06 19:20:32 UTC
Ubuntu 14.04
LibreOffice 4.4 beta 2 - I see the issue
LibreOffice 3.3 (inherited from OOo) - I do not see the issue.

Changing:
Priority:
Minor - can slow down professional work but will not prevent it.
Medium - looks like a regression so bumped up from low.

Keyword: Regression

Cannot bibisect (all are bad) so version is preBibisect.

One other note that might be relevant for fixing:
With 3.3 the font text is always black in comments, in all the bad ones, the font text follows the system colors set in tools-> options -> appearance. I'm not sure if these are related but I noticed it.
Comment 9 Matthew Francis 2015-01-26 04:57:28 UTC
While it's possible the behaviour on Linux is different, I can confirm this on OSX with LO 3.3.0. I think on balance this isn't a regression

Setting:
Version -> Inherited from OOo

Removing:
Keywords: regression
Comment 10 QA Administrators 2016-02-21 08:36:07 UTC Comment hidden (obsolete)
Comment 11 gui 2016-06-12 21:06:29 UTC
I have checked in Version: 5.1.3.2 (x64) on Windows 7 Pro; hidden text bug has disappeared, but remains next annoying behaviour:

- part of the frozen line cell's comment overlapped with no-frozen cells disappears when no frozen cells are scrolled, remaining visible only frozen line overlapped part of the comment.

-  part of the NO-frozen line cell's comment overlapped with FROZEN cells remains when no frozen cell is scrolled.

I cannot decide if old bug has been corrected and I must open a new bug, remain in the same bug or if described behaviour is not a bug.

Please, take your decision as developers, and it will be good for me.

Regards.
Comment 12 raal 2017-06-06 18:54:32 UTC
*** Bug 102314 has been marked as a duplicate of this bug. ***
Comment 13 raal 2017-06-26 16:48:19 UTC
*** Bug 108647 has been marked as a duplicate of this bug. ***
Comment 14 raal 2018-06-09 12:22:58 UTC
*** Bug 118061 has been marked as a duplicate of this bug. ***
Comment 15 QA Administrators 2019-06-10 02:57:17 UTC Comment hidden (obsolete)
Comment 16 m_a_riosv 2019-08-12 12:40:08 UTC
*** Bug 126847 has been marked as a duplicate of this bug. ***
Comment 17 Mike 2019-08-12 17:47:23 UTC
I submitted a bug (126487) and had it rejected as a duplicate of 55133. Fair enough.
But:
Bug 55133 seems to have prevailed in release 5.1.3.2 and it still prevails in release 6.3.0.4 (x64).
So, it seems to me that the bug has gone underground.

In case my bug report has been lost as a result of rejection I will re-quote my report here:

Description:
I added a largish comment to a cell in the first row so it is in a box which is taller than the row's height. I froze the first row. When I scroll down I can hover over the comment and it is displayed correctly.

However:

If I set the comment to "Show" and scroll so the sheet goes up (scroll down), the part of the comment which is below the first row goes up with the rest of the sheet.

Steps to Reproduce:
1. Start a new spread sheet
2. Right click row 2 and select "Freeze Rows and Columns"
3. Right click cell A1 and select "Insert Comment" and paste the following in to the comment box:

This is a long comment which goes over more than one row

4. Left click cell A1 to make the comment hide itself

At this stage scrolling the sheet up and hovering over the comment marker works fine;

BUT:

5. Right click cell A1 and select "Show Comment"

At this stage scrolling the sheet up scrolls the bottom half of the comment up as well so that you can only see:

This is a long


Actual Results:
Truncated "shown comment" on scrolling

Expected Results:
We should be able to view the whole comment on a frozen row when the sheet is scrolled up


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.3.0.4 (x64)
Build ID: 057fc023c990d676a43019934386b85b21a9ee99
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: en-GB (en_GB); UI-Language: en-US
Calc: threaded
Comment 18 Mike 2019-08-12 17:49:47 UTC
Sorry, I quoted my bug number incorrectly it should be 126847 not 126487.
Comment 19 Xisco Faulí 2019-12-03 10:17:59 UTC
Changing priority to 'high' since the number of duplicates is higher than 5 or the number of people in CC higher than 20
Comment 20 raal 2021-05-06 11:11:01 UTC
*** Bug 118061 has been marked as a duplicate of this bug. ***
Comment 21 m_a_riosv 2023-04-06 23:01:34 UTC
Works for me

Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d408e940630d131ab886a1d4619671fa0299c03e
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo
Comment 22 ady 2023-04-07 00:27:02 UTC
(In reply to m.a.riosv from comment #21)
> Works for me

Then comment 17 should be converted into a new bug report, because that behavior is still relevant.
Comment 23 Timur 2023-04-08 10:55:24 UTC
Before closing bug, it is always good to test NOK some version and then to test OK and say WFM.
Here, if someone else can test to confirm, please do.
Comment 24 ady 2023-04-08 15:24:33 UTC
(In reply to ady from comment #22)
> Then comment 17 should be converted into a new bug report, because that
> behavior is still relevant.

Bug 126847 is now no longer duplicate of this bug 55133.
Comment 25 Timur 2023-04-12 08:43:08 UTC
This was really closed too soon. When closing, duplicates need to be checked. Bug 56619 is still reproducible.