Issue 44282 - Cell notes/comments are misplaced if columns to the left are hidden
Summary: Cell notes/comments are misplaced if columns to the left are hidden
Status: CLOSED DUPLICATE of issue 63671
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial with 7 votes (vote)
Target Milestone: ---
Assignee: requirements
QA Contact: issues@sc
Keywords: oooqa
: 68082 (view as issue list)
Depends on:
Reported: 2005-03-07 03:24 UTC by tdillon
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description tdillon 2005-03-07 03:24:39 UTC
The location to display a cell's note/comment seems to be calculated based on
the widths of _all_ of the columns to the left of the cell rather than just the
visible columns.  

If there are hidden columns to the left of the cell containing the comment then
the comment will be displayed too far to the right.  If there are several hidden
columns then the comment may be placed completely offscreen.
Comment 1 daniel.rentz 2005-03-23 14:55:51 UTC
Note objects do not update their position if the width of a column or the height
of a row is changed (hiding a column is nothing else than changing its width to
zero). Excel shows the same behaviour, if a note is always visible.
Comment 2 frank 2005-03-24 12:55:38 UTC
as it works like Excel enhancement for requirements
Comment 3 andreschnabel 2005-09-17 10:58:03 UTC
as i came across issue 54751, which is related, just a short note:

"as it works like in Excel" is not a good reason to declaring this as an
enhancement, not a defect.

The current behaviour is not very obvious. Notes object's position should rather
be relative to it's anchor's position. As this is not explained in the specs, it
is an enhancement. 
Comment 4 ace_dent 2006-01-28 20:01:13 UTC
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).

Comment 5 ace_dent 2006-01-29 18:32:08 UTC
Confirmed with OOo-Dev 680m152, WinXP SP2.
Problem still exists.

Comment 6 bdimm 2006-07-13 15:44:10 UTC
Just to add to ace dent's list, note positions are also not adjusted when rows
are sorted (Issue 59745).
Comment 7 ace_dent 2006-08-02 18:02:41 UTC
*** Issue 68082 has been marked as a duplicate of this issue. ***
Comment 8 daniel.rentz 2008-08-08 13:47:01 UTC
double, fixed in DEV300/dr66 (OOo 3.1)

*** This issue has been marked as a duplicate of 63671 ***
Comment 9 daniel.rentz 2008-08-08 13:47:39 UTC