poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ricardo Lopes <A...@alunos.ipca.pt>
Subject Re: AW: AW: OpenOffice 1.1.3 can not read a xls file generated with hssf
Date Tue, 04 Jan 2005 10:36:55 GMT
You might get more lucky in the OpenOffice mailing list, it seems to me 
that it is an OS specific bug (in O.O.).


Xavier Vanderstukken wrote:

> I try to specify the encoding but the error persist.
> However the file is readable under O.O. in Windows
>
> Andre Schild wrote:
>
>> Hello,
>>
>>
>>  
>>
>>> -----Ursprüngliche Nachricht-----
>>> Von: Xavier Vanderstukken [mailto:xv@ionicsoft.com] Gesendet: 
>>> Montag, 3. Januar 2005 18:27
>>> An: POI Users List
>>> Betreff: Re: AW: OpenOffice 1.1.3 can not read a xls file generated 
>>> with hssf
>>>
>>>
>>> No I juste use the 4lines of code that I show below.
>>> Is it possible to specify unicode encoding?
>>>   
>>
>>
>> As far as I know not for these 4 lines.
>> But most methodes where you set text you can.
>>
>> For example:
>>
>> setSheetName(int sheet, java.lang.String name, short encoding)
>> and
>>
>> setEncoding(short encoding) in HFFSCell
>>
>> ....
>>
>>
>> André
>>
>>
>>  
>>
>>> Andre Schild wrote:
>>>
>>>   
>>>
>>>> Do you explicitly set the characterset to unicode ?
>>>> We always use the unicode version of all the poi functions
>>>> to prevent such problems.
>>>>
>>>> André
>>>>
>>>>
>>>>
>>>>     
>>>>
>>>>> -----Ursprüngliche Nachricht-----
>>>>> Von: Xavier Vanderstukken [mailto:xv@ionicsoft.com]
>>>>> Gesendet: Montag, 3. Januar 2005 16:02
>>>>> An: POI Users List
>>>>> Betreff: Re: OpenOffice 1.1.3 can not read a xls file generated 
>>>>> with hssf
>>>>>
>>>>>
>>>>> Yes. A few month ago I use POI for an other project under windows
>>>>> platform ad that works great.
>>>>> I think to a charset problem or a os specific problem.
>>>>> Are there a way to enable debug information during poi execution?
>>>>>
>>>>> Here are the stack trace of openoffice crash :
>>>>> Application Errorsh: line 1: crash_report: command not found
>>>>> Application Error
>>>>>
>>>>> Fatal exception: Signal 6
>>>>> Stack:
>>>>> /opt/OpenOffice.org/program/libsal.so.3[0x40c4851a]
>>>>> /opt/OpenOffice.org/program/libsal.so.3[0x40c486bd]
>>>>> /opt/OpenOffice.org/program/libsal.so.3[0x40c48768]
>>>>> /lib/libpthread.so.0[0x411bcfc3]
>>>>> [0xffffe420]
>>>>> /lib/libpthread.so.0(raise+0x2b)[0x411ba15b]
>>>>> /lib/libc.so.6(gsignal+0x44)[0x413dcfa4]
>>>>> /lib/libc.so.6(abort+0x16d)[0x413de7bd]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_Z8SalAbortRK6Strin
>>>>> g+0x44)[0x402e4db4]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN11Application5Ab
>>>>> ortERK6String+0x1f)[0x400e898f]
>>>>> /opt/OpenOffice.org/program/soffice.bin(_ZN7desktop7Desktop9Ex
>>>>> ceptionEt+0x4a)[0x806382a]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN23ImplVCLExcepti
>>>>> onHandler6signalEP13oslSignalInfo+0x99)[0x400edc39]
>>>>> /opt/OpenOffice.org/program/libvos3gcc3.so(_ZN3vos28_cpp_OSign
>>>>>  
>>>>>       
>>>>
>>>> alHandler_FunctionEPvP13oslSignalInfo+0x18)> [0x40ba9df8]
>>>>
>>>>
>>>>     
>>>>
>>>>> /opt/OpenOffice.org/program/libvos3gcc3.so(_Z24_OSignalHandler
>>>>> _FunctionPvP13oslSignalInfo+0x26)[0x40ba9dd6]
>>>>> /opt/OpenOffice.org/program/libsal.so.3[0x40c485dc]
>>>>> /opt/OpenOffice.org/program/libsal.so.3[0x40c48746]
>>>>> /lib/libpthread.so.0[0x411bcfc3]
>>>>> [0xffffe420]
>>>>> /lib/libpthread.so.0(raise+0x2b)[0x411ba15b]
>>>>> /lib/libc.so.6(gsignal+0x44)[0x413dcfa4]
>>>>> /lib/libc.so.6(abort+0x16d)[0x413de7bd]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_Z8SalAbortRK6Strin
>>>>> g+0x44)[0x402e4db4]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN11Application5Ab
>>>>> ortERK6String+0x1f)[0x400e898f]
>>>>> /opt/OpenOffice.org/program/soffice.bin(_ZN7desktop7Desktop9Ex
>>>>> ceptionEt+0x14b)[0x806392b]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_Z18SfxNewHandler_I
>>>>> mplv+0x6c)[0x445ba19c]
>>>>> /opt/OpenOffice.org/program/soffice.bin[0x8088b0c]
>>>>> /opt/OpenOffice.org/program/soffice.bin(_Znaj+0x2f)[0x8088cff]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN17SfxPSSection_I
>>>>> mpl4LoadER8SvStream+0x8a)[0x443fd9aa]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN10SfxPS_Impl4Loa
>>>>> dER8SvStream+0xa9)[0x443fd8d9]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN15SfxDocumentInf
>>>>> o15LoadPropertySetEP9SvStorage+0xf1)[0x443fec91]
>>>>> /opt/OpenOffice.org/program/libsc645li.so[0x45aed422]
>>>>> /opt/OpenOffice.org/program/libsc645li.so[0x45ade9d6]
>>>>> /opt/OpenOffice.org/program/libsc645li.so[0x45aef59e]
>>>>> /opt/OpenOffice.org/program/libsc645li.so[0x4561a3db]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN14SfxObjectShell
>>>>> 6DoLoadEP9SfxMedium+0x161a)[0x444139ba]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN20LoadEnvironmen
>>>>> t_Impl4LoadEPK16SfxObjectFactory+0x407)[0x4438b927]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN20LoadEnvironmen
>>>>> t_Impl17LoadDataAvailableEv+0x191)[0x4438d5d1]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN20LoadEnvironmen
>>>>> t_Impl17LoadDataAvailableEv+0xf5)[0x4438d535]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN20LoadEnvironmen
>>>>> t_Impl5StartEv+0x108)[0x4438a3f8]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN19SfxFrameLoader
>>>>> _Impl4loadERKN3com3sun4star3uno8SequenceINS2_5beans13PropertyV
>>>>> alueEEERKNS3_9ReferenceINS2_5frame6XFrameEEE+0xaf8)[0x44477ec8]
>>>>> /opt/OpenOffice.org/program/libfwk645li.so[0x42ef650b]
>>>>> /opt/OpenOffice.org/program/libfwk645li.so[0x42efd5ce]
>>>>> /opt/OpenOffice.org/program/libfwk645li.so[0x42ef03c0]
>>>>> /opt/OpenOffice.org/program/libfwk645li.so[0x42f0b90c]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN14SfxApplication
>>>>> 16OpenDocExec_ImplER10SfxRequest+0x1b01)[0x443440b1]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_Z37SfxStubSfxAppli
>>>>> cationOpenDocExec_ImplP8SfxShellR10SfxRequest+0x26)[0x4435b436]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN13SfxDispatcher9
>>>>> Call_ImplER8SfxShellRK7SfxSlotR10SfxRequesth+0x305)[0x444cdc65]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN13SfxDispatcher8
>>>>> _ExecuteER8SfxShellRK7SfxSlotR10SfxRequestt+0x167)[0x444cf4e7]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN13SfxDispatcher7
>>>>> ExecuteEttPPK11SfxPoolItemtS3_+0x115)[0x444d0415]
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN26SfxDispatchCon
>>>>> troller_Impl8dispatchERKN3com3sun4star4util3URLERKNS2_3uno8Seq
>>>>> uenceINS2_5beans13PropertyValueEEERKNS7_9ReferenceINS2_5frame2
>>>>>  
>>>>>       
>>>>
>>>> 3XDispatchResultListenerEEE+0x6df)[0x444c704f]
>>>>
>>>>
>>>>     
>>>>
>>>>> /opt/OpenOffice.org/program/libsfx645li.so(_ZN17SfxOfficeDispa
>>>>> tch8dispatchERKN3com3sun4star4util3URLERKNS2_3uno8SequenceINS2
>>>>> _5beans13PropertyValueEEE+0x54)[0x444c6034]
>>>>> /opt/OpenOffice.org/program/libfwk645li.so[0x42f53d7f]
>>>>> /opt/OpenOffice.org/program/libfwk645li.so[0x42f53b56]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN4Menu6SelectEv+0
>>>>> x9f)[0x401f69bf] 
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN4Menu14ImplCallS
>>>>> electEPS_+0x18)[0x401fabf8] 
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN4Menu22LinkStubI
>>>>> mplCallSelectEPvS0_+0x26)[0x401fabd6]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so[0x40249005]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_Z19ImplWindowFrame
>>>>> ProcPvP8SalFrametPKv+0x325)[0x40249795]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN12SalFrameData19
>>>>> HandleClientMessageEP19XClientMessageEvent+0x1bf)[0x402b084f]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN12SalFrameData8D
>>>>> ispatchEP7_XEvent+0x56c)[0x402b0fec]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN10SalDisplay8Dis
>>>>> patchEP7_XEvent+0x17b)[0x402e196b]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN10SalDisplay5Yie
>>>>> ldEh+0x107)[0x402e1737]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so[0x402dd1ee]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN7SalXLib5YieldEh
>>>>> +0x50c)[0x402dba4c]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN11SalInstance5Yi
>>>>> eldEh+0x34)[0x402e5504]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN11Application5Yi
>>>>> eldEv+0x5a)[0x400e8bba]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_ZN11Application7Ex
>>>>> ecuteEv+0x47)[0x400e8ac7]
>>>>> /opt/OpenOffice.org/program/soffice.bin(_ZN7desktop7Desktop4Ma
>>>>> inEv+0xda9)[0x8064739]
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(_Z6SVMainv+0x49)[0x
>>>>> 400edcb9] 
>>>>> /opt/OpenOffice.org/program/libvcl645li.so(main+0x36)[0x402da1b6]
>>>>> /lib/libc.so.6(__libc_start_main+0xb8)[0x413c9488]
>>>>> /opt/OpenOffice.org/program/soffice.bin(_ZN6Window11RequestHel
>>>>> pERK9HelpEvent+0x39)[0x805e781]
>>>>> Aborted
>>>>>
>>>>>
>>>>> Ricardo Lopes wrote:
>>>>>
>>>>>  
>>>>>       
>>>>>
>>>>>> Your code works fine on my machine.
>>>>>>
>>>>>> Windows XP SP 1
>>>>>> OpenOffice 1.1.3 Portuguese
>>>>>> POI-cvs-2004-12-14
>>>>>>
>>>>>> Probably is a linux OpenOffice issue.
>>>>>> I can't test your attached file because it didn't came with the
>>>>>> message.
>>>>>>
>>>>>> Xavier Vanderstukken wrote:
>>>>>>
>>>>>>    
>>>>>>         
>>>>>>
>>>>>>> I use this very simple code to create an empty xls file.
>>>>>>>
>>>>>>> HSSFWorkbook wb = new HSSFWorkbook();
>>>>>>> FileOutputStream fileOut = new FileOutputStream(path);
>>>>>>> wb.write(fileOut);
>>>>>>> fileOut.close();
>>>>>>>
>>>>>>> When I try to open it with OpenOffice 1.1.3 I receive the 
>>>>>>>           
>>>>>>
>>> following   
>>>
>>>>>>> message :
>>>>>>>
>>>>>>> An unrecoverable error has occured.
>>>>>>>
>>>>>>> An the file can not be opened.
>>>>>>> However I have no problem to open it with Microsoft Excel.
>>>>>>>
>>>>>>> My operating system is Gentoo Linux.
>>>>>>>
>>>>>>> I attach the generated Excel file
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>      
>>>>>>>           
>>>>>>
>>>>> ------------------------------------------------------------
>>>>>       
>>>>
>>> ---------
>>>   
>>>
>>>>>  
>>>>>       
>>>>>
>>>>>>> ---
>>>>>>>
>>>>>>>
>>>>>>>      
>>>>>>>           
>>>>>>
>>>>> ------------------------------------------------------------
>>>>>       
>>>>
>>> ---------
>>>   
>>>
>>>>>  
>>>>>       
>>>>>
>>>>>>> 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
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message