I have worked with HSSF quite a bit and have many functionalities that work; however, I have run into a problem reading in the workbook when the file was created using Open Office on a Linux machine. I couldn't find any issues that dealt with Excel files that weren't generated using Microsoft Office, but I have a good feeling you can't open a file that was created in Open Office. I can tell you that I copied the information from the file created in Open Office, copy and pasted into an Excel sheet created in Microsoft Office and that worked fine. Thanks for your help and/or comments.
It usually impossible to debug these errors without having a testcase. Could you please attach a sheet that exhibits the error you cite? In general, several sheets created by OO have been succesfully opened with poi.
Created attachment 12050 [details] Excel file in which workbook won't load.
Created attachment 12051 [details] Same info, but this one works
Which version of openoffice did you use to create this file?
Works as of 12Jan2007, Testcase added. http://issues.apache.org/bugzilla/show_bug.cgi?id=41366