Author Topic: Horizontal misalignment with ShapeText()  (Read 7800 times)

0 Members and 1 Guest are viewing this topic.

Machine

  • Jr. Member
  • **
  • Posts: 18
Horizontal misalignment with ShapeText()
« on: April 08, 2020, 03: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:
Code
=SUBSTITUTE(SHAPETEXT(Sheet.1!TheText),CHAR(13),"")

Visio 2019
1907 (11901.20176)