Hi

It looks like you have hit a bug in ArrayPtg [1] parsing. I think you should
file a bug with your sample xls file attached [2].

I hope one of the poi devs will be able to better comment on the issue.

Meanwhile try asking your user to create there worksheet without using Array
formulas, see:

http://www.cpearson.com/excel/array.htm
http://www.ozgrid.com/Excel/arrays.htm

[1]
http://svn.apache.org/viewvc/jakarta/poi/trunk/src/java/org/apache/poi/hssf/
record/formula/ArrayPtg.java?view=markup

[2]
http://issues.apache.org/bugzilla/buglist.cgi?product=POI

Regards,
Tahir Akhtar
> -----Original Message-----
> From: Sara Uppalapati [mailto:suppalap@us.i...]
> Sent: Wednesday, April 25, 2007 6:06 PM
> To: POI Users List
> Cc: 'POI Users List'
> Subject: RE: Please help - unknown grbit '16'
>
> Hi Tahir,  Thanks for your response.  I opened user's version of excel
> file on my machine(which has office 2000) and saved as of type Microsoft
> Excel 97-2000 & 5.0/95 Workbook.  I am still geting same errors when I
> tried to run my program with that excel file.
>
> Sara
>
>
>
>
> "Tahir Akhtar" <tahir@spec...>
> 04/25/2007 01:52 AM
> Please respond to
> "POI Users List" <poi-user@jaka...>
>
>
> To
> "'POI Users List'" <poi-user@jaka...>
> cc
>
> Subject
> RE: Please help - unknown grbit '16'
>
>
>
>
>
>
> It could be because of version incompatibility. May be user machine have
> upgraded to newer version of excel. Try opening the file in excel and
> save-as a new file paying attention to format (Excel 97 etc). Then try
> running your program on newly saved file.
>
> > -----Original Message-----
> > From: Sara Uppalapati [mailto:suppalap@us.i...]
> > Sent: Tuesday, April 24, 2007 11:28 PM
> > To: POI Users List
> > Cc: POI Users List
> > Subject: RE: Please help - unknown grbit '16'
> >
> > Hi Justin,  Thank you very much for the response.  This Excel file is
> not
> > password protected.  I double checked.
> >
> > FYI - My application runs on HP UX and downloads the excel file everyday
> > from user machine(Windows) and reads it.
> >
> > Sara Uppalapati
> > IBM Global Services
> > 513 277 4869
> > suppalap@us.i...
> >
> >
> >
> > "Justin Warren" <justin_warren@cons...>
> > 04/24/2007 03:20 PM
> > Please respond to
> > "POI Users List" <poi-user@jaka...>
> >
> >
> > To
> > "POI Users List" <poi-user@jaka...>
> > cc
> >
> > Subject
> > RE: Please help - unknown grbit '16'
> >
> >
> >
> >
> >
> >
> > I get a similar error when I attempt to read a password protected Excel
> > file. I'm not sure if that's what you have, but it's a possibility.
> >
> > -----Original Message-----
> > From: Sara Uppalapati [mailto:suppalap@us.i...]
> > Sent: Tuesday, April 24, 2007 2:53 PM
> > To: poi-user@jaka...
> > Subject: Please help - unknown grbit '16'
> >
> > Hi,  We are using POI_3.0_Alpha.jar file and trying to read spread sheet
> >
> > in the code.  It was working fine until few days back.  Spread sheet was
> >
> > updated with more tabs and more data and after that getting below
> > errors.
> > I spent long time and still no clue.  Spread sheet was updated on
> > windows
> > machine with office 2003.  Please help.
> >
> > Exceptions:
> > java.lang.reflect.InvocationTargetException
> >         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> >
> > Method)
> >         at
> > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
> > ccessorImpl.java:39)
> >         at
> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
> > tructorAccessorImpl.java:27)
> >         at
> > java.lang.reflect.Constructor.newInstance(Constructor.java:274)
> >         at
> > org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java
> > :213)
> >         at
> > org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav
> > a:149)
> >         at
> > org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:183)
> >         at
> > org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:230)
> >         at
> > org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:211)
> >         at ReadInvSheet.main(ReadInvSheet.java:47)
> > Caused by: org.apache.poi.hssf.record.RecordFormatException: Unknown
> > grbit
> > '16'
> >         at
> > org.apache.poi.hssf.record.formula.ArrayPtg.readTokenValues(ArrayPtg.jav
> > a:98)
> >         at
> > org.apache.poi.hssf.record.formula.Ptg.createParsedExpressionTokens(Ptg.
> > java:109)
> >         at
> > org.apache.poi.hssf.record.NameRecord.fillFields(NameRecord.java:739)
> >         at org.apache.poi.hssf.record.Record.<init>(Record.java:55)
> >         at
> > org.apache.poi.hssf.record.NameRecord.<init>(NameRecord.java:142)
> >         ... 10 more
> > Error in Reading : org.apache.poi.hssf.record.RecordFormatException:
> > Unable to c
> > onstruct record instance, the following exception occured: null
> >
> >
> > Code snippet:
> > try
> >             {
> >               fs = new FileInputStream(fileToBeRead);
> >               System.out.println(" file read" );
> >               FI = new FileInputStream(propertyFile) ;
> >               FW = new FileWriter(fileToBeWritten);
> >             }
> >           catch(FileNotFoundException e)
> >             {
> >               throw new Exception(e);
> >             }
> >           catch(IOException e)
> >             {
> >               throw new Exception(e);
> >             }
> >           System.out.println("Before HSSFWorkbook Initiation");
> >           HSSFWorkbook workbook = new HSSFWorkbook(fs);
> >           System.out.println("After HSSFWorkbook Initiation");
> >
> >
> > Exception are right at initializing HSSFWorkbook() - HSSFWorkbook
> > workbook
> > = new HSSFWorkbook(fs);
> >
> > I really appreciate the help.
> >
> > Thanks,
> > Sara
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jaka...
> > Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> >
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jaka...
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>




---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jaka...
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/