I've got a few workbooks which contains write protected sheets.
When I use the unprotect() method and save the workbook to a new file , the regular office 2000/ xp Excel allows writing.
However, when I open the same file in pocket Excel it says the workbook is still protected.
Dim excel As Aspose.Excel.Excel = New Aspose.Excel.Excel
Dim excelNew As Aspose.Excel.Excel = New Aspose.Excel.Excel
Dim fstream As FileStream = New FileStream("C:\\book1.xls", FileFormatType.Excel97, FileMode.Open)
Dim worksheet As Aspose.Excel.Worksheet = excel.Worksheets(0)
Dim worksheetNew As Aspose.Excel.Worksheet = excelNew.Worksheets(0)
Dim thePass As String = "xxx""
To replay this just create an new workbook with 1 sheet. Go to tools/protection/protectsheet..enter xxx and ok.
Run the above code and open the output file in a PocketPC.
Could it be that the evaluation warning is messing up this protection ?
Thanks in advance.