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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



------------------------------------------------------------

---------




To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


------------------------------------------------------------

---------


To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to