Issue 63639 - Excel Import: Comments / Notes out of visible screen area
Summary: Excel Import: Comments / Notes out of visible screen area
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 2.0.2
Hardware: PC Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2006-03-26 09:53 UTC by dukenude
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

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

financial planner (157.00 KB, application/
2006-04-03 13:06 UTC, dukenude
no flags Details
financial planner (163.50 KB, application/
2006-04-12 15:10 UTC, dukenude
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description dukenude 2006-03-26 09:53:43 UTC
when opening an Excel-File, comments/notices are out of the seen screen, so I 
hava to set "show notice" and scroll one minute!!!
When opening in Excel again, everything is okay.
Comment 1 lars 2006-03-26 12:10:10 UTC
Hi, can you attach such an excel file? thanks
Comment 2 dukenude 2006-04-03 13:06:44 UTC
Created attachment 35466 [details]
financial planner
Comment 3 lars 2006-04-03 16:59:06 UTC
confirmed with 680_m162 on WinXP Pro SP2
Comment 4 frank 2006-04-05 15:25:26 UTC

opened the file with Excel and selected show note on some cells. The notes are
placed outside of the viewable screen. So the position of the note is saved in
the file. Opened the file with Calc and the notes are placed exactly at the same
position as in Excel. So no defect from Calc.

Comment 5 frank 2006-04-05 15:25:53 UTC
closed invalid
Comment 6 dukenude 2006-04-11 14:25:58 UTC
but in the original Excel-File, the comments/notes are placed viewable on the 
screen. Then, when saving in Calc and opening in Excel again, the positions 
are lost! Just tried it. 
Comment 7 frank 2006-04-12 13:29:15 UTC
Is the attached file the original Excel file or a saved by Calc file ?

If it's from Calc, please attach the original one.

Comment 8 dukenude 2006-04-12 15:10:22 UTC
Created attachment 35659 [details]
financial planner
Comment 9 dukenude 2006-04-12 15:12:31 UTC
Now I added the original Excel.
When I opened it in Calc and saved it as Excel yesterday and reopened in 
Excel, some note/comment-positions have been lost.
Comment 10 frank 2006-05-09 14:15:05 UTC

opened the second attachment with OOo and Excel. Selected cell O24 in both cases
and switched on Show Note. In both cases the note displayed far away. So the
Calc import works as designed and reflects the currently set position of the
Excel notes. No bug and therefore closed again invalid.

Comment 11 frank 2006-05-09 14:15:40 UTC
closed invalid
Comment 12 robbk 2007-05-09 10:00:27 UTC
Our users have the same problem that Markus wasn't very successful in
explaining. The problem is where the note is displayed when hovering with the
mouse, not when activating "Show Note". Excel displays the note on the visible
part of the screen in any case when hovering with the mouse, even if the note is
defined to be off the screen. Calc, however, displays the note off the screen if
that's where it was placed when adding the note. You can see this in cell O24 of
both attached files. Whether this is a bug or not is arguable, however Calc does
not behave like Excel in this case, and many users view this as an error. Please
re-open the issue.
Comment 13 dukenude 2007-05-10 11:33:22 UTC
Comment 14 frank 2007-06-25 14:36:28 UTC
Hi Frank,

please comment on this one and proceed as needed. Daniel can help as this is his
construction site.

Comment 15 robbk 2007-08-01 14:07:27 UTC
Looks like someone named Frank asked someone else named Frank to comment on this
and to "proceed" over a month ago. Our users keep bugging me about this, so I'd
love to see Frank comment and proceed. Thanks.
Comment 16 robbk 2009-02-19 08:34:55 UTC
Any progress on this issue? Just tested in version 3.0 and the problem still
occurs. Thanks.
Comment 17 robbk 2009-06-08 14:48:25 UTC
This issue appears to be fixed in OOo 3.1, at least to me. Removing my vote.
Comment 18 tesotitas 2010-11-10 16:30:11 UTC
Created attachment 73202