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

"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

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

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

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

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

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