cancel
Showing results for 
Search instead for 
Did you mean: 

Inserting blank space in table column

Former Member
0 Kudos

Hi,

I'm trying to create some webi reports for the ipads and since they get automatically formatted, some of the things are not looking quite right.

Two scorecards or essentially tables don't have their columns aligned due to the length of text in each column. Please see the screenshot below.Since

the maximum length of the text in the the AREA column of the first table is 8 letters and the same for SBU column in the second table is 6, die to which the tables are appearing misaligned.

As a work around to this problem, I was hoping I could add blank spaces to the "SBU" heading so that the column width changes. Unfortunately, when I do so by adding blank spaces in character values or by simply by typing out spaces, I see "&nbsp" values instead of the blank spaces I expected.

Is there any way I can insert blank spaces in webi reports for ipads ?

Any suggestions will be much appreciated!

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Sakshi,

You can probably try this if possible:

Right Click on column header (where you are putting space) --> Go to Format Cell --> General tab and set the Property under Display as "Read content as HTML" or "Read content as Hyperlink" and check it it helps.

Regards,

Yuvraj

Former Member
0 Kudos

Hi Sakshi,

Try creating a variable with some blank value

Add it to the table and create a break on it.

Have the break footer and hide the column.

Remove the borders for the footer cells.

You would get the blank space after the table.

Regards

Sri Harsha

amitrathi239
Active Contributor
0 Kudos

Hi,

How are you inserting space in cell?

like ="  "+[Object]

what is the column display format as "read Content as Text/HTML" ?

Amit

Former Member
0 Kudos

Hi Amit,

Yes, I'm inserting space as you have mentioned.

Column Display format is Text

amitrathi239
Active Contributor
0 Kudos

Hi,

Have you tried with variable instead of putting direct formula in column.is it working fine in webi?

Amit

Former Member
0 Kudos

No, I just tried using a variable. Doesn't work that way either.

The same " " characters come up on the ipad

amitrathi239
Active Contributor
0 Kudos

Hi,

try with this.Char(32) for one space..

=Char(32)+Char(32)+([Object])

Amit

Former Member
0 Kudos

Nope, I see the same "&nbsp" character as before.