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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|