This morning, I had the chance to play around just a little and hope this will explain a little better my post from yesterday.
Using Excel, I created a workbook with a single sheet in it. That sheet had a couple of cells populated with Strings and one of these strings I formatted so that one word was emboldened, another had a different font face and size, etc. Saving the to disc and then unzipping it, I looked inside the sharedStrings.xml file and found this fragment amoungst the mark-up Rich Text String What I would like to try is writing this mark-up - or something very like it - directly into the cell record that exists within the sheetn.xml file. If we are lucky, Excel will be able to interpret the mark-up correctly and render the results so that the cell appears to hold a rich text stirng - to borrow POI's terminology. If you have the time, it might be worth repeating the exercise, snipping from the xml in the sharedStrings.xml file a chunk of mark-up and then using the BigGridDemo code to write this mark-up directly into a cell. Save the file and open it in Excel to see what the results are. Should prove instructive if nothing else. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/BigGridDemo-for-a-RichText-tp3412641p3413864.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
