• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • Visio Shape Report Converter
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network
You are here: Home / Visio / Testing Regional Settings in Visio

Published on May 21, 2021 by David Parker

Testing Regional Settings in Visio

There are times that I have been caught out by assuming that everyone speaks “proper” English, like what I do (sic), and forgetting that there are other languages with their own formatting conventions. I think most of the world is bemused at the USA date format where they put the month before the day and the year. So illogical to everyone else, and I can’t help thinking that it was done on purpose just to catch us Brits out, like when they decided to drive on the wrong side of the road just to make it more difficult to sell cars across the border. It seems that some parts of Visio get confused if I enter the dates in the correct “dd/mm/yyyy” format, so I now type dates in the “d mmm yyyy” format in the Shape Data window calendar control because, at least, that always works. Also Visio‘s internal units are inches, and every time I see it referred to as US Units, rather than the Imperial Units that I grew up with, makes me think “so, this is what it has come to!”.

So today I was embarrassed by a Norwegian client because I forgot (again) to take extra care when using the RGB(…) function. The result was that the displayed colours were appearing black in Norwegian (and doubtless many other languages), but correctly grey (gray if you are in the USA), blue, green and yellow in English (both UK and US).

If you examine the images above, you will see that the User-defined Cells for each named colour are displaying the RGB function with the numbers separated by a comma. That much is correct, but the User.Color value is 181, which is only the second number of the User.CenikaLayoutColorGray value, RGB(177,181, 190). So, what is happening?

Firstly, the number 181 is way above any value of the index of the 24 default colours available to the FillForegnd cell, so it displays as black. Secondly, it is splitting the values on the commas, so I need to explain why.

The user selects in the fixed-list Prop.Type Shape Data row. The choices are stored as semi-colon separated values in the Prop.Type.Format cell (Grey;Blue;Yellow/Green):

="Grå;Blå;Gul/Grønn"

The default list separator for Visio is the semi-colon, and the default formula in the Prop.Type.Value cell updated by the selection in the drop-down is:

=INDEX(n,Prop.Type.Format)

where n is inclusively between 0 and 2.

The User.TypeIdx cell has a formula:

=LOOKUP(Prop.Type,Prop.Type.Format)

This correctly returns a value between 0 and 2, which is then used to get the corresponding RGB value in the User.Color cell:

=INDEX(User.TypeIdx,RGB(177,181,190)&";"&RGB(0,130,200)&";"&RGB(0,176,80))

This is a construct that I do frequently, but it ignores the fact that many languages use the semi-colon as a list separator.

To test this, I only need to change the Settings / Regional Format to a suitable non-English language, like Norwegian.

Then I can test the effect it has on this formula in Visio. The answer is to use any suitable character, such as the pipe character, to separate the individual colours in the list, and then specify that character in the optional third parameter of the INDEX(…) function:

=INDEX(User.TypeIdx,=INDEX(User.TypeIdx,User.CenikaLayoutColorGray&"|"&User.CenikaLayoutColorBlue&"|"&User.CenikaLayoutColorYellow,"|")

which evaluates to:

=INDEX(User.TypeIdx,RGB(177,181,190)&"|"&RGB(0,130,200)&"|"&RGB(0,176,80),"|")

So now everything looks ok, and the value of the User.Color cell displays with semi-colon separators in Norwegian, but with comma separators in English:

Notice how the values of the named color rows still display with comma separators above. This is because these rows are not string values, but the User.Color value is a string that is evaluated.

So now the user can select the colour choice in the Shape Data window, and everything displays correctly, regardless of the language.

All I need to do now is to remember this next time!

Testing Visio shape text for WCAG 2.0 pass

The Web Content Access Guidelines (WCAG) 2.0 provides the current recommendations for making web content accessible to users with vision impairment, but how do you test if your Visio shapes pass?

SharePointColumnColourFormat

Formatting SharePoint Columns with RGB Color

Learn how to format SharePoint list columns with RGB values

Vsio Standard Colors

Ensuring High Contrast Text in Visio Shapes

Learn how to write a ShapeSheet formula to ensure high contrast of text on a shape background fill for visibility accessibility

Understanding Visio’s Color Formulas

I was recently exploring the ShapeSheet formulas available in Visio that affect colors, and I decided that I needed to make a shape that I can change the fill color, tint, shade and tone of dynamically. This allows me to copy the formulas from a Shape Data row value for pasting into a ShapeSheet cell.…

Displaying the Fill and Line Section Values of a shape

A few years ago, I wrote an article about displaying the RGB value of shapes ( see http://blog.bvisual.net/2010/04/22/displaying-the-rgb-values-of-shapes ). I had forgotten about it, but a reader recently asked if it was possible to force the Foregnd field to display the RGB value for the standard color palette values. For example, red is number 2…

Displaying the RGB values of Shapes

Everyone knows that you can change the colour of Visio shapes.  Most people know that you can also change the fill pattern too. (more…)

Related

Filed Under: Color, Shape Data, ShapeSheet Formulas, Visio Tagged With: ShapeSheet Functions, Visio

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Themes Validation VBA Video Visio Visio 2007 Visio 2013 Visio for the Web Visio Online Visio Services Visio Viewer Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • LinkedIn
  • Twitter

Search this website

Recent posts

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

Copyright © 2023 · Executive Pro on Genesis Framework · WordPress · Log in