You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by nandipinto <na...@hotpop.com> on 2002/12/18 11:28:57 UTC
HSSFSerializer
Hi all,
I'm using HSSFSerializer to generate Excel file, but strange things
happened. I set font to a Chinese font for the whole document, but the
result is that the font is reset to Arial somewhere in the page (in the
middle of the page), and then back to the Chinese font again in the end of
the page.
Anyone knows how this happen and how to solve this?
regards,
nandipinto.
---------------------------------------------------------------------
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: HSSFSerializer
Posted by "Andrew C. Oliver" <ac...@apache.org>.
If you post the patch in Bugzilla against the head of Cocoon, you'll
find it applied promptly as I am a committer to the project. (then no
one has to wait ;-) )
-Andy
Danny Mui wrote:
> I patched the Serializer to avoid making new fonts for each style and
> the approach I used is posted on cocoon-dev but I fear it's been
> deluged by mail lately so it may be hard for it to be noticed.
>
> I can send you the patches individually if you can't wait though.
>
> danny
>
> nandipinto wrote:
>
>> Hi there Oliver,
>>
>> Thanks for your reply, what is the XF anyway :)
>> One more thing, when I open the file using Excel, there is a warning
>> says
>> that the maximum number of font formatting has exceeded, try to close
>> another document.
>>
>> I really don't know what went wrong, is it in the HSSFSerializer or
>> in the
>> Excel itself.
>>
>>
>> nandipinto.
>>
>> ----- Original Message -----
>> From: "Andrew C. Oliver" <ac...@apache.org>
>> To: "POI Users List" <po...@jakarta.apache.org>
>> Sent: Wednesday, December 18, 2002 8:38 PM
>> Subject: Re: HSSFSerializer
>>
>>
>>
>>
>>> Ahh its probably because XF record 15 is attached to Arial. So if you
>>> don't set a style its the default style (either 0 or 15 I forget
>>> which).. We need Chinese volunteers to help us compare the output
>>> between Excel in Chinese and English so that we know how to set local
>>> defaults.
>>>
>>> -Andy
>>>
>>> nandipinto wrote:
>>>
>>>
>>>
>>>> Hi all,
>>>> I'm using HSSFSerializer to generate Excel file, but strange things
>>>> happened. I set font to a Chinese font for the whole document, but the
>>>> result is that the font is reset to Arial somewhere in the page (in
>>>> the
>>>> middle of the page), and then back to the Chinese font again in the
>>>> end
>>>>
>>>
>> of
>>
>>
>>>> the page.
>>>> Anyone knows how this happen and how to solve this?
>>>>
>>>> regards,
>>>>
>>>> nandipinto.
>>>>
>>>>
>>>> --
>>>> To unsubscribe, e-mail:
>>>>
>>>
>> <ma...@jakarta.apache.org>
>>
>>
>>>> For additional commands, e-mail:
>>>>
>>>
>> <ma...@jakarta.apache.org>
>>
>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> To unsubscribe, e-mail:
>>> <ma...@jakarta.apache.org>
>>> For additional commands, e-mail:
>>> <ma...@jakarta.apache.org>
>>>
>>>
>>
>>
>>
>> --
>> To unsubscribe, e-mail:
>> <ma...@jakarta.apache.org>
>> For additional commands, e-mail:
>> <ma...@jakarta.apache.org>
>>
>>
>>
>
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
Re: HSSFSerializer
Posted by nandipinto <na...@hotpop.com>.
Hi ther Danny,
Yes, could you please send me the patch?
thanks
nandipinto.
----- Original Message -----
From: "Danny Mui" <da...@muibros.com>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Thursday, December 19, 2002 10:10 PM
Subject: Re: HSSFSerializer
> I patched the Serializer to avoid making new fonts for each style and
> the approach I used is posted on cocoon-dev but I fear it's been deluged
> by mail lately so it may be hard for it to be noticed.
>
> I can send you the patches individually if you can't wait though.
>
> danny
>
> nandipinto wrote:
>
> >Hi there Oliver,
> >
> >Thanks for your reply, what is the XF anyway :)
> >One more thing, when I open the file using Excel, there is a warning says
> >that the maximum number of font formatting has exceeded, try to close
> >another document.
> >
> >I really don't know what went wrong, is it in the HSSFSerializer or in
the
> >Excel itself.
> >
> >
> >nandipinto.
> >
> >----- Original Message -----
> >From: "Andrew C. Oliver" <ac...@apache.org>
> >To: "POI Users List" <po...@jakarta.apache.org>
> >Sent: Wednesday, December 18, 2002 8:38 PM
> >Subject: Re: HSSFSerializer
> >
> >
> >
> >
> >>Ahh its probably because XF record 15 is attached to Arial. So if you
> >>don't set a style its the default style (either 0 or 15 I forget
> >>which).. We need Chinese volunteers to help us compare the output
> >>between Excel in Chinese and English so that we know how to set local
> >>defaults.
> >>
> >>-Andy
> >>
> >>nandipinto wrote:
> >>
> >>
> >>
> >>>Hi all,
> >>>I'm using HSSFSerializer to generate Excel file, but strange things
> >>>happened. I set font to a Chinese font for the whole document, but the
> >>>result is that the font is reset to Arial somewhere in the page (in the
> >>>middle of the page), and then back to the Chinese font again in the end
> >>>
> >>>
> >of
> >
> >
> >>>the page.
> >>>Anyone knows how this happen and how to solve this?
> >>>
> >>>regards,
> >>>
> >>>nandipinto.
> >>>
> >>>
> >>>--
> >>>To unsubscribe, e-mail:
> >>>
> >>>
> ><ma...@jakarta.apache.org>
> >
> >
> >>>For additional commands, e-mail:
> >>>
> >>>
> ><ma...@jakarta.apache.org>
> >
> >
> >>>
> >>>
> >>>
> >>>
> >>
> >>--
> >>To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> >>For additional commands, e-mail:
<ma...@jakarta.apache.org>
> >>
> >>
> >>
> >
> >
> >--
> >To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> >For additional commands, e-mail:
<ma...@jakarta.apache.org>
> >
> >
> >
>
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
Re: HSSFSerializer
Posted by Danny Mui <da...@muibros.com>.
I patched the Serializer to avoid making new fonts for each style and
the approach I used is posted on cocoon-dev but I fear it's been deluged
by mail lately so it may be hard for it to be noticed.
I can send you the patches individually if you can't wait though.
danny
nandipinto wrote:
>Hi there Oliver,
>
>Thanks for your reply, what is the XF anyway :)
>One more thing, when I open the file using Excel, there is a warning says
>that the maximum number of font formatting has exceeded, try to close
>another document.
>
>I really don't know what went wrong, is it in the HSSFSerializer or in the
>Excel itself.
>
>
>nandipinto.
>
>----- Original Message -----
>From: "Andrew C. Oliver" <ac...@apache.org>
>To: "POI Users List" <po...@jakarta.apache.org>
>Sent: Wednesday, December 18, 2002 8:38 PM
>Subject: Re: HSSFSerializer
>
>
>
>
>>Ahh its probably because XF record 15 is attached to Arial. So if you
>>don't set a style its the default style (either 0 or 15 I forget
>>which).. We need Chinese volunteers to help us compare the output
>>between Excel in Chinese and English so that we know how to set local
>>defaults.
>>
>>-Andy
>>
>>nandipinto wrote:
>>
>>
>>
>>>Hi all,
>>>I'm using HSSFSerializer to generate Excel file, but strange things
>>>happened. I set font to a Chinese font for the whole document, but the
>>>result is that the font is reset to Arial somewhere in the page (in the
>>>middle of the page), and then back to the Chinese font again in the end
>>>
>>>
>of
>
>
>>>the page.
>>>Anyone knows how this happen and how to solve this?
>>>
>>>regards,
>>>
>>>nandipinto.
>>>
>>>
>>>--
>>>To unsubscribe, e-mail:
>>>
>>>
><ma...@jakarta.apache.org>
>
>
>>>For additional commands, e-mail:
>>>
>>>
><ma...@jakarta.apache.org>
>
>
>>>
>>>
>>>
>>>
>>
>>--
>>To unsubscribe, e-mail: <ma...@jakarta.apache.org>
>>For additional commands, e-mail: <ma...@jakarta.apache.org>
>>
>>
>>
>
>
>--
>To unsubscribe, e-mail: <ma...@jakarta.apache.org>
>For additional commands, e-mail: <ma...@jakarta.apache.org>
>
>
>
Re: HSSFSerializer
Posted by "Andrew C. Oliver" <ac...@apache.org>.
Can you show me some XML? I think I know the problem..
nandipinto wrote:
>Hi there Oliver,
>
>Thanks for your reply, what is the XF anyway :)
>One more thing, when I open the file using Excel, there is a warning says
>that the maximum number of font formatting has exceeded, try to close
>another document.
>
>I really don't know what went wrong, is it in the HSSFSerializer or in the
>Excel itself.
>
>
>nandipinto.
>
>----- Original Message -----
>From: "Andrew C. Oliver" <ac...@apache.org>
>To: "POI Users List" <po...@jakarta.apache.org>
>Sent: Wednesday, December 18, 2002 8:38 PM
>Subject: Re: HSSFSerializer
>
>
>
>
>>Ahh its probably because XF record 15 is attached to Arial. So if you
>>don't set a style its the default style (either 0 or 15 I forget
>>which).. We need Chinese volunteers to help us compare the output
>>between Excel in Chinese and English so that we know how to set local
>>defaults.
>>
>>-Andy
>>
>>nandipinto wrote:
>>
>>
>>
>>>Hi all,
>>>I'm using HSSFSerializer to generate Excel file, but strange things
>>>happened. I set font to a Chinese font for the whole document, but the
>>>result is that the font is reset to Arial somewhere in the page (in the
>>>middle of the page), and then back to the Chinese font again in the end
>>>
>>>
>of
>
>
>>>the page.
>>>Anyone knows how this happen and how to solve this?
>>>
>>>regards,
>>>
>>>nandipinto.
>>>
>>>
>>>--
>>>To unsubscribe, e-mail:
>>>
>>>
><ma...@jakarta.apache.org>
>
>
>>>For additional commands, e-mail:
>>>
>>>
><ma...@jakarta.apache.org>
>
>
>>>
>>>
>>>
>>>
>>
>>--
>>To unsubscribe, e-mail: <ma...@jakarta.apache.org>
>>For additional commands, e-mail: <ma...@jakarta.apache.org>
>>
>>
>>
>
>
>--
>To unsubscribe, e-mail: <ma...@jakarta.apache.org>
>For additional commands, e-mail: <ma...@jakarta.apache.org>
>
>
>
>
Re: HSSFSerializer
Posted by nandipinto <na...@hotpop.com>.
Hi there Oliver,
Thanks for your reply, what is the XF anyway :)
One more thing, when I open the file using Excel, there is a warning says
that the maximum number of font formatting has exceeded, try to close
another document.
I really don't know what went wrong, is it in the HSSFSerializer or in the
Excel itself.
nandipinto.
----- Original Message -----
From: "Andrew C. Oliver" <ac...@apache.org>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Wednesday, December 18, 2002 8:38 PM
Subject: Re: HSSFSerializer
> Ahh its probably because XF record 15 is attached to Arial. So if you
> don't set a style its the default style (either 0 or 15 I forget
> which).. We need Chinese volunteers to help us compare the output
> between Excel in Chinese and English so that we know how to set local
> defaults.
>
> -Andy
>
> nandipinto wrote:
>
> >Hi all,
> >I'm using HSSFSerializer to generate Excel file, but strange things
> >happened. I set font to a Chinese font for the whole document, but the
> >result is that the font is reset to Arial somewhere in the page (in the
> >middle of the page), and then back to the Chinese font again in the end
of
> >the page.
> >Anyone knows how this happen and how to solve this?
> >
> >regards,
> >
> >nandipinto.
> >
> >
> >--
> >To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> >For additional commands, e-mail:
<ma...@jakarta.apache.org>
> >
> >
> >
> >
>
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
Re: HSSFSerializer
Posted by "Andrew C. Oliver" <ac...@apache.org>.
Ahh its probably because XF record 15 is attached to Arial. So if you
don't set a style its the default style (either 0 or 15 I forget
which).. We need Chinese volunteers to help us compare the output
between Excel in Chinese and English so that we know how to set local
defaults.
-Andy
nandipinto wrote:
>Hi all,
>I'm using HSSFSerializer to generate Excel file, but strange things
>happened. I set font to a Chinese font for the whole document, but the
>result is that the font is reset to Arial somewhere in the page (in the
>middle of the page), and then back to the Chinese font again in the end of
>the page.
>Anyone knows how this happen and how to solve this?
>
>regards,
>
>nandipinto.
>
>
>--
>To unsubscribe, e-mail: <ma...@jakarta.apache.org>
>For additional commands, e-mail: <ma...@jakarta.apache.org>
>
>
>
>
Re: HSSFSerializer
Posted by Markus Wiese <wi...@datenwerker.de>.
Hi,
I'm new to the subject myself, but please provide a little more information
like: wether xslt used, (gmr:StyleRegion, ...)
Did you check your XML?
markus
----- Original Message -----
From: "nandipinto" <na...@hotpop.com>
To: "cocoon" <co...@xml.apache.org>; "POI"
<po...@jakarta.apache.org>
Sent: Wednesday, December 18, 2002 11:28 AM
Subject: HSSFSerializer
> Hi all,
> I'm using HSSFSerializer to generate Excel file, but strange things
> happened. I set font to a Chinese font for the whole document, but the
> result is that the font is reset to Arial somewhere in the page (in the
> middle of the page), and then back to the Chinese font again in the end of
> the page.
> Anyone knows how this happen and how to solve this?
>
> regards,
>
> nandipinto.
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>