Microsoft Visio "IF" Function In ShapeData/Format

Question

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?

Answer 1

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.

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.

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.

---