A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linking shape text



 
 
Thread Tools Display Modes
  #1  
Old January 6th, 2009, 08:25 PM posted to microsoft.public.visio.general
T. Burr
external usenet poster
 
Posts: 9
Default Linking shape text

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.
  #2  
Old January 6th, 2009, 11:25 PM posted to microsoft.public.visio.general
Paul Herber
external usenet poster
 
Posts: 1,732
Default Linking shape text

On Tue, 6 Jan 2009 11:25:02 -0800, T. Burr
wrote:

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?


--
Regards, Paul Herber, Sandrila Ltd.
DFD/SSADM for Visio http://www.visio-dfd.sandrila.co.uk/
  #3  
Old January 6th, 2009, 11:45 PM posted to microsoft.public.visio.general
John... Visio MVP
external usenet poster
 
Posts: 900
Default Linking shape text

"T. Burr" wrote in message
...
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

  #4  
Old January 7th, 2009, 01:31 AM posted to microsoft.public.visio.general
JuneTheSecond
external usenet poster
 
Posts: 69
Default Linking shape text

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/visualcalcul...ish/index.html


  #5  
Old January 7th, 2009, 01:54 AM posted to microsoft.public.visio.general
T. Burr
external usenet poster
 
Posts: 9
Default Linking shape text

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.

On a related subject do you know if linking shape text can be done between
background pages? I think that would end up making things a lot easier.

"John... Visio MVP" wrote:

"T. Burr" wrote in message
...
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


  #6  
Old January 7th, 2009, 03:02 AM posted to microsoft.public.visio.general
JuneTheSecond
external usenet poster
 
Posts: 69
Default Linking shape text

Hi,

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

--
JuneTheSecond

Now, visual calculation is more visual.
http://www.geocities.jp/visualcalcul...ish/index.html

  #7  
Old January 7th, 2009, 04:09 AM posted to microsoft.public.visio.general
WapperDude
external usenet poster
 
Posts: 589
Default Linking shape text

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/visualcalcul...ish/index.html


  #8  
Old January 7th, 2009, 07:29 AM posted to microsoft.public.visio.general
JuneTheSecond
external usenet poster
 
Posts: 69
Default Linking shape text

Hi,

I thought he placed the formula in the text field.

--
JuneTheSecond

Now, visual calculation is more visual.
http://www.geocities.jp/visualcalcul...ish/index.html

  #9  
Old January 7th, 2009, 11:33 AM posted to microsoft.public.visio.general
JuneTheSecond
external usenet poster
 
Posts: 69
Default Linking shape text

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.

--
JuneTheSecond

Now, visual calculation is more visual.
http://www.geocities.jp/visualcalcul...ish/index.html

  #10  
Old January 7th, 2009, 03:30 PM posted to microsoft.public.visio.general
T. Burr
external usenet poster
 
Posts: 9
Default Linking shape text

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/visualcalcul...ish/index.html


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.