Thanks for that; I did not know that it was possible to use two or more different fonts within a cell under Excel97. The reason I replied is that a similar question was asked on a different board and the consensus was that the Biff8 format did not support this feature, seems we were wrong. That means that I am stumped, cannot think why it should not be possible under HSSF but also cannot think how you would do it as the formatting info is applied to a cell. There is no way - at least that I am aware of - to select just a portion of the cells contents and modify that.
pelican <[EMAIL PROTECTED]> wrote: Hi, I don't know about how to solve the problem. But just as a comment, the different format for 100 and 50 in a cell is able to do in Microsoft Excel 97 version. This is new to me too. rgds, ----- Original Message ----- From: "Anthony Andrews" To: "POI Users List" Sent: Monday, January 16, 2006 4:37 PM Subject: Re: problem moving cells > 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 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. --------------------------------------------------------------------- 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 Showcase holiday pictures in hardcover Photo Books. You design it and well bind it!
