Issue 61253

Created attachment 33626 [details]
Changing row height causes Note arrow to point to wrong cell.

Tested on WinXP SP2, with OOo2.0 and also 680m152.

Could not reproduce this issue.
>'planoduncan', please provide more information on creating the described
problem. Please include step-by-step instructions, with as much detail as
necessary, and maybe attach a test file for the issue.

Regards,
Andrew

Here are detailed instructions for duplicating Bug Report 61253:

(1) open OpenOffice.org Calc,  (2)  click cell A60 to highlight it,  (3) on the 
menu bar click Insert then Note.  (4)  in the yellow Note window type "Note for 
cell A60"  (5)  click in any other cell to close the Note window  (6)  click 
the A at the top of column A to highlight the entire column  (7)  on the menu 
bar click Format  then  Row  then  Height  (8)  Change the default height from 
0.17"  to  0.20"  and click  OK  (9)  right click cell A60 and click Show Note -
  observe that the arrow no longer points to the red square in the upper right 
corner of cell A60 but now points to cell A61.  Also observe that the note is 
now displayed at row 49 with a long arrow to cell A61.  

The problem gets worse with a longer spreadsheet.  Try the same thing with cell 
A300 and you will find the arrow points to cell A306 with the note displayed at 
row 258.  By resetting the height to whatever value it was when you entered the 
notes the view is restored but this means that if you use notes in a 
spreadsheet that you can never change the row height.

Please let me know if these detailed instructions are sufficient for you to 
duplicate this problem on your computer.   If not I will try and offer 
additional help.  Thank you.

There are several related issues (listed below), where the inserted Note is not
displayed in the expected position after some modification to the spreadsheet.

Position of Note is not adjusted when...
- Insufficient room on right-hand side of window (Issue 14286);
- Columns / rows are hidden (ie. size=0) (Issue 44282);
- Split separation inserted for row / column (Issue 56931);
- Row (/Column?) size is changed (Issue 61253).

Regards,
Andrew

Confirmed with OOo 680m152, WinXP SP2.

Recreated issue as described by 'planoduncan' (thanks for the detailed description).

Andrew

The reason I was unable to reproduce this bug at first, is that the displacement
of the arrow is proportional to the row number. In other words, trying the
procedure with a Note at Row 3 the effect is not visible, whereas for a Note at
Row 236 the arrow is clearly displaced. (Please see attached test case document).
The displacement of the Note arrow occurs when shrinking or expanding row
heights, as shown in the attached screenshot ('61253NoteArrow.png'). However, on
saving the document and reopening it, the position of the arrow is now correct.
The more serious problem is that the actual position of the Note is not updated.
This is best shown with the attached screenshot '61253NotePosition.png', taken
at ~20% zoom. Essentially this makes the Note not-visible when trying to view
after adjusting the row width.

Regards,
Andrew

Created attachment 33658 [details]
Test case (adjust row height to see problem).

Created attachment 33659 [details]
Screenshot of displaced Note arrow (before and after)

Created attachment 33660 [details]
Screenshot of Note position (at 20% view)

Hi Niklas,

I thought that this is a double but could not find something covering this
Issue. So please have a look at it.

Frank

It's issue 8049.

*** This issue has been marked as a duplicate of 8049 ***

closing duplicate

This issue was reported to be a duplicate of another issue.  I do not believe 
that is the case.  This issues was also supposed to be fixed in 3.0.  It has 
not been fixed in 3.0beta.

This issue has not been fixed in 3.0 beta

double, fixed in DEV300/dr66 (OOo 3.1)

*** This issue has been marked as a duplicate of 63671 ***

closed

This issue is still present in the latest version of OpenOffice.  It is a real 
pain because if you are using Notes in a spreadsheet you can not add/delete 
rows or change row height without the Notes positions and arrows getting out of 
place.  Someone suggested this was a duplicate issue but this is not the case.  
The issue was supposed to have been fixed in 3.0 but it wasn't.

Created attachment 62207 [details]
OpenOffice3.1 has almost fixed this issue. Changing row height or width still produces an offset - probably not enough numerical precision.

*** Issue 89306 has been marked as a duplicate of this issue. ***

*** Issue 93717 has been marked as a duplicate of this issue. ***

Confirmed in OOO310m11 Novell edition Build 2009-05-27. Increasing the row
height creates a noticeable offset of the note arrow.

Is it possible to assign a more definite Target milestone than OOo 3.x? This
problem is so serious that our users are requesting we reinstall Excel. Thank you.

Niklas, Daniel,
this issue is still present in 3.2.1 and m87. Please consider it for 3.4.
Thanks a lot for your attention.
WBR,
KP.

I see this fixed in DEV300m88 (OOo 3.x) and OOO330m13 (OOo 3.3). Tried
inserting/removing rows/columns as well as changing row/column size.

@kpalagin: What exactly does not work for you?

Note that the temporary notes shown when hovering the cell with the mouse are
always placed at a default position next to the cell. If you make the note
visible permanently, it will use its internally stored position. For the note in
cell A236, this is somewhere in row 162/163.

I just realized, also after looking at issue 115313, that after changing row
heights the line connector of temporary notes indeed points to a wrong position.

Daniel,
thanks a lot for you response.

Using m91 and following http://www.openoffice.org/issues/show_bug.cgi?
id=61253#desc4 I am getting note arrow pointing to the wrong cell (see 
screenshot). This happens for either temporary or permanently shown note.

Regards,
Kirill.

Created attachment 72817 [details]
screenshot

@kpalagin: we may set this issue as duplicate of issue 115313

So this issue should be fixed in 3.3.0?
Great job then!
Thanks a lot.

Created attachment 75694 [details]
Still not fixed in 3.3.0

Reset assigne to the default "issues@openoffice.apache.org".

Description
===========
Changing row or column size before cell with comment results in comment box and arrow drawing to the wrong place.

Expected behavior
=================
Comments draw pointing to the cell they're anchored in.

Definitions
===========
'before' --
    above (for rows)
    left  (for columns) 

Observed behavior
=================
Consider a comment somewhere on a sheet, say in cell HH200.
If all rows and columns are the default size, the comment's arrowhead will point to the top right corner of cell HH200.
As rows above or columns to the left of HH200 are resized, the comment will draw in increasingly wrong positions.
Row and column size in rows or columns beyond HH200 (i.e. HI..ZZ or 201..1000) have no effect.

Steps to reproduce
==================
1. Navigate to cell HH200 on a new spreadsheet and insert comment there.
2. Toggle 'show comment' and observe its position, pointing to the top right of HH200.
3. Reduce columns A..GZ to width 0.04. Observe HH200's comment moves right.
4. Reduce rows 1..190 to height 0.04. Observe HH200's comment moves down.
5. Enlarge rows 1..190 to height 5.0. Observe HH200's comment moves up.
6. Enlarge columns A..GZ to width 5.0. Observe HH200's comment moves left.

See also
========
#128076 - Conditional formatting being evaluated in rows before a comment causes causes comment to display pointing lower than the correct cell

Created attachment 86658 [details]
minimal working example, see cell hh200.

(above comment should have included my system details)
Windows 10
AOO 4.1.6