realgz / excellibrary

Automatically exported from code.google.com/p/excellibrary
0 stars 0 forks source link

Corrupt file after modifying #130

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?

1. Create Excel file in 2010 and save as 97-2003 format
2. Modify cell like this:
        Try
            Dim WorkBook As New ExcelLibrary.SpreadSheet.Workbook
            WorkBook = ExcelLibrary.SpreadSheet.Workbook.Load("C:\Users\Archie\Documents\TempTest2.xls")
            WorkBook.Worksheets(0).Cells(0, 0).Value = "added text"
            WorkBook.Save("C:\Users\Archie\Documents\TempTest3.xls")
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

3. New sheet (TempTest3.xls) is not readable in Excel

What is the expected output? What do you see instead?
Open the new file in Excel, but will not open because it is corrupt

What version of the product are you using? On what operating system?
Windows 7, latest DLL

Original issue reported on code.google.com by ajacobs4...@gmail.com on 24 Apr 2012 at 10:54

Attachments: