Is there a way to determine from the shapesheet whether a data graphic has been applied to a shape? Specifically, I'm trying to determine whether a color by value DG has been applied. I know that color by value creates Uesr.visDGCBVFill and then deletes it when you remove the DG. It would be logical to test for existence of that cell, but there is no CELLEXISTS() function in the shapesheet. I tried using FORUMULAEXISTS(User.visDGCBVFill) but as soon as I remove the DG, this becomes FORMULAEXISTS(REF()). I also tried a forumula David Parker posted a year ago in response to a similar question: =1+ABS(NOT(ISERR(INT(INDEX(0,"User.visDGCBFill"))))) but this always returns a value of 1. Other suggestions?
Hi, Scott. If the shape has DataGraphics, shapesheet has User.visDGDisplayFormat cell. -- JuneTheSecond Now, visual calculation is more visual. http://www.geocities.jp/visualcalculation/english/index.html
> If the shape has DataGraphics, > shapesheet has User.visDGDisplayFormat cell. Even so the problem still remains: there is no cellexists() function in the shapesheet. So how do I determine from the shapesheet whether a particular cell exists?
I think there is noway in shapesheet. -- JuneTheSecond Now, visual calculation is more visual. http://www.geocities.jp/visualcalculation/english/index.html
Actually, this will do it (it should return 1 or 0): =DEPENDSON(NOW())+NOT(ISERR(INT(INDEX(0,"User.visDGDisplayFormat")))) I tried to do it without DEPENDSON()NOW()) at first, but adding/removing did not force re-evaluation "JuneTheSecond" wrote in message news:09079C58-7DF4-403C-9BAF-C529173B9257@microsoft.com... >I think there is noway in shapesheet. > -- > JuneTheSecond > > Now, visual calculation is more visual. > http://www.geocities.jp/visualcalculation/english/index.html > -- David Parker Microsoft MVP (Visio) http://bvisual.spaces.live.com http://www.visualizinginformation.com
Excelent! David, you really are! -- JuneTheSecond Now, visual calculation is more visual. http://www.geocities.jp/visualcalculation/english/index.html
However, I do not recommend using NOW() too often becaue it continuously fires. It would be better to point DEPENDSON() at some cell whose value you know is likely to change. "JuneTheSecond" wrote in message news:E2599FE7-A7E8-470E-91C7-34CA3E8D0723@microsoft.com... > Excelent! David, you really are! > -- > JuneTheSecond > > Now, visual calculation is more visual. > http://www.geocities.jp/visualcalculation/english/index.html > -- David Parker Microsoft MVP (Visio) http://bvisual.spaces.live.com http://www.visualizinginformation.com
