Sorry, I forgot to mention that I am using the latest nightly build from 
version 1.6.0.


Rudi

Thanks, the stack trace is all i needed. Why oh why doesnt netbeans have a "Find
Use" button?? :)
Will fix in a couple of hours. 

Fixed. Namerecord is now resilient against unknown ptgs. Will write back exactly
what is read, unless record changed from usermodel, in which case new (correct)
rec ord will be written back. getReference on namerecord will yeild "#REF!" in
these cases. The Ptgs that are missing as far as namerecord is concerned is
primarily the  error ptgs (RefErr, AreaErr, RefErr3d and AreaError3d). While we
will add these ptgs later, we are still pretty much functionally complete at the
moment. 

Rudolf, will you please cross check with you sheet? thanks. (get CVS HEAD,  or
get a new nightly tomorrow)

Even better, if it is possible for you to send us the sheet causing the error,
we can add it to our unit tests. 

Created attachment 2112 [details]
ZIP-file containing trouble-causing spreadsheet

The problem has gone away with yesterday's nightly build, so the error seems to 
be fixed. However, I do not get any rows out of my spreadsheet. It says, it has 
0 rows in it. Shall I open a new bug for this problem?

Well, your sheet seems to have lots of relational operations which we dont
support at the moment. However, the idea is that POI gives you all the other
stuff as it is, irrespective of what it cant understand. So this would be a bug.
Hold on for a moment, let me check. 

I can successfully run you file through formula viewer. So the problem must be
elsewhere. investigating. 

your formula has some kind of hidden sheet which is what you get at
wb.getSheetAt(0). try wb.getSheetAt with 1,2,or 3 which will give you rows 88,48
and 44 respectively. 

I have tried as suggested (reading sheets 1, 2 or 3) but end with a range check 
exception from ArrayList, since the workbook has only one sheet listed (the 
size property equals 1).

Did you write any code to show my sheets or did you use another tool? 

Please verify again.

The follwoing test passes with the file you have attached above!

  public void testReadComplicated()
        throws java.io.IOException
    {
        String filename = System.getProperty("HSSF.testdata.path");

        filename = filename + "/Ziegaus.xls";
        java.io.FileInputStream stream   = new java.io.FileInputStream(filename);
        org.apache.poi.poifs.filesystem.POIFSFileSystem fs       = new
org.apache.poi.poifs.filesystem.POIFSFileSystem(stream);
        HSSFWorkbook    workbook = new HSSFWorkbook(fs);
        HSSFSheet       sheet    = workbook.getSheetAt(1);

        assertTrue("sheet has more than one row",sheet.getLastRowNum()>0);
        sheet = workbook.getSheetAt(2);
        assertTrue("sheet has more than one row",sheet.getLastRowNum()>0);
        sheet = workbook.getSheetAt(3);
        assertTrue("sheet has more than one row",sheet.getLastRowNum()>0);
        stream.close();
    }

Please remember that excel can apply strange optimisations each time you save
the file (unlike poi, its not consistent :) so ensure that you are testing with
exactly the same file. 

Forgot to add, the test FAILS if i do 

sheet = workbook.getSheetAt(0);
assertTrue("sheet has more than one row",sheet.getLastRowNum()>0);

Hm, very strange. What version do you use for your test? My testing code is 
very similiar to yours, I just do not use assert statements.

I used the latest nightly build and still get this problem, that I have only 
one sheet. If I try to access sheet 1 (getSheetAt(1)), I get an exception.
I verified that the file is in fact identically with the one I sent to you. I 
did not touch the file with Excel since June, 3rd.

Can I check which version I do effectively use? Is there an internal version 
number?

Rudi


PS: My test code is as follows:

  POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream
("d:/workbook.xls"));
  HSSFWorkbook wb = new HSSFWorkbook(fs);
  HSSFSheet sheet = wb.getSheetAt(1);  // here I get an exception, because only 
one sheet is found
  HSSFRow row = sheet.getRow(0);
  HSSFCell cell = row.getCell((short) 0);

hmm.. very strange indeed. You must be using the the correct version, because my
last commit fixed the exception on reading files with name records (the orig
bug). So we are using the same versions.  All i can think of (apart from a
gremlin :-) is that the file you have attached here is not the same as the one
you are using. The sheet u have attached here is called Ziegus.xls , and shows
three sheets called Zeiterfassung , Beispiel , HILFESTELLUNG. 

Can u try debugging thru the HSSFWorkbook object. 

Sorry, I found a problem in my code. During all the tests I ran, I switched to 
another file. Unfortunately I did not throw out the "ziegaus.xls", but only 
made a comment to eliminate it. 

So I did not realize that I was in fact using a COMPLETELY WRONG file.

Sorry for the inconvenience I made and thanks a lot for the bug you fixed.

Rudi

Thanks. closing.