Open Gnumeric. Create a sheet with some garbage in it (but from scratch).
Save it
ungzip it (if its gzipped)
open that same sheet
create a merged cell (change nothing else)
save it as something else
ungzip it (if gzipped)
diff 1.xml 2.xml
Thats what it does. ;-) I've not looked at this recently, but if I recall its pretty straightforward.
Danny Mui wrote:
Thanks for your quick reply Andrew! Do you have an inkling on how gnumeric interprets merged fields? I'd rather build that support into the serializer than tagging individual cells that I'm going through now. I'd prefer to not delve into gnumeric's source (im a java weeny) if you've already looked at it. But since it's a holiday I'll inspect the xml some more :).
thanks.
danny
Andrew C. Oliver wrote:
Danny Mui wrote:Using latest Cocoon from CVS and HSSFSerializer separately (not from within cocoon).
When setting up merged fields in gnumeric, the HSSF translation does not seem to carry them through to the Excel side.
Yes this isn't implemented in the serializer yet. It is supported by HSSF.
I saw the rows/cols attributes in the gnumeric dtd but gnumeric doesn't generate those attributes. I updated EPCell.java (will submit to bugzilla shortly) to support merged fields but it's a bit of a manual effort to tag cells to be merged (and error prone).
yes. If its a workable solution I'll apply it. -AndyAm I missing something? I hope to be enlightened! danny --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>--------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>--------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
--------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
