Greek Symbols and Square Root Symbol

[E***@upstate.com]

Hi all,

In my excel documents, I can type the character for a square root: ?. This
is without using the Symbol font, just plain old Times New Roman.

Now, I want to generate an Excel document using POI that outputs the ?
square root character. However, whatever I type into my IDE comes out as a
? character. Does POI have any sort of translator?

And, on a related note, in my excel document, I have Greek alpha and beta
characters. Now, the ß (beta) character comes out fine, but I can't seem to
get the alpha character to come out.

By the way, I am on w2k machine and poi 1.5. I saw a post about extended
character issues, is this something that would be fixed if I upgraded?

Eric

[Andrew C. Oliver]

See if this is still an issue in 1.5.1.

Post by E***@upstate.com
Hi all,
In my excel documents, I can type the character for a square root: ?. This
is without using the Symbol font, just plain old Times New Roman.
Now, I want to generate an Excel document using POI that outputs the ?
square root character. However, whatever I type into my IDE comes out as a
? character. Does POI have any sort of translator?
And, on a related note, in my excel document, I have Greek alpha and beta
characters. Now, the ß (beta) character comes out fine, but I can't seem to
get the alpha character to come out.
By the way, I am on w2k machine and poi 1.5. I saw a post about extended
character issues, is this something that would be fixed if I upgraded?
Eric

[E***@upstate.com]

I have made progress on this issue.. The alpha character and the square
root character come out fine. I looked into the FAQ section
http://jakarta.apache.org/poi/faq.html#faq-10 and initially had no luck.
The reason was my Unicode character string was right next to a non Unicode
character.

For alpha (\u03B1)

\u03B12 fails
\u03B1 2 works.

Maybe tweaking the FAQ would help?

However, what I have not had luck in was the section of the FAQ:
//
// for sheet name
//
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet s = wb.createSheet();
wb.setSheetName( 0, "SomeUnicodeName",
HSSFWorkbook.ENCODING_UTF_16 );

I don't see in the javadocs posted on the site (and in 1.5) where this
method wb.setSheetName(...) exists. Is this a 1.8 or CVS head thing?

Eric Pugh

-----Original Message-----
From: Andrew C. Oliver [mailto:***@apache.org]
Sent: Wednesday, August 07, 2002 3:12 PM
To: poi-***@jakarta.apache.org
Subject: Re: Greek Symbols and Square Root Symbol


See if this is still an issue in 1.5.1.

Post by E***@upstate.com
Hi all,
In my excel documents, I can type the character for a square root: ?.

This

Post by E***@upstate.com
is without using the Symbol font, just plain old Times New Roman.
Now, I want to generate an Excel document using POI that outputs the ?
square root character. However, whatever I type into my IDE comes out as

a

Post by E***@upstate.com
? character. Does POI have any sort of translator?
And, on a related note, in my excel document, I have Greek alpha and beta
characters. Now, the ß (beta) character comes out fine, but I can't seem

to

Post by E***@upstate.com
get the alpha character to come out.
By the way, I am on w2k machine and poi 1.5. I saw a post about extended
character issues, is this something that would be fixed if I upgraded?
Eric

--
To unsubscribe, e-mail: <mailto:poi-user-***@jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-***@jakarta.apache.org>

[Andrew C. Oliver]

Site is meant as propaganda to engage people into the project... to turn
everyone into a beta tester :-)

Documentation is included in each distribution.

You should NOT use POI 1.5.0 - you should upgrade to POI 1.5.1.

If you ask "is this a bug" and you're using 1.5.0 most committers will
not go the extra mile to help you (unless the answer is really obvious)
because we've likely already fixed the problem. This isn't because we're
mean its because we're too busy to go back over old bugs that we
probably fixed a long time ago.

-Andy

Post by E***@upstate.com
I have made progress on this issue.. The alpha character and the square
root character come out fine. I looked into the FAQ section
http://jakarta.apache.org/poi/faq.html#faq-10 and initially had no luck.
The reason was my Unicode character string was right next to a non Unicode
character.
For alpha (\u03B1)
\u03B12 fails
\u03B1 2 works.
Maybe tweaking the FAQ would help?
//
// for sheet name
//
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet s = wb.createSheet();
wb.setSheetName( 0, "SomeUnicodeName",
HSSFWorkbook.ENCODING_UTF_16 );
I don't see in the javadocs posted on the site (and in 1.5) where this
method wb.setSheetName(...) exists. Is this a 1.8 or CVS head thing?
Eric Pugh
-----Original Message-----
Sent: Wednesday, August 07, 2002 3:12 PM
Subject: Re: Greek Symbols and Square Root Symbol
See if this is still an issue in 1.5.1.

Post by E***@upstate.com
Hi all,
In my excel documents, I can type the character for a square root: ?.

This

Post by E***@upstate.com
is without using the Symbol font, just plain old Times New Roman.
Now, I want to generate an Excel document using POI that outputs the ?
square root character. However, whatever I type into my IDE comes out as

a

Post by E***@upstate.com
? character. Does POI have any sort of translator?
And, on a related note, in my excel document, I have Greek alpha and beta
characters. Now, the ß (beta) character comes out fine, but I can't seem

to

Post by E***@upstate.com
get the alpha character to come out.
By the way, I am on w2k machine and poi 1.5. I saw a post about extended
character issues, is this something that would be fixed if I upgraded?
Eric

--
--

--
http://www.superlinksoftware.com - software solutions for business
http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in
Java
http://krysalis.sourceforge.net/centipede - the best build/project
structure
a guy/gal could have! - Make Ant simple on complex Projects!
The avalanche has already started. It is too late for the pebbles to
vote.
-Ambassador Kosh