poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andre Schild" <a.sch...@aarboard.ch>
Subject AW: AW: OpenOffice 1.1.3 can not read a xls file generated with hssf
Date Mon, 03 Jan 2005 17:35:39 GMT
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


Mime
View raw message