You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Danny Mui <da...@muibros.com> on 2002/11/27 03:48:29 UTC
[HSSF][POI] Gnumeric Conversion Question
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.
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).
Am 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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: [HSSF][POI] Gnumeric Conversion Question
Posted by "Andrew C. Oliver" <ac...@apache.org>.
ahh. I meant the unix "diff" command .. . "diff file1 file2"
If you're on winblows (which makes me wonder how you're running
gnumeric) you can get cygwin (www.cygwin.com)
which has most of your friendly unix tools. Makes winblows
usable....between crashes.
Danny Mui wrote:
> No i was being silly.. "manual diff" == eyeballing :)
>
> Andrew C. Oliver wrote:
>
>> "diff" doesn't work? How odd!
>>
>> Danny Mui wrote:
>>
>>> Thanks for sharing my manual diff doesn't seem to be working too
>>> well /grin.
>>>
>>> Will bring back what I can come up with.
>>>
>>> danny
>>>
>>> Andrew C. Oliver wrote:
>>>
>>>> I have a very scientific method for doing this.
>>>>
>>>> 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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> 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: <co...@xml.apache.org>
>>> For additional commands, e-mail: <co...@xml.apache.org>
>>>
>>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> 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: <co...@xml.apache.org>
>> For additional commands, e-mail: <co...@xml.apache.org>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: [HSSF][POI] Gnumeric Conversion Question
Posted by Danny Mui <da...@muibros.com>.
No i was being silly.. "manual diff" == eyeballing :)
Andrew C. Oliver wrote:
> "diff" doesn't work? How odd!
>
> Danny Mui wrote:
>
>> Thanks for sharing my manual diff doesn't seem to be working too well
>> /grin.
>>
>> Will bring back what I can come up with.
>>
>> danny
>>
>> Andrew C. Oliver wrote:
>>
>>> I have a very scientific method for doing this.
>>>
>>> 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
>>
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> 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: <co...@xml.apache.org>
>> For additional commands, e-mail: <co...@xml.apache.org>
>>
>>
>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: [HSSF][POI] Gnumeric Conversion Question
Posted by "Andrew C. Oliver" <ac...@apache.org>.
"diff" doesn't work? How odd!
Danny Mui wrote:
> Thanks for sharing my manual diff doesn't seem to be working too well
> /grin.
>
> Will bring back what I can come up with.
>
> danny
>
> Andrew C. Oliver wrote:
>
>> I have a very scientific method for doing this.
>>
>> 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
>
>
>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: [HSSF][POI] Gnumeric Conversion Question
Posted by Danny Mui <da...@muibros.com>.
Thanks for sharing my manual diff doesn't seem to be working too well /grin.
Will bring back what I can come up with.
danny
Andrew C. Oliver wrote:
> I have a very scientific method for doing this.
>
> 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
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: [HSSF][POI] Gnumeric Conversion Question
Posted by "Andrew C. Oliver" <ac...@apache.org>.
I have a very scientific method for doing this.
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.
>>
>> -Andy
>>
>>>
>>> Am 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: <co...@xml.apache.org>
>>> For additional commands, e-mail: <co...@xml.apache.org>
>>>
>>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> 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: <co...@xml.apache.org>
>> For additional commands, e-mail: <co...@xml.apache.org>
>
>
>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: [HSSF][POI] Gnumeric Conversion Question
Posted by Danny Mui <da...@muibros.com>.
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.
>
> -Andy
>
>>
>> Am 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: <co...@xml.apache.org>
>> For additional commands, e-mail: <co...@xml.apache.org>
>>
>>
>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: [HSSF][POI] Gnumeric Conversion Question
Posted by "Andrew C. Oliver" <ac...@apache.org>.
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.
-Andy
>
> Am 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>