Stream is not closing after an ArgumentOutOfRangeException exception

What steps will reproduce the problem?
1. Try to open a non-Excel file(e.g. a comma delimited file using xls 
extension.)

2. Handle the ArgumentOutOfRangeException

3. Try to open the same file by using Stream class

What is the expected output? What do you see instead?
The CompoundDocument.Open method throws an ArgumentOutOfRangeException but it 
do not release the loaded file in the Open method. Therefore, when trying to 
open the same file using Stream class, I see the exception:

IOException: The process cannot access the file 'filename' because it is being 
used by another process

I would expect a null value as output.

What version of the product are you using? On what operating system?
FileName: ExcelLibrary.dll   
Release Date: Jul 2011

Windows 7 SP1
Windows Server 2008 R2 SP1

georgeguitar.jorge@gmail.com

WORKAROUND:
        public static CompoundDocument Open(string file)
        {
            FileStream stream = File.Open(file, FileMode.Open, FileAccess.ReadWrite, FileShare.Read);
            BinaryReader reader = new BinaryReader(stream);
            FileHeader header = ReadHeader(reader);

            int sectorSize = (int)Math.Pow(2, header.SectorSizeInPot);

            CompoundDocument document = null;

            if (sectorSize > 0)
            {
                document = new CompoundDocument(stream, header);
                if (!document.CheckHeader()) return null;

                document.ReadDirectoryEntries();
            }
            else
            {
                stream.Close();
                stream.Dispose();

                reader.Close();
            }

            return document;
        }

Original issue reported on code.google.com by georgegu...@gmail.com on 10 Jan 2013 at 9:19

hodzung / excellibrary

Stream is not closing after an ArgumentOutOfRangeException exception #141