News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

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: 132 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1045KB.
Tokens: post-login.
Cache hits: 13: 0.00131s for 26,767 bytes (show)
Cache misses: 2: (show)
Queries used: 15.

[Show Queries]