Superscript in Web i

building reports webintelligence
1

Hi

I want to create a local variable which has a superscript

=“MyHouse™”

Here TM should be Superscripted.

Can i do this? How.

Thanks!

Asim

asimmunshi :us: (BOB member since 2003-06-03)

2

Since you are using webi XI (and I am not at the moment), I can’t tell you if it has a font format option for superscript.

However, since you are using webi, you could create an object that contains html tags that do the superscript for you (and dont’ forget to set the properties of the cell to be “read as html”).

e.g.

="MyHouse<sup>TM</sup>"

HTH,
Pete

Peter Hughes :uk: (BOB member since 2005-11-21)

3

Hi i tried copying this and putting this in a cell with preference of html.
It does not seem to work. Any suggestions?

antzcp04

antzcp04 (BOB member since 2006-08-04)

4

Hi antz in the pants…

What you can do is create a variable ="MYHouse then while depressing ALT key enter 0153 then " it should show like this MyHOuse™

tombabauts (BOB member since 2006-10-11)

5

thanks - all who replied.
You can achieve superscripting TM using the ascii code. TM is a part of the ascii char set :slight_smile:

However html code formatting does not migrate to PDF. If you put in html code in a cell and save a report as PDF – you actually see the html code.

so you cannot achieve any other superscripting say for eg. BOBJ with the letters SM superscripted — To be precise, you can achieve it using HTML but it will not migrate to PDF properly.

This is currently a limitation with no workarounds.

asimmunshi :us: (BOB member since 2003-06-03)

6

Asim, glad you found a solution “eventually” … perhaps we could have gotten there quicker had you mentioned you were trying to output to PDF in the first place :wink:

Pete

Peter Hughes :uk: (BOB member since 2005-11-21)

7

Hi,

I Have XI R2 SP4 and Superscript works in Webi.

Viewing: =“MyHouseTM” does work.

Viewing after exported it to in PDF does not work!

Is there for the PDF problem already a solution?
:expressionless:

TurningPointHolland :netherlands: (BOB member since 2006-09-06)

8

Have you solved your problem.

I m facing the same one too.

Regards,

zizou :tunisia: (BOB member since 2008-07-31)

9

No, not yet…
I am working for another customer and I am not using this anymore so I really do not know the answer… :roll_eyes:

TurningPointHolland :netherlands: (BOB member since 2006-09-06)

10

HTML fields don’t get converted in WYSIWYG format when exported to PDF.

Just done a test on BOXIR3.1 and if you use HTML tags in a formula then the HTML tags are output as plain text in the PDF document.

However if you use the previously mentioned suggestion of holding down ALT key whilst typing in 0153, it produces the ™ symbol from the ASCII character set and this DOES output correctly to PDF.

HTH,
Pete

Peter Hughes :uk: (BOB member since 2005-11-21)

11

I just tried it and it looks intresting. Now the character I want to show in exponent is “e”. Is there a table that tells me where can I find the right code for it.

Regards,[/quote]

zizou :tunisia: (BOB member since 2008-07-31)

12

ALT+0153 = ™ (according to my computer)

However if it doesn’t work on yours then it may be due to regional settings (language/font selection).

You can find the equivalent codes in the Windows application called Character Map (which can be found in Start > Programs > Accessories > System Tools).

Regards,
Pete

EDIT: sorry, didn’t quite read you question correctly … to elaborate …
™ is part of the standard ASCII character set, a superscript “e” (which you asked for) doesn’t appear to be … or if it is, then it may belong to a different character set (one that probably isn’t installed on your BO server and so isnt’ available to use in reports).

Peter Hughes :uk: (BOB member since 2005-11-21)

13

Found the table :slight_smile: I can find the alt+number for the tm character but for the e character there is no alt+number :frowning:

Thanks for help :slight_smile:

zizou :tunisia: (BOB member since 2008-07-31)

14

Hi
I am alos facing the same error. Please any one can guide me where can i find the table which consits all the ASCII value.

Ex: In our previous replays people are saying alt +0153 to get TM as a subscript, in that same i have to implement couple of subscripts in my current project.

Please any one can guide me where can i find the table.

Thanks in advance

Thanks
Bigboss

bigboss (BOB member since 2011-03-04)

15

The “TM” is not a superscript, it’s an ASCII character. The fact that it’s displayed ™ is because that’s the way the character set is defined. There aren’t any subscript options that I am aware of. Use your favorite search engine to find ASCII tables; they’re all over the place.

Dave Rathbun :us: (BOB member since 2002-06-06)

16

thanks but i didnt get you what you mean by

“Use your favorite search engine to find ASCII tables; they’re all over the place.”

please can you guide me how and where can i find the ASCII Table.

thanks in advance

thanks
bigboss

bigboss (BOB member since 2011-03-04)

17

Go to Google
Type in ASCII Table
Go :slight_smile:

An ASCII table is just a list of what characters have which numeric codes. For example, as mentioned earlier, the ™ is character 153. An ASCII table will show you what the other options are.

Dave Rathbun :us: (BOB member since 2002-06-06)

18

To add a superscript in webi reports I generated superscript from wesite


and concatenated with the other text in the formula editor
="Test " + “²”

Krithi_chandu (BOB member since 2005-10-13)