With Watch Window Extension, you can add a Watch Window, which keeps the value of the monitored cell on the screen, no matter where the change is made.
Check out WatchWindow Extension in action.
1) Start OpenOffice.org Calc
2) Select Tools → Detective → Display watch window
3) Add a cell that you want to watch with "Add cell" button
This is the perfect way to monitor several cells' data and formula in one place.
This is a community solution for long-running Issue number 28386 and also it proposed for Google Summer of Code 2008 and also in Community Innovation Program too.
Please help us to make this extension better with your feedback and do not forget to contribute. We are looking for user who translating and documenting this extension.
If you like this extension you can donate our further development work here.