Hello guys,
Recently I've finished the first version of the ShapeSheet Watch (http://unmanagedvisio.com/shapesheet-watch-multiselect/) tool -
the Addin which adds number of features I find quite useful while developing shapes with ShapeSheet. The tool is open-source (see the link for details).
Installers are available for Visio 2003 - 2013, x86 and x64 versions (although I did not test a lot against Visio x64)
(http://unmanagedvisio.com/wp-content/uploads/12-1-2013-4-10-15-PM.png)
Short video:
http://www.youtube.com/watch?v=vSMyCm9Y_Dc
Features:
- Docking window (shows cells of the currently selected shape/shapes), see e.g. here: http://visguy.com/vgforum/index.php?topic=1808.0
- Multiselect support (do changes to multiple Sheets at once), see e.g. http://visguy.com/vgforum/index.php?topic=4843
- Full text search (name, formula, value), see e.g. here: http://visguy.com/vgforum/index.php?topic=5046
- You can select to have all cells, or specific cells only by mask (like Watch in IDE)
- Show formula AND value, see: http://visguy.com/vgforum/index.php?topic=3652.0
- Highlight updated cells.
- Features of standard ShapeSheet: Highlight "localy" defined cells, Value completion.
http://unmanagedvisio.com/shapesheetwatch/
What is planned:
- Adding/deleting rows and sections (Add Row / Add Section / Delete row / Delete section etc)
- Copy/Paste cell range from one shape to another (like copying of custom properties or geometry sections)
- Copy/Paste to Excel.
- Table view (like standard shapesheet)
- Support of child-parent "pseudo-selector" to simply work with child/grouped shapes.
- Ability to open more than one shapesheet.
- Full-blown autocomplte.
- Translations
The source code & project (help me coding, I'm doing this in my free time!):
https://github.com/nbelyh/ShapeSheetWatch
The project tracker (bugs/feature requests):
http://unmanagedvisio.myjetbrains.com/youtrack/dashboard
Very cool!
Thank you for your good job!
+1
How can I show again the columns, mask, name, etc..
When I hide the column with not clearing check box in setting,
but with moving columns' edge, narrowing to zero width.
Now there is no column at all.
Uninstall and install again did not restore the columns.
Yes, found this bug.. will fix in the next build. If you set column width to zero "by hand" by resizing column header, you can't revert it back:
http://unmanagedvisio.myjetbrains.com/youtrack/issue/SSW-24
Now, the settings are stored in this key:
HKEY_CURRENT_USER\Software\UnmanagedVisio\ShapeSheetWatch
To workaround the problem, you can just remove this key as a whole (this will reset all settings to their defaults)
or remove the values "ColumnWidth" and "ColumnVisible" in this key which store column config.
What do you think, should the uninstaller delete all settings (now it does not)?
In general, I think the uninstaller for any program should clean up it's registry entries. But that's my personal opinion. There might be other issues to consider that I don't know about.
In the mean time, wouldn't a registry cleaner find and remove these entries after uninstall? Might be safer in general.
Third, for the less informed, like me, what steps necessary to install the shapesheet watch?
Wapperdude
Quote from: wapperdude on December 04, 2013, 04:16:10 PM
In general, I think the uninstaller for any program should clean up it's registry entries. But that's my personal opinion. There might be other issues to consider that I don't know about.
Yes, makes sense!
Quote from: wapperdude on December 04, 2013, 04:16:10 PM
Third, for the less informed, like me, what steps necessary to install the shapesheet watch?
Just run the installer :)
For normal x86 Visio:
http://unmanagedvisio.com/download/shape_sheet_watch/ShapeSheetWatch_2013_11_x86.msi
Short video:
http://unmanagedvisio.com/shapesheet-watch-multiselect/
Thanks for the clarification Nikolay. Program downloaded and ran fine. But, I don't see it in Visio. I'm running V2007, on Win7 Pro X64. (I also have Office 2010 installed. Don't know if that creates a problem.)
Wapperdude
Quote from: wapperdude on December 04, 2013, 06:11:11 PM
But, I don't see it in Visio. I'm running V2007, on Win7 Pro X64.
Not sure as well.
Normally, after install in Visio 2007 you get a toolbar "ShapeSheet Watch" where you can click a button to show the window.
WOW!
FYI: Runs fine on 64-bit Windows 7, 64-bit Visio 2013.
Quote
To workaround the problem, you can just remove this key as a whole (this will reset all settings to their defaults)
or remove the values "ColumnWidth" and "ColumnVisible" in this key which store column config.
Thank you, Nikolay.
Now works fine.
;D Happy day! It is working!!! It turned out to be fairly simple: my version of Visio is 32 bit, even though Windows is 64 bit. Ran the x86 version and all is well.
It works really well. Dragging it to the left side and placing it in the section of Visio where the Size&Pos window, etc. are located allows you to expand the width of the ShapesheetWatcher window and shrink the drawing window if desired. This allows the drawing to be centered in its window.
Minor (very minor) bug: when you hover over the "L" and "U" buttons at the top, there's a typo in the text: ..."teh grid". S/b "the grid".
Enhancement: this may already be inplace, and I need to read more about the Watcher, but, sometimes formulas can be quite long. It would be nice to have an expanded display at the top of the window to show entire entry of a selected cell. Sorry if this already exists.
This is so cool. Thanks Nikolay. :) ;)
Quote from: wapperdude on December 06, 2013, 01:29:56 AM
;D Happy day! It is working!!! It turned out to be fairly simple: my version of Visio is 32 bit, even though Windows is 64 bit. Ran the x86 version and all is well.
It works really well. Dragging it to the left side and placing it in the section of Visio where the Size&Pos window, etc. are located allows you to expand the width of the ShapesheetWatcher window and shrink the drawing window if desired. This allows the drawing to be centered in its window.
Minor (very minor) bug: when you hover over the "L" and "U" buttons at the top, there's a typo in the text: ..."teh grid". S/b "the grid".
Enhancement: this may already be inplace, and I need to read more about the Watcher, but, sometimes formulas can be quite long. It would be nice to have an expanded display at the top of the window to show entire entry of a selected cell. Sorry if this already exists.
This is so cool. Thanks Nikolay. :) ;)
Thank you!! Sure I will be improving it :)
Hi Nikolay,
did you publish your tool as open source? I would be very interested in looking at the techniques you used to implement it so seamlessly.
Quote from: Yacine on December 07, 2013, 01:00:35 PM
Hi Nikolay,
did you publish your tool as open source? I would be very interested in looking at the techniques you used to implement it so seamlessly.
Yes, the project is on github (it's a live repository):
https://github.com/nbelyh/ShapeSheetWatch
You can clone this repository, monitor it, or just download the sources as a .zip file
BTW, if someone would like to join/contribute to the project, I would really appreciate it!
The technology behind is rather old in fact /C++ to avoid any rutimes, and thus install hassles, and thus be compatible with most Visio versions, and HTML UI rendering by HTMLayout (http://www.terrainformatica.com/htmlayout/) to look nice :)/
To build everything from sources, you'll need Visual Studio installed (2008 Standard or above), and (to build installer) you'll need WiX installed.
In the root folder, there is "b.bat" file - just click it, and the project (release x86 and x64) should be built.
Hi Nikolay,
it seems like wix cannot be run on visual studio express editions. Would you happen to know a work around?
Cheers,
Yacine
Quote from: Yacine on December 24, 2013, 03:08:14 PM
Hi Nikolay,
it seems like wix cannot be run on visual studio express editions. Would you happen to know a work around?
Cheers,
Yacine
Hi Yacine, unfortunately Visual Studio Express does not support extensions (any extensions)..
I did not try to build on Express. You could try to build from command line though.
I.e. just running b.bat could do (did not test it on Express though)
Anything available for Visio 2016?
Should be fine. I'm using it with V2019.
I have no idea if there is any development on this amazing tool.. thanks I love it.
But I was using it to edit Actions and the Checked cell wont accept more than 11 characters or something.. it would not let me put in the full formula. I had to open up ShapeSheet to do it. Then it will dis play it though.
Thanks for making this. I love it!
Q
Hi qholmes,
Although I haven't done anything to this tool for a few years I believe, I am still here :D
Could you please provide more info (or maybe send the file / screenshot) so that I can understand what the issue is and hopefully fix it?
Also, the tool is open-source (https://github.com/nbelyh/ShapeSheetWatch), so in principle, anyone can fix the thing :)
Here you go. made a video.. I wonder if its to big to attach.
Oh yea way too big. only allowed 500k.
so attached a picture.
The issue it turns out is that I can not set this cell to be equal to something. You can see in the image it is =0.. which I did in Shape Sheet. If I try in Sheet Watch after I type = any other key just deletes the = sign... strange.
If I had the ability I would update it myself. I have not done any code except for scripts in a long time.
Thanks again for this!!
Q
Nikolay: Can I point ShapeSheet Watch at the PageSheet? Sorry if I missed that somewhere, but when I click a page, the Mask field is empty.
Hi Scott, I don't think this is possible to feed it with PageSheet, it just tracks the selected shape now...
But now since the app moved the project code to github, would you mind adding a feature request for this, so that I don't forget? (http://rsdn.org/Forum/Images/shuffle.gif)
I'll definitely add that, just don't know when.
https://github.com/nbelyh/ShapeSheetWatch/issues
Basically, I will probably add all feature requests from this topic :)
Will do -- thanks.