英文:
How to let visio shapes change behaviour from their text?
问题
我有一些形状，它们应该根据它们的文本更改行为。
文本字段使用=GUARD(TEXTWIDTH(TheText)) 可以很好地更改它们的高度和宽度。
但是当我尝试像这样更改颜色=THEMEGUARD(IF(LEN(TheText)>3,RGB(255,112,192),RGB(0,112,192))) 时，当您更改文本时什么都不会发生。
关于如何让 Visio 实际运行这个功能，或者我在这里做错了什么，有什么想法吗？
英文:
I have shapes that should change behaviour on the basis of their text.
Text fields change their height and with using =GUARD(TEXTWIDTH(TheText)) just fine.
But when I try to let something change color like this =THEMEGUARD(IF(LEN(TheText)>3,RGB(255,112,192),RGB(0,112,192))) nothing happens when you change the text.
Any ideas on how to get visio to actually run this like it should? Or am I doing something wrong here?
答案1
得分: 2
请尝试添加SHAPETEXT函数。
具体语法如下：=THEMEGUARD(IF(LEN(SHAPETEXT(TheText))>3,RGB(255,112,192),RGB(0,112,192)))
我在我的端口检查了这个公式，它有效！
英文:
> Or am I doing something wrong here?
Please try add SHAPETEXT function.
With syntax like =THEMEGUARD(IF(LEN(SHAPETEXT(TheText))>3,RGB(255,112,192),RGB(0,112,192)))
I check this formula at my side, it works!
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论