Text Box - Auto removal of extra space

Highlighted
Community Boss

Text Box - Auto removal of extra space

Hi Team,

 

I have a text box on a Dashboard and I want to line up the sentences in a vertical manner and to do so requires me to add spaces in certain rows so they line up vertically. Anaplan is auto removing these spaces when I click out of the text box

 

Is there anyway to override this function?

 

Thanks

 

Mark

16 REPLIES 16
Highlighted
Valued Contributor

Re: Text Box - Auto removal of extra space

Hi @MarkTurkenburg 

 

Have you tried using the “invisible character” instead of spaces?

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Community Boss

Re: Text Box - Auto removal of extra space

Hi @einas.ibrahim 

 

What's the 'Invisible Character'? I'm intrigued 🤔

Highlighted
Super Contributor

Re: Text Box - Auto removal of extra space

Hi @MarkTurkenburg 

 

To add a new line in text box - press ctrl + alt + Enter

 

Note: Use left portion (ctrl and alt) of your keyboard, not right portion.

 

Capture.JPG

 

Thanks,

Sorna Raja Prabhu
Highlighted
Certified Master Anaplanner

Re: Text Box - Auto removal of extra space

Hi @MarkTurkenburg 

Is your end goal to have multiple lines separated by line breaks? If that is the case, the below solution might help.

Let's say, you have two line items - Text 1 and Text 2. Create a line item called New Line to be able to use the line breaks.

The "New Line" line item is important and is configured in a certain way.

In this line item, write in the text box (and not in the formula) like below, any character can work but make sure to have a line break:

Screenshot 2020-06-22 at 12.26.43 PM.png

Then use the following formula in the line item where you need to combine multiple line items:

'Text 1' & MID(New Line, 2, 1) & 'Text 2'

 Let me know if this helps.

Thanks
Anik
Highlighted
Community Boss

Re: Text Box - Auto removal of extra space

Thanks @Sorna Raja Prabhu  & @einas.ibrahim  but I meant adding in extra spaces when entering text like below into a text box

 

Whenever I enter more than 1 space between words it snaps back to just 1 space when you click outside the text box

 

 

IMG2.PNG

Highlighted
Certified Master Anaplanner

Re: Text Box - Auto removal of extra space

@MarkTurkenburg  Anaplan will treat consecutive spaces as one in the text boxes and will snap back. If you want it to come on the new line, use the carriage return like someone mentioned previously on the thread. Unfortunately, as far as I know, there is not a fix for this.

Thanks
Anik
Highlighted
Community Boss

Re: Text Box - Auto removal of extra space

Thanks @anikdas 

 

I know to how to drop down a line but I wanted to line up certain items vertically and hence required different lines to have more than 1 space but looks like it is not posisble

 

 

Highlighted
Valued Contributor

Re: Text Box - Auto removal of extra space

@MarkTurkenburg 

 

Is this what you were looking for?

 

image.png

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Community Boss

Re: Text Box - Auto removal of extra space

Yes @einas.ibrahim!

 

That's exactly what I'm after - how did you do that?

 

Thanks

 

Mark