Visio Guy

Visio Guy Website & General Stuff => User-submitted Stuff => Topic started by: Nikolay on December 01, 2013, 10:13:32 AM

Title: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Nikolay on December 01, 2013, 10:13:32 AM
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
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: JuneTheSecond on December 02, 2013, 02:39:48 AM
Very cool!
Thank you for your good job!
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Jumpy on December 02, 2013, 06:25:15 AM
+1
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: JuneTheSecond on December 03, 2013, 07:40:26 PM
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.
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Nikolay on December 04, 2013, 04:39:58 AM
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)?
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: wapperdude on December 04, 2013, 11:16:10 AM
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
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Nikolay on December 04, 2013, 11:50:14 AM
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!

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/
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: wapperdude on December 04, 2013, 01:11:11 PM
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
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Nikolay on December 04, 2013, 03:06:42 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.
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Visio Guy on December 05, 2013, 03:59:50 AM
WOW!

FYI: Runs fine on 64-bit Windows 7, 64-bit Visio 2013.
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: JuneTheSecond on December 05, 2013, 06:08:32 AM
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.
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: wapperdude on December 05, 2013, 08:29:56 PM
 ;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.   :)   ;)
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Nikolay on December 06, 2013, 03:28:41 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 :)
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Yacine on December 07, 2013, 08:00:35 AM
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.
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Nikolay on December 07, 2013, 09:44:25 AM
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.
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Yacine on December 24, 2013, 10:08:14 AM
Hi Nikolay,
it seems like wix cannot be run on visual studio express editions. Would you happen to know a work around?

Cheers,
Yacine
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Nikolay on December 24, 2013, 12:01:06 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)
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: jbrooks on January 03, 2019, 03:21:40 PM
Anything available for Visio 2016?
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: wapperdude on January 03, 2019, 07:56:05 PM
Should be fine.  I'm using it with V2019.
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: qholmes on March 01, 2019, 01:23:26 PM
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
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Nikolay on March 01, 2019, 02:21:23 PM
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 :)
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: qholmes on March 01, 2019, 03:29:57 PM
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
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: scott on July 14, 2020, 03:56:07 PM
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.
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: Nikolay on July 14, 2020, 04:10:42 PM
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 :)
Title: Re: ShapeSheet Watch - ShapeSheet on steroids =)
Post by: scott on July 15, 2020, 02:55:14 PM
Will do -- thanks.