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

Sheet names cause errors when making changes to shapesheet?

Started by Michelle, March 11, 2009, 02:45:30 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Michelle

Not sure if this is a bug or something I'm doing wrong, but it seems weird...  Here's an example.  I have this bit of instruction in a cell of the Shapesheet:

=OR(NOT((Pages[Page-1]!Excel.8!Prop.InsideWidth>18 ft 10 in)),((Pages[Page-1]!Excel.8!Prop.InsideDepth>18 ft 10 in)))

but it doesn't work quite right, so i want to make a change, say the dimension or maybe even as simple as changing the >'s with <'s.  When I do so, the whole statement comes back with an error.  The problem seems to be my sheet names.  If I go in and also change the "Excel.8!" with "Sheet.8!" in each instance the statement works. 

I don't know if it makes any difference, but the "Excel.8!" changed itself to that once I hit enter, as that is the name of that sheet.  I originally entered it as "Sheet.8!"

Is it a bug or do I have a setting or configuration somewhere making this happen?

just curious,
Michelle

wapperdude

Yeah.  I've seen that behavior before.  It's similar to my post in Visio Bugs: Formula Error: Basic Flowchart shapes on different pages, http://visguy.com/vgforum/index.php?topic=620.0



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: 156 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1052KB.
Tokens: post-login.
Cache hits: 13: 0.00166s for 26,766 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]