You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by bc...@free.fr on 2004/12/07 15:09:02 UTC
memory problem with HSSF
Hello,
I have generated an Excel file with HSSF with 300 rows and 3 columns (55 kB)
When I open the Excel file with Office 97 on win NT4.0 I got an error "out of
memory" (the error message comes from Excel, not the web app!).
If I open the same file with Office 2000 on win XP I don't have the same error
message!
Any idea?
Best regards,
Bruno CHEVALIER
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: AW: memory problem with HSSF
Posted by bc...@free.fr.
The strings are small (between 3 and 20 characters). The file weights 55 KB.
Best Regards,
Bruno CHEVALIER
Selon Danny Mui <da...@muibros.com>:
> just curious, are they large (forget what size limitations and
> conversions occur) strings?
>
>
> bc1@free.fr wrote:
> > Nothing specific, three columns with only text values and 300 hundred
> rows...
> >
> >
> > Best regards,
> >
> > Bruno CHEVALIER
> >
> > Selon Danny Mui <da...@muibros.com>:
> >
> >
> >>anything exotic? forms? data validation? graphics?
> >>
> >>bc1@free.fr wrote:
> >>
> >>>No, I did not use any template to generate this file.
> >>>I coded it with the HSSF API (HSSFWorkbook, and so on).
> >>>It seems something is missing in the generated file that causes that
> error.
> >>>Office2k on XP seems to be more fault tolerant than 97 on NT.
> >>>
> >>>Best regards,
> >>>
> >>>Bruno CHEVALIER
> >>>
> >>>Selon "KHZ (SAW)" <ka...@sawag.com>:
> >>>
> >>>
> >>>
> >>>>Hi Bruno.
> >>>>
> >>>>Did you use a template for generating this Excel file?
> >>>>
> >>>>We had problems in some systems (Excel*) but not in others (OpenOffice)
> >>>>when opening. Building the template from the scratch it worked. When
> >>>>opening the template using POI we didn't see warnings then (unknown Ptg
> >>>>...). Before we've seen such things.
> >>>>
> >>>>Regards, Karl-Heinz.
> >>>>
> >>>>
> >>>>-----Ursprüngliche Nachricht-----
> >>>>Von: bc1@free.fr [mailto:bc1@free.fr]
> >>>>Gesendet: Dienstag, 7. Dezember 2004 15:09
> >>>>An: poi-user@jakarta.apache.org
> >>>>Betreff: memory problem with HSSF
> >>>>
> >>>>Hello,
> >>>>
> >>>>I have generated an Excel file with HSSF with 300 rows and 3 columns (55
> >>>>kB)
> >>>>When I open the Excel file with Office 97 on win NT4.0 I got an error
> >>>>"out of
> >>>>memory" (the error message comes from Excel, not the web app!).
> >>>>
> >>>>If I open the same file with Office 2000 on win XP I don't have the same
> >>>>error
> >>>>message!
> >>>>
> >>>>Any idea?
> >>>>
> >>>>Best regards,
> >>>>
> >>>>Bruno CHEVALIER
> >>>>
> >>>>---------------------------------------------------------------------
> >>>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >>>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>---------------------------------------------------------------------
> >>>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >>>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>>
> >>>---------------------------------------------------------------------
> >>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >>
> >>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >>For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >>
> >>
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: AW: memory problem with HSSF
Posted by Danny Mui <da...@muibros.com>.
just curious, are they large (forget what size limitations and
conversions occur) strings?
bc1@free.fr wrote:
> Nothing specific, three columns with only text values and 300 hundred rows...
>
>
> Best regards,
>
> Bruno CHEVALIER
>
> Selon Danny Mui <da...@muibros.com>:
>
>
>>anything exotic? forms? data validation? graphics?
>>
>>bc1@free.fr wrote:
>>
>>>No, I did not use any template to generate this file.
>>>I coded it with the HSSF API (HSSFWorkbook, and so on).
>>>It seems something is missing in the generated file that causes that error.
>>>Office2k on XP seems to be more fault tolerant than 97 on NT.
>>>
>>>Best regards,
>>>
>>>Bruno CHEVALIER
>>>
>>>Selon "KHZ (SAW)" <ka...@sawag.com>:
>>>
>>>
>>>
>>>>Hi Bruno.
>>>>
>>>>Did you use a template for generating this Excel file?
>>>>
>>>>We had problems in some systems (Excel*) but not in others (OpenOffice)
>>>>when opening. Building the template from the scratch it worked. When
>>>>opening the template using POI we didn't see warnings then (unknown Ptg
>>>>...). Before we've seen such things.
>>>>
>>>>Regards, Karl-Heinz.
>>>>
>>>>
>>>>-----Ursprüngliche Nachricht-----
>>>>Von: bc1@free.fr [mailto:bc1@free.fr]
>>>>Gesendet: Dienstag, 7. Dezember 2004 15:09
>>>>An: poi-user@jakarta.apache.org
>>>>Betreff: memory problem with HSSF
>>>>
>>>>Hello,
>>>>
>>>>I have generated an Excel file with HSSF with 300 rows and 3 columns (55
>>>>kB)
>>>>When I open the Excel file with Office 97 on win NT4.0 I got an error
>>>>"out of
>>>>memory" (the error message comes from Excel, not the web app!).
>>>>
>>>>If I open the same file with Office 2000 on win XP I don't have the same
>>>>error
>>>>message!
>>>>
>>>>Any idea?
>>>>
>>>>Best regards,
>>>>
>>>>Bruno CHEVALIER
>>>>
>>>>---------------------------------------------------------------------
>>>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>>>
>>>>
>>>>
>>>>
>>>>---------------------------------------------------------------------
>>>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>
>>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: AW: memory problem with HSSF
Posted by bc...@free.fr.
Nothing specific, three columns with only text values and 300 hundred rows...
Best regards,
Bruno CHEVALIER
Selon Danny Mui <da...@muibros.com>:
> anything exotic? forms? data validation? graphics?
>
> bc1@free.fr wrote:
> > No, I did not use any template to generate this file.
> > I coded it with the HSSF API (HSSFWorkbook, and so on).
> > It seems something is missing in the generated file that causes that error.
> > Office2k on XP seems to be more fault tolerant than 97 on NT.
> >
> > Best regards,
> >
> > Bruno CHEVALIER
> >
> > Selon "KHZ (SAW)" <ka...@sawag.com>:
> >
> >
> >>Hi Bruno.
> >>
> >>Did you use a template for generating this Excel file?
> >>
> >>We had problems in some systems (Excel*) but not in others (OpenOffice)
> >>when opening. Building the template from the scratch it worked. When
> >>opening the template using POI we didn't see warnings then (unknown Ptg
> >>...). Before we've seen such things.
> >>
> >>Regards, Karl-Heinz.
> >>
> >>
> >>-----Ursprüngliche Nachricht-----
> >>Von: bc1@free.fr [mailto:bc1@free.fr]
> >>Gesendet: Dienstag, 7. Dezember 2004 15:09
> >>An: poi-user@jakarta.apache.org
> >>Betreff: memory problem with HSSF
> >>
> >>Hello,
> >>
> >>I have generated an Excel file with HSSF with 300 rows and 3 columns (55
> >>kB)
> >>When I open the Excel file with Office 97 on win NT4.0 I got an error
> >>"out of
> >>memory" (the error message comes from Excel, not the web app!).
> >>
> >>If I open the same file with Office 2000 on win XP I don't have the same
> >>error
> >>message!
> >>
> >>Any idea?
> >>
> >>Best regards,
> >>
> >>Bruno CHEVALIER
> >>
> >>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >>For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >>
> >>
> >>
> >>
> >>---------------------------------------------------------------------
> >>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >>For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >>
> >>
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: AW: memory problem with HSSF
Posted by Danny Mui <da...@muibros.com>.
anything exotic? forms? data validation? graphics?
bc1@free.fr wrote:
> No, I did not use any template to generate this file.
> I coded it with the HSSF API (HSSFWorkbook, and so on).
> It seems something is missing in the generated file that causes that error.
> Office2k on XP seems to be more fault tolerant than 97 on NT.
>
> Best regards,
>
> Bruno CHEVALIER
>
> Selon "KHZ (SAW)" <ka...@sawag.com>:
>
>
>>Hi Bruno.
>>
>>Did you use a template for generating this Excel file?
>>
>>We had problems in some systems (Excel*) but not in others (OpenOffice)
>>when opening. Building the template from the scratch it worked. When
>>opening the template using POI we didn't see warnings then (unknown Ptg
>>...). Before we've seen such things.
>>
>>Regards, Karl-Heinz.
>>
>>
>>-----Ursprüngliche Nachricht-----
>>Von: bc1@free.fr [mailto:bc1@free.fr]
>>Gesendet: Dienstag, 7. Dezember 2004 15:09
>>An: poi-user@jakarta.apache.org
>>Betreff: memory problem with HSSF
>>
>>Hello,
>>
>>I have generated an Excel file with HSSF with 300 rows and 3 columns (55
>>kB)
>>When I open the Excel file with Office 97 on win NT4.0 I got an error
>>"out of
>>memory" (the error message comes from Excel, not the web app!).
>>
>>If I open the same file with Office 2000 on win XP I don't have the same
>>error
>>message!
>>
>>Any idea?
>>
>>Best regards,
>>
>>Bruno CHEVALIER
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>
>>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: AW: memory problem with HSSF
Posted by bc...@free.fr.
No, I did not use any template to generate this file.
I coded it with the HSSF API (HSSFWorkbook, and so on).
It seems something is missing in the generated file that causes that error.
Office2k on XP seems to be more fault tolerant than 97 on NT.
Best regards,
Bruno CHEVALIER
Selon "KHZ (SAW)" <ka...@sawag.com>:
> Hi Bruno.
>
> Did you use a template for generating this Excel file?
>
> We had problems in some systems (Excel*) but not in others (OpenOffice)
> when opening. Building the template from the scratch it worked. When
> opening the template using POI we didn't see warnings then (unknown Ptg
> ...). Before we've seen such things.
>
> Regards, Karl-Heinz.
>
>
> -----Ursprüngliche Nachricht-----
> Von: bc1@free.fr [mailto:bc1@free.fr]
> Gesendet: Dienstag, 7. Dezember 2004 15:09
> An: poi-user@jakarta.apache.org
> Betreff: memory problem with HSSF
>
> Hello,
>
> I have generated an Excel file with HSSF with 300 rows and 3 columns (55
> kB)
> When I open the Excel file with Office 97 on win NT4.0 I got an error
> "out of
> memory" (the error message comes from Excel, not the web app!).
>
> If I open the same file with Office 2000 on win XP I don't have the same
> error
> message!
>
> Any idea?
>
> Best regards,
>
> Bruno CHEVALIER
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
AW: memory problem with HSSF
Posted by "KHZ (SAW)" <ka...@sawag.com>.
Hi Bruno.
Did you use a template for generating this Excel file?
We had problems in some systems (Excel*) but not in others (OpenOffice)
when opening. Building the template from the scratch it worked. When
opening the template using POI we didn't see warnings then (unknown Ptg
...). Before we've seen such things.
Regards, Karl-Heinz.
-----Ursprüngliche Nachricht-----
Von: bc1@free.fr [mailto:bc1@free.fr]
Gesendet: Dienstag, 7. Dezember 2004 15:09
An: poi-user@jakarta.apache.org
Betreff: memory problem with HSSF
Hello,
I have generated an Excel file with HSSF with 300 rows and 3 columns (55
kB)
When I open the Excel file with Office 97 on win NT4.0 I got an error
"out of
memory" (the error message comes from Excel, not the web app!).
If I open the same file with Office 2000 on win XP I don't have the same
error
message!
Any idea?
Best regards,
Bruno CHEVALIER
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org