BusinessObjects Board

Rotating a cell from horizontally to vertically

building reports desktopintelligence
#1

Does anyone know how to rotate a cell from horizontally to vertically? I need the text to be in this format “Hello” and not
H
E
L
L
O.

Any ideas?

Thanks.

BO808 (BOB member since 2002-10-14)

Text orientation using Visual Basic
Formatting Cells to appear vertically instead of horizontall
Rotated Text
#2

is it really vertical? or just wrapping letter at a time?
What happens if you make the column wider?

Chris Pohl :us: (BOB member since 2002-06-18)

#3

I mean rotating a cell 90 degrees.

BO808 (BOB member since 2002-10-14)

#4

Hi BO808, welcome to Bob. I think Chris is wanting you to make sure the cell is really rotated. BO always brings in text horizontal not vertical. If the wrap setting is on and the cell is too narrow it will make it look vertical like that.

Unless this is on a chart, like the y axis.

Scott Bowers :us: (BOB member since 2002-09-30)

#5

Thanks for your reply. I think there is a miscommunication going on. Wrap setting is off and the cell has been expanded to fit the wording horizontally.

Like “Hello, Welcome to BOB”

I need to take this cell and rotate to 90 degrees. So, I can use this as a description for my secondary Y-axis.

BO808 (BOB member since 2002-10-14)

#6

Just to clarify, you have a chart and you want your secondary Y- Axis to have a title and you want it Horizontal, or Vertical? Or are you talking about the labels on the Secondary y-axix?

Scott Bowers :us: (BOB member since 2002-09-30)

#7

I think if you want it vertical you need to turn on wrap text and narrow the cell until it looks vertical. Or, you can create a formula that is basicly this:


="W" & Char(13) & "e" & Char(13) & "l" & Char(13) & "c" & Char(13) & "o" & Char(13) & "m"& Char(13) & "e"

Hope this helps.

Scott Bowers :us: (BOB member since 2002-09-30)

#8

Thanks, but that is exactly what I did not want.

BO808 (BOB member since 2002-10-14)

#9

There is no way “currently” to rotate the text (a la Excel). You are always left with the Characters horizontally positioned.

-RM

digpen :us: (BOB member since 2002-08-15)

#10

Thanks. I thought so.

BO808 (BOB member since 2002-10-14)

#11

You can, however, rotate an official chart axis. It sounds like what you have is a separate cell. If you can use a chart axis, then you can right-click on the axis lable and rotate it any which way you want. :slight_smile: The problem is your data has to be in the chart for that to happen…

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

#12

What if you found a Font that was already rotated?
One example (fontdemo.zip) is available at;

http://www.xpertss.com/cgi-bin/webdata_freebies.pl

This has a rotated Ariel font, flipped on it’s back. Copy arielr.ttf into your windows/fonts folder and re-boot.

I went looking for a cheap/shareware font editor, too. See an example at;

or another at;
http://users.iclway.co.uk/l.emmett/

SG1_Guy (BOB member since 2003-02-28)

Writing vertically
Display text of column in vertical orientation
Text orientation in a cell
#13

That’s a cool idea. :slight_smile: You would have to distribute the font everywhere the report might be viewed, and Unix servers might be a problem, but I had no idea such a thing existed. 8)

Dave

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

#14

OK, this time I actually tried the thing first…

To install the font Arielr.ttf, you might already know you have to do better than just copy and reboot… You have to “install” the font. UnZip the ttf file, just about anyplace will do. Then in Windows Explorer, select the Windows Fonts folder (C:\Winnt\Fonts in NT). Click File, and select Install New Font. Guide it to the ttf file, and let 'er rip. THEN you have to reboot.

You also have to spell your words backwards to make them readable in Vertical mode. Flipped on their Back, like they are, the word looks really bad otherwise… This was a poor design decision by the font maker, perhaps… But it Does work…

Lower-case needs to be Big, like 12-14 point, to be really readable. Too small, and some letters look wrong. Like, ‘s’ looks like a ‘B’, for example.

Hope it helps. At least it’s a start.

Of course, if you put this in reports, you probably have to make sure all of your users Have the Font…

SG1_Guy (BOB member since 2003-02-28)

How to display chinese characters in BO Full Client Reports?
Adding Fonts for PDF
how can i add arabic font to my report labels
#15

Hi,

Another work-around method would be to create a bmp file with the required text/label flipped to the desired angle (90 degrees in our case).
Insert the picture in the report/chart at the desired location.

Does it make sense. Please let me know.

Regards,
acb

acb (BOB member since 2005-04-06)