shapesheet and shape date fixed list

[shinji7800]

Hi everyone !

I would like to create a master shape with a simple functionality.

a growing rectangle proportional to a shape data value. (and some other features like let appears some other shapes)

I start with create a shape data entry, on the "grouped" object  : fixed value -> format 1;2;3;4;5;6;7;8 (value must be greater  or equal than 1 and less or equal than

so in my "child shape" in width cell, I planned,  to use "sheet.49!Prop.nbInt.value" to make an arithmetic operation 15 + (( sheet.49!Prop.nbInt.value - 1 ) * 20)


but it doesn't work as expected ...


so I isolate "sheet.49!Prop.nbInt.value" to try to understand why ...

so I put "sheet.49!Prop.nbInt.value" as custom formula in a text area for displaying "live value" and use sheet.49!Prop.nbInt.value as width formula:

in the text area I have the expected values (1 to

but in width cell I have  25.4 mm when sheet.49!Prop.nbInt.value equal 1 and 203,2 mm when props equal 8 ...


if I understand well my expected value is always multiplied by 25.4  but in text area the value is not "transformed"


really strange for me


please find a YouTube link https://youtu.be/f9Nz7pgAZQo(I can provide a google Drive link to if you prefer), for, I hope, allow you, a better understanding of my issue.


please forgive my approximate English I am french

best regards
 

[Surrogate]

make an arithmetic operation 15 + (( sheet.49!Prop.nbInt.value - 1 ) * 20)

In visio default unit is inch, not mm.
May be i dont understand you, because i am russian.

[Thomas Winkel]

Possible solutions:
* Convert from mm to inch in your formula
* Explicit unit in Witdh cell: =Sheet.49!Prop.nbInt & "mm"
* Define your fixed list with units ="1mm;2mm;3mm;4mm"

Btw.
You may want to protect your formula from destruction by user drag & drop actions: =guard(Sheet.49!Prop.nbInt & "mm")

[shinji7800]

perfect ! 

it was simply this ... I so frustrated to lost so much time and the automatic "mm" after 25.4 misled me


thanks a lot ...

[Surrogate]

sorry for off-topic

if Pinx = sheet.1000!pinx + 10mm....that shape can end up in Andromeda
    not consistant in same location when done several times
    (copy, exit, don't save changes, open, copy, exit don't save changes,etc)

if Pinx = guard(sheet.1000!pinx + 10mm)....copy is as predicted.
...
just a heads up.ion