How to represent the square character - superscript

building reports desktopintelligence
1

Is there any way to write m2 in a cell, but representing the 2 like a superindex? I mean, the typical representation of square units.

Thank you

barni07 :es: (BOB member since 2004-07-28)

2

Do you want to represent like this 2² then BO doesnot support superscripts…but the workaround would be to create it in a Word document and paste it in your Business Objects report…I think you need it just in the header part…If it is for a column data then would be difficult…

mayur :india: (BOB member since 2004-07-22)

3

A useful discussion here

Nick Daniels :uk: (BOB member since 2002-08-15)

4

Another work around…if it is a column data.The vertical and justify settings of the columns works here.Checkout the attachment…
Superscript.rep (45.0 KB)

mayur :india: (BOB member since 2004-07-22)

5

Thank you guys. We just need to write ALT+0178, and it works.

I was at the wrong place in the charmap …

barni07 :es: (BOB member since 2004-07-28)

6

what do you mean by ALT+0178…? can you please explain in detail…

mayur :india: (BOB member since 2004-07-22)

7

I meant that you can write in a cell ALT+0178. By doing this, you’re typing the unicode character with code = 178.

If you’d just type ALT+178, you’d get the 178 ASCII character.

barni07 :es: (BOB member since 2004-07-28)

8

In BO there is a ASC function which returns the ASCII value of a character but ALT+178 doesnot work,Can you please let us know how you used this function to represent---->2²

mayur :india: (BOB member since 2004-07-22)

9

Hi Mayur,

try this in the single cell:


=Char(50) & Char(0178)

Marek

Marek Chladny :slovakia: (BOB member since 2003-11-27)

10

Marek,

Thanks for the reply

Mayur

mayur :india: (BOB member since 2004-07-22)

11

There’s no need of using functions. You can write that character the same way as you’d write any other ascii character. Press the ALT key, and then type 0178. Then release the ALT key.

That works for me

Good luck!

barni07 :es: (BOB member since 2004-07-28)

12

What about Web Intelligence and special characters, I need an Up and down Arrow for a Web Intelligence report in XIR2?

David Smith :us: (BOB member since 2002-07-10)

13

I don’t know about webI But in Full client you can set font as Wingdings3 to show arrows in your report . increase you font size to inlarge arrows.
All of them are in small letter. If you want double liner arrows then press Caps lock.
g = Horizontal right
h= vertical up
i= vertical down
f = Horizontal left

kool :nepal: (BOB member since 2005-04-15)