Issue 28386 - A Watch Window to watch certain cells
Summary: A Watch Window to watch certain cells
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 680m34
Hardware: All All
: P2 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Blocks: 80325
  Show dependency tree
Reported: 2004-04-26 19:30 UTC by aaronforjesus
Modified: 2013-02-07 22:32 UTC (History)
8 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 aaronforjesus 2004-04-26 19:30:05 UTC
A Watch Window is a separate, small window that remains "on top" and enables
users to monitor a selected set of cells. This is great if you are working on
one sheet that has has links and formulas that apply to certain cells in another
sheet. It works similar to the one in Excel 2003. You may want to rename it,
though, just in case MS has copyrighted the feature.
Comment 1 frank 2004-04-27 10:36:54 UTC
Hi Bettina,

sounds interesting.

Open the Tols Menu from Excel2k3 and select Formula Auditing and there Show
Watch Window. Now you can add cells to watch into this window.

Comment 2 utomo99 2004-04-27 11:06:44 UTC,1759,1571629,00.asp
it say:
Our advanced testers also were interested in Excel's Watch Window feature, 
something Microsoft added to the application in Office XP. A Watch Window is a 
separate, small window that remains "on top" and enables users to monitor a 
selected set of cells. Calc does not have a similar feature, but this wouldn't 
likely be a deal breaker for FN Manufacturing users because the versions of 
Excel they currently use don't offer this functionality.

I vote for this.
Comment 3 aaronforjesus 2004-04-27 16:09:47 UTC
I guess that article has gotten around ;-)
Comment 4 rblackeagle 2004-04-27 23:56:43 UTC
It is a *very* helpful feature for complex spreadsheets and No, Calc does NOT
have it.  It is NOT a split window.  I would like to see it, but it is not a
deal-breaker for me, simply because I, unlike many others, do not write that
many complex spreadsheets.
Comment 5 utomo99 2004-04-29 05:23:38 UTC
Look at
week22 SRC680m40 
PCD - Programmabilty - Watch window

There is watch window there and planned for m40. but there is not enough info 
about this watch window, is this the same we mentions here or not. I hope we 
can have in calc too
Comment 6 kami911 2009-09-29 16:18:02 UTC
My friend has created a watchwindow for Calc. If you interested i will come back
with the details.
Comment 7 kyoshida 2009-09-29 16:32:24 UTC
@kami_: I'm interested.  Details please.
Comment 8 bettina.haberer 2010-05-21 14:43:47 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements". 
Comment 9 grakic 2010-06-29 18:27:29 UTC
I saw an announcement about Watch window extension for Calc, now published in Extensions repository.

It is developed in Java and source is available under GNU LGPL in ooop SVN 
repository at It would be nice to get some QA on this extension and make 
it ready for integration into OOo code base.
Comment 10 kami911 2010-06-30 08:24:42 UTC
Hi Goran!
Thank you for informing my friends about this extension :o)

I am sure some QA and L10N efforts are warmly welcome.