Linking shape text

[T. Burr]

I want to link the text of shapes on different pages. My problem is that
when I create paste a new instance in my formula gets changed from
"=GUARD(SHAPETEXT(Pages[Page-1]!Sheet.15!TheText))" to
"=GUARD(SHAPETEXT(Ref()))". It doesn't matter if I paste it on a different
page or the same page. I've been wrestling with this problem off and on for a
while now. Can someone help me figure out why the formula keeps changing or
how to keep it from changing.

 

[Paul Herber]

I want to link the text of shapes on different pages. My problem is that
when I create paste a new instance in my formula gets changed from
"=GUARD(SHAPETEXT(Pages[Page-1]!Sheet.15!TheText))" to
"=GUARD(SHAPETEXT(Ref()))". It doesn't matter if I paste it on a different
page or the same page. I've been wrestling with this problem off and on for a
while now. Can someone help me figure out why the formula keeps changing or
how to keep it from changing.

Does shape "Sheet.15" exist on that page?

 

[John... Visio MVP]

I want to link the text of shapes on different pages. My problem is that
when I create paste a new instance in my formula gets changed from
"=GUARD(SHAPETEXT(Pages[Page-1]!Sheet.15!TheText))" to
"=GUARD(SHAPETEXT(Ref()))". It doesn't matter if I paste it on a
different
page or the same page. I've been wrestling with this problem off and on
for a
while now. Can someone help me figure out why the formula keeps changing
or
how to keep it from changing.

The Ref() indicates an invalid reference. So is there a page called Page-1
and does it contain a shape named Sheet.15?

John... Visio MVP

 

[JuneTheSecond]

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.

 

[T. Burr]

Yes. Shape.15 exists and so does Page-1. I think I might have stumbled onto
the answer. I've added
'SETF(GETREF(Prop.RevLvl),"GUARD(SHAPETEXT(Pages[Page-1]!Sheet.15!TheText))")'
to the EventDrop and EventXFMod properties. I was noticed when I had the
formula in EventDrop only and pasted more than one shape the property formula
would contain the Ref() instead of the formula. I might only need EventXFMod
set but I haven't tried that yet. I'm open to better ideas.

I want to link the text of shapes on different pages. My problem is that
when I create paste a new instance in my formula gets changed from
"=GUARD(SHAPETEXT(Pages[Page-1]!Sheet.15!TheText))" to
"=GUARD(SHAPETEXT(Ref()))". It doesn't matter if I paste it on a
different
page or the same page. I've been wrestling with this problem off and on
for a
while now. Can someone help me figure out why the formula keeps changing
or
how to keep it from changing.

The Ref() indicates an invalid reference. So is there a page called Page-1
and does it contain a shape named Sheet.15?

John... Visio MVP

 

[JuneTheSecond]

Hi,

For different page,
Open a new window with menu "Window",
open different page, and drag the shape to different page
with [Ctrl] + Drag.

 

[WapperDude]

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

 

[JuneTheSecond]

Hi,

I thought he placed the formula in the text field.

 

[JuneTheSecond]

More elegant way might be drawing stencil.
Open drawing stencil and drag the shape into drawing stencil.
The master made now can be drop to any page.

 

[T. Burr]

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.

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

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

 

[WapperDude]

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

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.

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

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

 

[WapperDude]

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

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.

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



:

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

 

[WapperDude]

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

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

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.

:

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



:

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

 

[T. Burr]

By placing
SETF(GETREF(Prop.RevLvl),"GUARD(SHAPETEXT(Pages[Page-1]!Sheet.1!TheText))")
into EventDrop and EventXFMod on the shapesheet Visio puts
GUARD(SHAPETEXT(Pages[Page-1]!Sheet.1!TheText)) into Prop.MyText everytime.

I still don't know if I need the SETF formula in both places but until I
need to put something else into either one of those event fields this will
work.

THANKS FOR THE HELP ALL!

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

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



:

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.

:

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



:

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

 

[WapperDude]

Yes. Very nice. I wonder who learned the most!

By placing
SETF(GETREF(Prop.RevLvl),"GUARD(SHAPETEXT(Pages[Page-1]!Sheet.1!TheText))")
into EventDrop and EventXFMod on the shapesheet Visio puts
GUARD(SHAPETEXT(Pages[Page-1]!Sheet.1!TheText)) into Prop.MyText everytime.

I still don't know if I need the SETF formula in both places but until I
need to put something else into either one of those event fields this will
work.

THANKS FOR THE HELP ALL!

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

:

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



:

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.

:

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



:

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

 

[WapperDude]

I did a quick test, removed the entries in the event sections, just left the
guarded formula in the Prop.RevLvl value cell. Created a new page, and then
copy/pasted the shape with the revised entries onto the new page. Also did a
cntl-drag from one original page to new page. In both cases, the Prop.RevLvl
value cell retained the formula complete with Page-1 reference, and the text
stayed sync'd or linked to the original shape. I don't think you need either
event entries. Oh, the 1st clone I did use the Insert > Field > Shape Data
to display the Prop.RevLvl entry. After that, it's just a matter of
copy/paste. This would free up your event cells for other use.

Yes. Very nice. I wonder who learned the most!

By placing
SETF(GETREF(Prop.RevLvl),"GUARD(SHAPETEXT(Pages[Page-1]!Sheet.1!TheText))")
into EventDrop and EventXFMod on the shapesheet Visio puts
GUARD(SHAPETEXT(Pages[Page-1]!Sheet.1!TheText)) into Prop.MyText everytime.

I still don't know if I need the SETF formula in both places but until I
need to put something else into either one of those event fields this will
work.

THANKS FOR THE HELP ALL!

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



:



:

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



:

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.

:

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



:

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

 

[T. Burr]

I think I did even though it took me a while to figure out everything. I
spent a lot of time on MSDN and then here looking for answers.

Thanks for the help again.

Yes. Very nice. I wonder who learned the most!

By placing
SETF(GETREF(Prop.RevLvl),"GUARD(SHAPETEXT(Pages[Page-1]!Sheet.1!TheText))")
into EventDrop and EventXFMod on the shapesheet Visio puts
GUARD(SHAPETEXT(Pages[Page-1]!Sheet.1!TheText)) into Prop.MyText everytime.

I still don't know if I need the SETF formula in both places but until I
need to put something else into either one of those event fields this will
work.

THANKS FOR THE HELP ALL!

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



:



:

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



:

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.

:

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



:

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