Image in excel not coming center of column ,touching column border

[nsaxena]

Hi All ,

PS :Please refer to attached screenshot of HTML and excel output comparison.

I have a report layout in which i am showing different square color boxes as per case condition something like below.The images are appearing correctly in HTML but in excel image are touching the column border.I tried padding etc and increasing the column width but still same output i.e image touching the left boundary of column.

Kindly suggest how to fix excel output so that image comes in center.


case [Report page].[CURRENT_WEEK_POSITION]
when 1 then
'../samples/images/box/green3.jpg'
when 2
then '../samples/images/box/yellow1.jpg'
when 3 then
'../samples/images/box/amber1.jpg'
when 4 then '../samples/images/box/red1.jpg'
end

[gpollock]

In the report spec, are you setting the columns to center horizontally and vertically?  Not everything translates well into excel.  If you absolutely need your formatting preserved, I recommend using PDF as a format.

[nsaxena]

Hi
Horizantal alignment = Center
and Vertical Alignment= Middle.

I understand that pdf and html are best,but as per requirement we need this report in excel format.

Please suggest anything you to achieve excel alignment of image.

[NIEK87]

The real question here is why do you want to have a dashboard-like report in Excel? If you are showing upwards/downwards arrows, it doesn't add any value to export to Excel.

A really, really dirty solution for your problem though:

• Remove the image
• Add a textbox
• For your upward Arrow, enter number 5. For your downward Arrow, enter number 6
• Set your tekst font to Webdings
• Magic!

[nsaxena]

Hi..

I agree with dirty solution as best option so far,but since my arrows are conditional...
how will i use them in case statement ?

something like
case when
column=abc then display black arrow(webdings)

how to put webdings inside case statement.

[NIEK87]

You can just use:

case
when column='abc' then '5'
when column='def' then '6'
end

Place the data object in your report and set the text font to Webdings.

[Michael75]

You probably want more than just the two values 5 & 6 (up arrow and down arrow). I'm attaching a list of special characters, including those in Webdings, that I picked up off the innerwebs some time ago. I just knew it would come in handy some day :)

[nsaxena]

Hi I tried something like you said a,but neither HTML nor excel is picking up the webdings font..

Can you please check it is working on your end?

Thanks!

[nsaxena]

Hi Michael75,

Thanks for the font translator list...it's indeed helpful and worth saving for future.

:)

And conditional blocks works with web type fonts!!