Skip to Content
author's profile photo
Former Member

Input Text Area formatting?

Is there any way to save or keep layout formatting of text that is typed into an Input Text Area component on an Xcelsius dashboard?

Basically, i have a 'Submit a Suggestion' area on my dashboard where the user can type in a few sentences and click "Submit". This triggers an email to popup with the Body populated with what they entered. However, if the user inputs something like the following:


I have a suggestion for you.  Please consider...

Thank you!

it will get brought into the email client like this:

Hello,I have a suggestion for you.  Please consider...Thank you!

As you can see, it ignores any type of line break, new paragraph, or carriage return that was entered in the Text Area. If i do a snapshot of my spreadsheet during runtime, it DOES show the text in my desintation cell with the line breaks and new paragraphs. So it looks like the formatting is being held in the cell, but once it's converted into that "mailto:" command it truncates it all together into 1 line.

Anyone know of a solution for this, if it's even possible? I know you can code line breaks in a "mailto:" command by using "%0D" but how can you search a string in an Excel cell for line breaks, what character should I be looking for to do a Replace() function with? I'd appreciate any help, thanks!

Here is an imagine to explain things:

(as you can see, i need to find a way to know where the line breaks are so i can nsert a "%0D" between Line 1 and Line 2 and between Line 2 and Line 3)

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Apr 29, 2011 at 08:16 PM

    I've been doing some research and testing and have come up wtih something 'close' but I will have to work on it some more over the next few days and post back with a solution if I find one.

    It has to do with using a Substitute() function and replacing CHAR(10), which represents the line return, with the return code for the mailto command of "%0D". It's not fully working yet, but I am getting close to creating a working mailto command. Will post back later when I get further with it.

    Add comment
    10|10000 characters needed characters exceeded