Microsoft Visio "IF" Function In ShapeData/Format

Alex 20 Reputation points
2024-09-26T13:04:11.4366667+00:00

Hi everyone, I'm trying to insert a formula into ShapeData/Format, but for some reason Visio automatically puts quotes making the formula a value, it pisses me off because last time it worked, what's the bug?

User's image

Visio
Visio
A family of Microsoft products used to create diagrams and vector graphics.
102 questions
0 comments No comments
{count} votes

Accepted answer
  1. Jiajing Hua-MFST 12,400 Reputation points Microsoft Vendor
    2024-09-27T06:45:20.0666667+00:00

    Hi

    Could you please go to File > Account, check the version name under "Product Information"?

    Does this issue occur with other Visio drawings?

    On my environment, there are no quotes added for IF function automatically.

    User's image

    If you click "Edit Formula", what will do you find? It could be that the formula itself is considered a value by Visio.

    I suggest you modify the formula to have a check, using the format in list instead. For example, if the data type is Number, using "#,#### u" or "0" instead.

    User's image

    You may also modify the "list" value from "Prop.ELS.Promat" to others for a test.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.