Hello Paul
I could very well be wrong but I think the problem lies in the version of
Excel that HSSF uses to write the output file. HSSF uses, I think, a file
format that conforms to that employed by Excel 97 - quite an old version now -
to ensure the maximum compatibility. Well, the ability to have more than one
format or font treatment applied to the contents of a single cell is a more
recent introduction. So, it is simply because HSSF writes the output file in a
format that supports only a single font/treatment for the contents of a cell
that is causing you this problem in my opinion.
Have to say that I have absolutly no idea how you are going to get around the
porblem if this is the case. Sorry.
Paul Rivera <[EMAIL PROTECTED]> wrote: Hi! I'm having problems moving cells.
For instance, I have a cell with the value:
100 50
With "100" being striked-through. Let's say I want to move this cell from
0 to 1. After calling setCellNum(), the values will now be in cell 1. But
both 100 and 50 will now be striked-through. Only 100 should be
striked-through.
I have attached my sample java application and a sample input/output excel
file. It is but a fraction of the real excel file I'm working on. I'm using
poi 3.0 on windows 2000 professional.
Your help would be much appreciated!
Thanks!
---------------------------------
Yahoo! Photos
Ring in the New Year with Photo Calendars. Add photos, events, holidays,
whatever.---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------
Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.
