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 |
#11
|
|||
|
|||
Linking shape text
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/visualcalcul...ish/index.html |
#12
|
|||
|
|||
Linking shape text
"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/visualcalcul...ish/index.html |
#13
|
|||
|
|||
Linking shape text
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/visualcalcul...ish/index.html |
#14
|
|||
|
|||
Linking shape text
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! "WapperDude" wrote: 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/visualcalcul...ish/index.html |
#15
|
|||
|
|||
Linking shape text
Yes. Very nice. I wonder who learned the most!
"T. Burr" wrote: 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! "WapperDude" wrote: 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/visualcalcul...ish/index.html |
#16
|
|||
|
|||
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. 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. "WapperDude" wrote: Yes. Very nice. I wonder who learned the most! "T. Burr" wrote: 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! "WapperDude" wrote: 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/visualcalcul...ish/index.html |
#17
|
|||
|
|||
Linking shape text
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. "WapperDude" wrote: Yes. Very nice. I wonder who learned the most! "T. Burr" wrote: 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! "WapperDude" wrote: 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/visualcalcul...ish/index.html |
|
Thread Tools | |
Display Modes | |
|
|