Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2020, 11:41 AM
BenMcLean BenMcLean is offline =CALLOUTTARGETREF()!Prop doesn't exist Windows 10 =CALLOUTTARGETREF()!Prop doesn't exist Office 2019
Novice
=CALLOUTTARGETREF()!Prop doesn't exist
 
Join Date: Jul 2020
Posts: 5
BenMcLean is on a distinguished road
Unhappy =CALLOUTTARGETREF()!Prop doesn't exist


I have a callout pointing at a shape. I want the callout to show some of the properties of the shape. Say I want to point it at a shape that represents a server on a network diagram and I want it to show the server's IP Address

The custom formula for that field should look like this:
Code:
=CALLOUTTARGETREF()!Prop.IPADDRESS
Microsoft's own documentation says "The "Prop" in the name is added automatically by Visio." but it isn't there. Prop doesn't exist!

Or at least that's what I think is happening. It'll say, "Error in formula." when I enter that custom formula. IntelliSense finds the CALLOUTTARGETREF but not the Prop part.

This is in Visio 2016 on Windows 10.
Reply With Quote
  #2  
Old 07-07-2020, 09:34 PM
Guessed's Avatar
Guessed Guessed is offline =CALLOUTTARGETREF()!Prop doesn't exist Windows 10 =CALLOUTTARGETREF()!Prop doesn't exist Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Examine the Shapesheet of the callout target to verify the actual name of the Shape Data property. The label might be IPAddress but its 'name' might not match that. For instance, you might find that =CALLOUTTARGETREF()!Prop.Row_1 works whereas =CALLOUTTARGETREF()!Prop.IPADDRESS does not.

In the shapesheet, you look at the Shape Data and find the red text in the first column. That is the text you should be using in your field. If you pick a properties name rather than its label it should behave as advertised.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 07-08-2020, 08:37 AM
BenMcLean BenMcLean is offline =CALLOUTTARGETREF()!Prop doesn't exist Windows 10 =CALLOUTTARGETREF()!Prop doesn't exist Office 2016
Novice
=CALLOUTTARGETREF()!Prop doesn't exist
 
Join Date: Jul 2020
Posts: 5
BenMcLean is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
Examine the Shapesheet of the callout target to verify the actual name of the Shape Data property. The label might be IPAddress but its 'name' might not match that. For instance, you might find that =CALLOUTTARGETREF()!Prop.Row_1 works whereas =CALLOUTTARGETREF()!Prop.IPADDRESS does not.

In the shapesheet, you look at the Shape Data and find the red text in the first column. That is the text you should be using in your field. If you pick a properties name rather than its label it should behave as advertised.
I can't get anything that starts with Prop to work. Yes, it's actually "Prop.IPAddress" not "Prop.IPADDRESS" but the correct capitalization doesn't work either. Nothing works. "Prop" stuff doesn't exist in the list under =CALLOUTTARGETREF() at all even though the ShapeSheet shows it does exist.
Reply With Quote
  #4  
Old 07-08-2020, 03:11 PM
Guessed's Avatar
Guessed Guessed is offline =CALLOUTTARGETREF()!Prop doesn't exist Windows 10 =CALLOUTTARGETREF()!Prop doesn't exist Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Can you attach a visio file with your shape and its callout? I can have a look to see where you are going wrong.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 07-10-2020, 12:16 PM
BenMcLean BenMcLean is offline =CALLOUTTARGETREF()!Prop doesn't exist Windows 10 =CALLOUTTARGETREF()!Prop doesn't exist Office 2016
Novice
=CALLOUTTARGETREF()!Prop doesn't exist
 
Join Date: Jul 2020
Posts: 5
BenMcLean is on a distinguished road
Default

I just start a new document, pull a 3D Computer shape from the shapes Visio comes with, put text in its ShapeData, attach a normal callout to it and try to add a field to the callout's text referencing the callout's target but always get "Error in formula."

This happens with any of the network diagram shapes.

I don't see how I could attach a document that actually shows the problem.
Reply With Quote
  #6  
Old 07-10-2020, 10:49 PM
Guessed's Avatar
Guessed Guessed is offline =CALLOUTTARGETREF()!Prop doesn't exist Windows 10 =CALLOUTTARGETREF()!Prop doesn't exist Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Ben

You need to examine the shapesheet for the 3D computer shape to find out what is the property before you can work out whether it should work or not. Each shape you use will need to have that same property name if you want the same callout formula to work for each.

Do you know how to look at a shapesheet?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 07-11-2020, 02:31 PM
BenMcLean BenMcLean is offline =CALLOUTTARGETREF()!Prop doesn't exist Windows 10 =CALLOUTTARGETREF()!Prop doesn't exist Office 2016
Novice
=CALLOUTTARGETREF()!Prop doesn't exist
 
Join Date: Jul 2020
Posts: 5
BenMcLean is on a distinguished road
Default

Yes I did look at the ShapeSheet.

I've been using "Prop.IpAddress" as an example but none of the properties work.
Reply With Quote
  #8  
Old 07-11-2020, 06:03 PM
Guessed's Avatar
Guessed Guessed is offline =CALLOUTTARGETREF()!Prop doesn't exist Windows 10 =CALLOUTTARGETREF()!Prop doesn't exist Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The capitalisation of the property name doesn't seem to matter on my machine. Can you post a sample of Visio file with some examples of your shapes and callouts?

Are you using the Insert > Callout to add the callout?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #9  
Old 07-13-2020, 06:58 AM
BenMcLean BenMcLean is offline =CALLOUTTARGETREF()!Prop doesn't exist Windows 10 =CALLOUTTARGETREF()!Prop doesn't exist Office 2016
Novice
=CALLOUTTARGETREF()!Prop doesn't exist
 
Join Date: Jul 2020
Posts: 5
BenMcLean is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
Are you using the Insert > Callout to add the callout?
I think that was the problem.

When I looked at it today, I found that callouts from Insert > Callout work while callouts from Shape > Callout don't work. That's insane. Why the hell would Microsoft do this?
Reply With Quote
  #10  
Old 07-13-2020, 04:00 PM
Guessed's Avatar
Guessed Guessed is offline =CALLOUTTARGETREF()!Prop doesn't exist Windows 10 =CALLOUTTARGETREF()!Prop doesn't exist Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Visio is a voyage of discovery for me and I am not surprised that there are loose ends in how it works with callouts. I presume there is a difference in the shapesheets for a connected and non-connected connectors which might be the difference between the field working and not.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Detecting that previous character doesn't exist (i.e., present character is first in document) Robert K S Word VBA 15 08-01-2016 09:33 AM
INCLUDETEXT is file doesn't exist neoported Mail Merge 2 07-21-2016 11:47 PM
creating a new drawing guide when none exist inglisway PowerPoint 4 04-18-2013 05:02 AM
=CALLOUTTARGETREF()!Prop doesn't exist Pack and Go: Does it Exist in PPT 2010? tatihulot PowerPoint 1 11-16-2010 08:35 AM
normal template does not exist nwhittak Word 1 10-19-2010 07:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft