News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

adding together shape data values

Started by miless2111s, March 30, 2016, 05:05:29 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

miless2111s

I am attempting to add together the values in different shape data fields within the page's shape data field.  However I am obviously doing something wrong...

In the page's shape data field in the shape sheet (Prop.Row_1) I am attempting to call the same field from CheckBox125 with the formula:
=checkbox.125!Prop.Row_1

It keeps saying that there is a problem with the formula....   What have I got wrong?

I tried this in another rectangle and it worked so is there something different about the page compared to a shape?

Thanks

Miles

vojo


miless2111s

#2
blast!  Thanks :)

Edited - nope - still didn't work :(  - tried: =checkbox.125!Props.Row_1

Surrogate


wapperdude

A page's shapesheet is kinda finicky...it probably doesn't like the name Checkbox.125.

In V2007, select the Checkbox shape, then gto Format>Special.  You will see various ID's for the shape.  The 1st entry is the shape ID the page recognizes...might be "29" or whatever number.  Use that number, e.g., sheet.29!prop.row_1. 

Wapperdude

Visio 2019 Pro

Browser ID: smf (is_webkit)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 217 (show)
Files included: 32 - 1207KB. (show)
Memory used: 1115KB.
Tokens: post-login.
Cache hits: 13: 0.00127s for 26,766 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]