Apache OpenOffice (AOO) Bugzilla – Issue 61253
Changing row height causes Note arrow to point to wrong cell
Last modified: 2019-03-26 00:08:16 UTC
Changing row height causes Note arrow to point to wrong cell, see attachment.
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