Visio Guy

Visio Discussions => Visio 2019 Issues => Topic started by: Machine on April 08, 2020, 08:38:11 PM

Title: Horizontal misalignment with ShapeText()
Post by: Machine on April 08, 2020, 08:38:11 PM
It seems ShapeText() adds extra char(13) before char(10) - Carriage Return Line Feed before Line Feed.
That cause each line to shift to the left, which is visible when centered or adjusted to the right.
Looks like only one function cause that problem.
Also it cause Len() function to return incorrect value due to "doubled" new line.

Small temporary fix:
=SUBSTITUTE(SHAPETEXT(Sheet.1!TheText),CHAR(13),"")

Visio 2019
1907 (11901.20176)