cancel
Showing results for 
Search instead for 
Did you mean: 

Input Text Area formatting?

Former Member
0 Kudos

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:

Hello,

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: http://img651.imageshack.us/img651/9484/asdfjuj.jpg

(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)

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

I don't think SUBSTITUTE is supported, have you checked? Make sure that you export the file to swf to test.

Former Member
0 Kudos

You're correct, Substitute() is not supported. I have a new thread better explaining my help request after further analysis on this issue so I will be closing this one.