Watching Window

×

Warning message

This extension was not updated recently. It might not work with latest versions of OpenOffice.

Primary tabs

Maintainer:
hanya
Rating:
4.25

Average: 4.3 (4 votes)

Application:
Calc
Tags:
calc, extension
Screenshots:
http://hermione.s41.xrea.com/pukiwiki/index.php?plugin=attach&pcmd=open&file=wat...
Source code:
https://github.com/hanya/WatchingWindow
Post date:
Monday, 19 July, 2010 - 03:36
Statistics
Week: Not tracked - Month: Not tracked - Year: Not tracked - Timeline
Download extension
System Independent version - All releases
Compatible with OpenOffice 4: Yes
User feedback:
Compatible with OpenOffice 4.x?

Watching value changing of a cell on the spreadsheet.

This extension works on OOo 3.3 or later, because this extension uses new feature of task pane can be provided by extensions, and grid control.
Version 0.4.X works on Apache OpenOffice 3.4.
Use version 0.5 on Apache OpenOffice 4.0.

After this extension is installed (after the Calc component is reloaded), View - Task Pane entry is shown in the main menu of the Calc window, choose it to open the watching window.
Online help is provided, please read using help viewer of the office for usage. You can open the main page of the help through contents tree. Or document can be read here.

UI languages: English, Japanese, Russian, Spanish

If you want to use this extension in your language, please help us to translate strings in your language. Now we have translation project on Transifex, please feel free to join our translation project.

The MIT License.

Watching Window

Version Operating system Compatibility Release date
0.5.2 System Independent 3.4, 4.0, 4.1 08/12/2017 - 10:00 More information Download
0.5.1 System Independent 3.4, 4.0 05/10/2013 - 04:38 More information Download
0.5.0 System Independent -- 13/06/2013 - 06:13 More information Download
0.4.4 System Independent -- 05/03/2013 - 04:42 More information Download
0.4.3 System Independent -- 01/03/2013 - 07:22 More information Download
0.4.2 System Independent -- 25/02/2013 - 13:09 More information Download
0.4.1 System Independent -- 26/05/2012 - 07:49 More information Download
0.4.0 System Independent -- 24/05/2012 - 09:16 More information Download
0.3.0 System Independent 3.4 18/07/2011 - 10:05 More information Download
0.2.3 System Independent 3.3, 3.4 08/03/2011 - 02:48 More information Download
0.2.2 System Independent 3.3, 3.4 21/01/2011 - 07:09 More information Download
0.2.1 System Independent 3.3, 3.4 23/12/2010 - 22:23 More information Download
0.2.0 System Independent 3.3, 3.4 23/12/2010 - 09:40 More information Download
0.1.3 System Independent 3.3, 3.4 19/10/2010 - 09:57 More information Download
0.1.2 System Independent 3.3, 3.4 25/07/2010 - 23:30 More information Download
0.1.1 System Independent 3.3, 3.4 21/07/2010 - 09:14 More information Download
0.1.0 System Independent 3.3, 3.4 19/07/2010 - 04:10 More information Download

Comments

Wrong description.xml:
version value="0.5.1"
dependencies
d:OpenOffice.org-minimal-version value="3.4" d:name="OpenOffice.org 3.4"
d:OpenOffice.org-maximal-version value="4.0" d:name="OpenOffice.org 4.0"

Is it possible to update this?
Thanks in advance

Thanks for the report. I've uploaded version 0.5.2 which can be installed on 4.1 or later version of the office.

Just a little issue and question...

    • In the list, formula column is not displayed with localized functions.
    • I do not understand what is "Store watches" option.
  • Thank you for reporting.

    >In the list, formula column is not displayed with localized functions.
    Fixed in git repository. I have not noticed it because I have not used the version with localized formula.

    > I do not understand what is "Store watches" option.
    Will be working since version 4.0. This function depends on the following issue: https://issues.apache.org/ooo/show_bug.cgi?id=119411
    It should be disabled on the version not supported this function.

    I upload french strings to Transifex website.
    Hope this help to have a localized OXT.

    Thank you for the translation.
    I released new version with it.

    Hi, nice extensions but you should keep in mind that you have used unpublished API's. Means the extension can be broken with the next version. I would recommend that you define a max version dependency in your description.xml and check your code with future versions. If it works change the max version of your extension and maybe increase the micro number of your extension to trigger potential updates. If it doesn't work, change the code, increase the max version and of course increase the version number of your extension to trigger the automatic update.
    It's always tricky to use unpublished API's and it requires some more maintenance work ;-)

    And a further nice feature would be to make the watch list persistent. I first idea that comes into my mind, is store to it as custom property in the document properties. This should be straight forward and loading and storing is done automatically. Ok it would be visible in the Document Properties dialog as well but maybe a better solution can be found later. Meta data can be an option maybe in the future, i don't know exactly at the moment. I am just thinking ...

    Very helpful extension.

    Do you think about adding:
    - changing a cell value via WW
    - moving an entry up and down in WW

    PS
    I see that grid control works now. I tried it in 3.2.1 version (in basic macro) and it notorious crashes whole OOo. (I made list-boxes to keep data.)