#142 importing and opening an xls file into the spreadsheet comp.

[Sam Chuang]

In zssdemo application, there is a problem when trying to import and then open an xls file that was prepared with OpenOffice.org spreadsheet application.(I tried version 3.1.1) This is true for both linux and windows xp versions of OpenOffice.org spreadsheet app. There is no problem when using xls files that was created with Microsoft Office Excel application (tried Excel 2007). Error message in Eclipse Galileo is like the following :

exception in importFromStream
Jan 22, 2010 2:09:17 PM org.zkoss.zk.ui.impl.UiEngineImpl handleError:1130
SEVERE: >>org.zkoss.zss.model.ModelException: Incorrect format at 2, charcter N in "GENERAL"
>> at org.zkoss.zss.model.impl.NumberFormatImpl.dispatchState(NumberFormatImpl.java:835)
>> at org.zkoss.zss.model.impl.NumberFormatImpl.parseChar(NumberFormatImpl.java:1014)
>> at org.zkoss.zss.model.impl.NumberFormatImpl.parse(NumberFormatImpl.java:1361)
>> at org.zkoss.zss.model.impl.NumberFormatImpl.parseFormat(NumberFormatImpl.java:327)
>> at org.zkoss.zss.model.impl.NumberFormatImpl.<init>(NumberFormatImpl.java:82)
>>...

I use ;
linux ubuntu 9.10 (karmic),
OpenOffice 3.1.1 ,
java version "1.6.0_0"
OpenJDK Runtime Environment (IcedTea6 1.6.1) (6b16-1.6.1-3ubuntu1)
OpenJDK Client VM (build 14.0-b16, mixed mode, sharing)
Eclipse Galileo Build id: 20090920-1017
apache-tomcat-6.0.20