RE: Linking shape text

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

Ooops! That last post was supposed to be cancelled, not posted. Oh well.

Here's what I was able to determine:
1.) No matter what I tried, the copy/drag to a new page voided the formula.
2.) Once the shape is on the new page, I could link the text back to the
original page with the Insert > Field > custom formula. For example,
Pages[Page-1]!Sheet.1!Prop.MyText. Then, if I change the property MyText of
the sheet.1 shape on Page-1, it does change the displayed text in the shape
on the 2nd page.
3.) Once the formula has been re-entered with the page reference,
subsequent copy/paste will preserve the off page reference. Yes, I did guard
the formula, did not try it unguarded.
4.) Each time you move to a new page, you will have to re-enter the Page-1
reference.

HTH
Wapperdude



"WapperDude" wrote:



"WapperDude" wrote:

Ah! Senior moment reprieve. Phew!!! It wasn't so obvious afterall. I was
looking in the direction of Insert > Fields > custom formula.



"T. Burr" wrote:

As a recap I placed...

GUARD(SHAPETEXT(Pages[Page-1]!Sheet.15!TheText)) into Prop.RevLvl

but when ever I would try and paste another copy of that shape the shapetext
reference would get set to Ref()

So I then placed...

SETF(GETREF(Prop.RevLvl),"GUARD(SHAPETEXT(Pages[Page-1]!Sheet.15!TheText))")
into EventDrop

this would set the Prop.RevLvl value to the forumla
GUARD(SHAPETEXT(Pages[Page-1]!Sheet.15!TheText)) when I would drop or paste a
copy of the shape but wouldn't work when I copied and pasted a group or more
than one shape with the SETF in the EventDrop. I found that by adding the
SETF to EventXFMod as well would place the first formula into Prop.RevLvl no
matter where I placed it.

I tried creating a stencil for just the one shape I want to repeat. The
forulma gets placed properly but I can't set the Text Field properties in the
stencil for displaying the text.

"WapperDude" wrote:

I must be having a Sr. moment, where is the formula being placed?



"JuneTheSecond" wrote:

Hi,
You've found a great bug in Visio!
Copy&Paste brakes page reference.
Use [Ctrl]+[D] or [Ctrl]+Drag to copy in the same page.
But there is no way to escape for different page.
You might need to copy the formula, too.

--
JuneTheSecond

Now, visual calculation is more visual.
http://www.geocities.jp/visualcalculation/english/index.html


.

Relevant Pages

  • RE: Linking shape text
    ... "WapperDude" wrote: ... into EventDrop and EventXFMod on the shapesheet Visio puts ... I still don't know if I need the SETF formula in both places but until I ... Once the formula has been re-entered with the page reference, ...
    (microsoft.public.visio.general)
  • Re: Dorian is back??
    ... It hardly matters who I am, just as it really does not matter who you ... use the Reference assets to pay off their old debts, ... If the buck stops with Skilling and Lay, then the buck stops with Dory ... "harmful intent" (via civil lawsuits) will never be adequately settled ...
    (rec.music.classical.recordings)
  • RE: Linking shape text
    ... I did a quick test, removed the entries in the event sections, just left the ... guarded formula in the Prop.RevLvl value cell. ... "WapperDude" wrote: ... Once the formula has been re-entered with the page reference, ...
    (microsoft.public.visio.general)
  • RE: Linking shape text
    ... into EventDrop and EventXFMod on the shapesheet Visio puts ... "WapperDude" wrote: ... Once the formula has been re-entered with the page reference, ...
    (microsoft.public.visio.general)
  • Re: OT:Thanksgiving
    ... if math (as a subset of science), as you say, depends ... yet it seems to exist in and of itself, without reference or ... axioms and postulates to make the statement meaningful. ... One of the points I'm making is that no matter how you wriggle about, ...
    (comp.lang.cobol)