celMaker 2 (part 2)

My last post was only yesterday, when I released celMaker 2 for Visio 2007 and Excel 2007, but I have already had some feedback from my fellow Visio MVP, John Goldsmith.  He found a couple of “bugs” and suggested an improvement, so they have all been implemented.

Installation

The installation from the web site should be straight forward … if you press the launch link, rather than the install button.

image

The installation adds celMaker2 to your programs under bVisual.

image

You can uninstall using Control Panel.

Note that celMaker2 will automatically check for any updates whenever it is started.

Format as Table option

John suggested that it would be nice to automatically format the data as a table in Excel.

image

So, this option does just that, which means that the headers stay visible, even when scrolled.

image  

Bug Fixes

1. One too many Invisible and Disabled columns

If you used celMaker 2 in the last 24 hours, then you will find Invisible2 and Disabled3 columns … simply delete them

2. Reading Multiple Masters with precedent cells

This resulted in an error because the processing got confused … now fixed

3. Unnamed Connection Point Rows

These were being ignored … now fixed

Please feel free to email me, davidp at bvisual.net with any comments .. they are disabled in this blog because I was getting a lot of Chinese spam.

Posted in Visio. 3 Comments »

3 Responses to “celMaker 2 (part 2)”

  1. Ralph Boehm Says:

    Hi David. I am using Visio 2007 and Excel 2013. I can copy from Visio to Excel but going from Excel to Visio will only remove existing cells. It does not add in anything new or existing from Excel. Any ideas or help?

    • davidjpp Says:

      How are you doing this? Are you using the Database Add-on? When I used to use it in the past, I think that I always ensured that the Excel range included one extra blank row.

  2. Ralph Boehm Says:

    I’m not quite sure I understand what you are asking. I copy from Visio shape into Excel. I insert an Action within the action area. I modify the row for appropriate action then I copy back into the Visio shape. Am I missing the Add On you mention? Is that on Visio side or Excel side? I added a blank row at the end of the Actions in Excel and same results.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

davecra.wordpress.com/

Microsoft Office Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...

%d bloggers like this: