Hi,
We are exploring Aspose for the product which we are building. During exploration I found that when we protect a structure of workbook, we were not able to open that workbook in the excel online!
Attached is the test program I used. When I upload the output of this program AsposeProtectedWorkbook.xlsb to sharepoint and try to open it asks me for password and when I enter password, it throws error that the password is wrong (The password I entered is correct and works when I open the same with desktop excel). Below is the screenshot of error. The thing is it shouldn’t even ask me for password, because I have only locked the structure of the workbook and not everything. Moreover, the workbook opens well in desktop excel. Can you please let me know if I am doing something wrong or is it a bug in Aspose?
The Program I used:
static void Main(string[] args)
{
Workbook wbk = new Workbook();
wbk.Protect(ProtectionType.Structure, “p”);
wbk.Save(".\\" + "AsposeProtectedWorkbook.xlsb", SaveFormat.Xlsb);
wbk.Dispose();
}
Error:
Aspose.png (367.9 KB)