No real advice from me I am afraid other than a way to make a start on the problem. As you possibly know, xlsx files are simply zipped xml and so my first step would be to create a very simple file using Excel, change the extension to .zip and then unzip it. After that, you can have a dig around in the file to see how the mark-up is structured during the creation of the file. With luck, it may be possible to simply write a string of xml markup into a cell rather than a string of text. That markup would follow Excel's format of course and contain the font and formatting information for the text. Whether this is possib,e I do not know and fear that you may be heading for a rendezvous with the shared strings file but I cxannot comment with any authority on this. It would certainly be worth creating a test file using the BigGridDemo approach and then unzippig this to dig around within it as well. It may be that Excel and BigGridDemo both save the data away successfuly but using a sightly different approach - does BigGridDemo make use of the shared strings file is the question I would like answered.
Have you looked into what the rich text string classes in the api produce as output? It may be possible to use them to encode you text and then all you would need to do is to identify a way to write this information into the file. All the best Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/BigGridDemo-for-a-RichText-tp3412641p3412728.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
