Posted 8 October 2018, 11:04 pm EST
Hi,
I am trying to display text with some spaces at the right of the text using TypeHAlign and I noticed that spaces are ignored.
Is there a way that the spaces are not ignored?
Yiannis
Forums Home / Spread / Spread COM
Posted by: yianeco on 8 October 2018, 11:04 pm EST
Posted 8 October 2018, 11:04 pm EST
Hi,
I am trying to display text with some spaces at the right of the text using TypeHAlign and I noticed that spaces are ignored.
Is there a way that the spaces are not ignored?
Yiannis
Posted 10 October 2018, 8:41 pm EST
Hi Yiannis,
Please make sure that width of the Text is not as same as the column’s width. You must have some space in cell in order to move the text right, left or in center.
Please refer to the attached sample application.
Thanks,
Deepak SharmaSpreadComTextAlignment.zip
Posted 18 October 2018, 3:21 pm EST
I think you have missunderstood my question.
Let me explain again the problem.
I want to display and align to the right the text "Test " (word Test with 3 spaces).
The 3 spaces at the end of the text are ignored when aligning the text at right.
Is there a way to keep those 3 spaces?
Regards
Yiannis
Posted 22 October 2018, 6:13 pm EST
Hello Yiannis,
It seems to be working absolutely fine at my end. Please take a look at the attached image and sample application.
Thanks,
Deepak Sharma
Posted 22 October 2018, 6:14 pm EST - Updated 30 September 2022, 3:10 am EST