Re: Detecting "real" formula in a cell - why I want to do it

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

That is a good scenario, but I don't know of a way to accomplish that using
just the Shapesheet.

There are programming alternatives that avoid VBA. One option is a COM
Add-in. This can be created in VB but is deployed as a DLL.

--
Mark Nelson
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

"Mike Greenawalt" <mgreenawalt@xxxxxxxxxx> wrote in message
news:OCi%235tRbFHA.3132@xxxxxxxxxxxxxxxxxxxxxxx
>I was hoping to avoid doing programming beyond shapesheet formulas.
>
> What I am trying to accomplish is to have a 1-D connector shape detect
> when it is connected at both ends. We use Visio to develop diagrams which
> get post-processed outside Visio (from .vdx file), and it is important
> that all connectors on the pages actually *be* connected on both ends.
> Just relying on the visual appearance of the diagram is not enough, as you
> see the connector visual clues only when the connector shape is selected.
>
> I would like to have the shape itself detect when it is not connected on
> both ends and give some kind of signal, maybe changing color (blinking
> would be nice, but probably a lot more difficult) that would be visible
> even when the shape is not selected.
>
> So far, the only signal I have seen that indicates a connected state in
> the shapesheet is that the BeginX/Y, EndX/Y cells get filled with a
> formula that calculates position from parameters of the connectee
> shape(s). I have been looking for a way to detect that.
>
> Our users start with a stencil of shapes that we have created for our
> domain and a blank drawing page. I had hoped to be able to do what I want
> within the confines of the Shapesheet and avoid VBA programming, as that
> makes delivery more complicated.
>
> I would think someone out there would have wanted to do something similar.
> I hope they can respond.
>
> -- Mike
>
> Mark Nelson [MS] wrote:
>> Programmatically you can compare the FormulaU and ResultIU properties of
>> the cell, but I don't think this is possible within the Shapesheet.
>>


.

Relevant Pages

  • Re: Referencing unresolved formulas in other cells
    ... If your connector is a Dynamic Connector ... There isn't a good way to do this purely in the Shapesheet. ... >> Cell references work with values, ... >>> way to reference the cell such that it returns the unresolved formula ...
    (microsoft.public.visio.developer.vba)
  • Re: Center-to-Center connectors
    ... that if I moved the end of a dynamic connector ... shapesheet, but confirmed the change with shapesheet). ... I made some very tall skinny ovals, and very flat, wide ... such a way that the contact points at the perimeters automagically ...
    (microsoft.public.visio.general)
  • Re: Very cheap Spartan3 board that can be configured by simple USB
    ... My Xylo-LM can be programmed by the FX2 USB chip, I did purchase the el-cheapo parallel cable and another Xilinx/Altera compatible one from KNJN but it is a PITA on today's computers, parallel port is simply dead. ... Antoher problem is the esoteric I/O connector, otherwise it could be a good fit. ... He is a fine brass pounder with his Vibroplex but I am pretty sure not much tolerant with the quirks of bitfile programming webise/impact and cables. ...
    (comp.arch.fpga)
  • Re: How to customize shortcut menu?
    ... involves the ShapeSheet, which is more Excel than programming). ... Anyway, I completely understand about the just 'using' Visio, but I would ... shapes, right-click and have one of the options be "Align Shapes". ...
    (microsoft.public.visio.general)
  • Re: Center-to-Center connectors
    ... Is there a way to transfer a page from one visio file to ... shapesheet, but confirmed the change with shapesheet). ...  I made some very tall skinny ovals, and very flat, wide ... geometry) to such a smart connector? ...
    (microsoft.public.visio.general)