Excel doc opened in blocking Protected View after save

Aspose.Cells Product Family
1
Hello,

we've been working several years with Aspose, and are very happy with it.

However, something strange came up this week. It concerns an Excel document that is opened and saved by Aspose.Cells. The saved document cannot be opened in the normal mode. It is opened in protected view (with the red shield) and can not be edited. Seems like a validation error.

Attached you can find the document. The code which delivers the problem is as simple as:


class Program
    {
        static void Main(string[] args)
        {
            Aspose.Cells.License license = new Aspose.Cells.License();
            license.SetLicense("Aspose.Total.lic");

        Aspose.Cells.<span style="color:#2b91af;">Workbook</span> workbook = <span style="color:blue;">new</span> Aspose.Cells.<span style="color:#2b91af;">Workbook</span>(<span style="color:#a31515;">@"C:\</span><span style="color: rgb(163, 21, 21);">Temp</span><span style="color: rgb(163, 21, 21);">\test.xls"</span>);<br>            workbook.Save(<span style="color:#a31515;">@"C:\Temp\test_saved.xls"</span>, <span style="color:blue;">new</span> Aspose.Cells.<span style="color:#2b91af;">XlsSaveOptions</span>(Aspose.Cells.<span style="color:#2b91af;">SaveFormat</span>.Excel97To2003));
    }
}</pre></div><div><br></div><div><br></div><div>Further analysis showed that if either the autofilter is not set, or if the merged cells in the document are unmerged, the document can be opened in a normal way.</div><div><br></div><div>Thanks for your feedback on how to correct this.</div><div>Best regards,</div><div>Stefaan Verleye</div>
2

Hi Stefaan Verleye,


Thanks for the template file and details.

After an initial test, I observed the issue as you mentioned by just opening and
re-saving the Excel file via Aspose.Cells APIs. When I opened the output
file into MS Excel 2010, it is opened in protected view, see the screen
shot here:


http://prntscr.com/5ph8a9


e.g


Sample code:


Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook("e:\\test2\\test.xls");
workbook.Save("e:\\test2\\outtest_saved.xls");


Well, you may simply close this message to work with the file in Ms Excel. I have logged a ticket with an id “CELLSNET-43275” for your issue. We will look into it soon.


Once we have any update on it, we will let you know here.

Thank you.

3

Hi Stefaan,


This is to bring in your knowledge that we have fixed the problem logged earlier as CELLSNET-43275 in our bug tracking system. The fix will be delivered to you with the upcoming release of Aspose.Cells for .NET after incorporating other enhancements and performing QA over it. Once the fix is available for public use, we will notify you here along with the download link to the upgraded API.

Thank you for your patience with us.
4

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.3.1.4 and let us know your feedback.

5

The issues you have found earlier (filed as CELLSNET-43275) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.