mardi 24 novembre 2015

Preserve References in Visio (2010) Shapesheets

I have put together a function in a ShapeSheet to allow my users to right click an object & select from prederermined colours.

Along with Actions & Scratch, The "FillForeground" in the ShapeSheet entry reads:

=IF(Scratch.A1=1,Sheet.1!Scratch.A1,IF(Scratch.A1=2,Sheet.1!Scratch.B1,0))

For the purpose of this question, I can simplify this function & just have a single colour:

=Sheet.1!Scratch.A1

Which contains the value RGB(255,0,0)

If want Blue instead of Red, I simply change RGB(255,0,0) to RGB(0,0,255) in the object 'Sheet.1' which changes my Red to Blue on the object with all the Actions, Scratches & FillForeground workings. All fine there.

Now, if I try to copy & paste my object (The one with the selectable colours), it loses it's references to the object containing my colour values. The above line, changes to:

REF()

The full line would look like this: =IF(Scratch.A1=1,REF(),IF(Scratch.A1=2,REF(),0))

Of course, the also happens when I bring pages into the mix:

=IF(Scratch.A1=1,Pages[Defaults]!Sheet.1!Scratch.A1,IF(Scratch.A1=2,Pages[Defaults]!Sheet.1!Scratch.B1,0))

Becomes:

=IF(Scratch.A1=1,REF(),IF(Scratch.A1=2,REF(),0))

Ultimately, I'd like a single object containing my colours on it's own page which I can hide. If I need to change those colours altogether. I would change this 'master' object & have all of my objects objects change across the document.

Does anyone know how I might be able to preserve those references which are changing to 'REF()'?

Aucun commentaire:

Enregistrer un commentaire