News:

Happy New Year!

Main Menu

Horizontal misalignment with ShapeText()

Started by Machine, April 08, 2020, 08:38:11 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Machine

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)

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 136 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1045KB.
Tokens: post-login.
Cache hits: 13: 0.00155s for 26,615 bytes (show)
Cache misses: 2: (show)
Queries used: 15.

[Show Queries]