Recent Posts

Pages: 1 2 [3] 4 5 ... 10
21
I think I might have cracked it.

There is a Protection flag for "LockCustProp" when I set that, Visio no longer overwrites my formulas in custom property formula cells.

Still interested in other approaches to achieve a fixed or variable list imported from a file if you have any...
22
Can you upload an example?
23
It is just a list of text strings names of tools, like "Word", "Powerpoint", and not relevant to the problem. I want this list of string values to be the options for the variable list in the shape property
24
I've linked a sharepoint list (with a  Tools column) to create a dynamic variable list in shape data properties.
Which tools you mean ?
25
I've linked a sharepoint list (with a  Tools column) to create a dynamic variable list in shape data properties. I've imported the external data into visio to expose the data in _VisDM_Tools

In the appropriate shape data Prop.Tools row, I add the =Prop._VisDM_Tools formula which works to provide the variable list in my shape data properties. It works when I've first  typed in the formula, but later the formula gets convereted to a string.
If I make copy of the shape, the formula is then quoted: "=Prop._VisDM_Tools", which is then a string literal and not a formula anymore.
If I create a new master shape of the original shape, and then create an instance in the diagram of the master, the formula is not quoted (and works initially) until I save and re-load the file, then it is quoted and any children I create of the master shape have the quoted version of the formula in the cell, and hence don't work. The variable list is simply the "=Prop.VisDM_Tools"

Not sure what I'm missing here. I tried GUARD and that doesn't prevent the cell getting quoted (including the GUARD call).

Any pointers on how to prevent this, or perhaps a hint about the "right" way to create lists for data shape properties from external data would be  much appreciated.

Richard
26
General Visio / Re: SQRT vs sqrt?
« Last post by Jennifer on July 28, 2020, 01:53:46 AM »
I started to enter a square root expression. I got as far as "=sqrt" and Visio offered me 4 choices
You get really especial Visio for 29$!

I find SQRTPI and IMSQRT in Excel's Worksheet functions. But can't find them for Visio
Oh for Pete's sake. The Alzheimer's is getting a lot worse. This happened in Excel, not Visio. My apologies.  :o :P :-\
27
General Visio / Re: SQRT vs sqrt?
« Last post by Surrogate on July 27, 2020, 11:15:52 PM »
I started to enter a square root expression. I got as far as "=sqrt" and Visio offered me 4 choices
You get really especial Visio for 29$!

I find SQRTPI and IMSQRT in Excel's Worksheet functions. But can't find them for Visio
28
General Visio / Re: SQRT vs sqrt?
« Last post by Surrogate on July 27, 2020, 10:56:07 PM »
Hi, Jenifer!

You mean ShapeSheet function SQRT?
Where you find SQRTPI and IMSQRT?

You can write name of ShapeSheet function in lowercase or uppercase, Visio engine make it to uppercase. You can find same
behavior with MS Excel formulas!
29
General Visio / SQRT vs sqrt?
« Last post by Jennifer on July 27, 2020, 09:55:03 PM »
I started to enter a square root expression. I got as far as "=sqrt" and Visio offered me 4 choices:
  • sqrt
  • SQRT
  • SQRTPI
  • IMSQRT
I understand that SQRTPI and IMSQRT are different functions, but why do I get both a lowercase and an uppercase version? After entering each, they both convert to uppercase.
30
Visio 2019 Issues / Re: Visio 2019 Professional for $29 from KeyMart
« Last post by Jennifer on July 27, 2020, 10:54:29 AM »
Thanks for all tne suggestions
Pages: 1 2 [3] 4 5 ... 10