poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Xavier Vanderstukken ...@ionicsoft.com>
Subject Re: AW: AW: OpenOffice 1.1.3 can not read a xls file generated with hssf
Date Tue, 04 Jan 2005 07:58:14 GMT
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


Mime
View raw message