With Aspose.Cells properties updates are blocked due to Secutiy Warnings

Aspose.Cells Product Family
1

Currently we are using Aspose.Word for document properties update which is being a successful implementation and our functional users wants to extent the similar functionality with MS Excel.

Issue description:

  1. Using Aspose.cells API to update the properties in excel sheets.
  2. Post updating the properties, properties are getting updated to the excel, but the security warning (like enable content macros are disabled) in the excel is blocking the updates to the referenced places in all the sheets, which looks like the referenced places are not getting reflected even the core properties are updated in the excel.
    Second step for this process is to generate a PDF out of the updated excel. Since the properties are not reflected to the refrenced places in sheets, user needs to download the file, enable the content and update the properties manually and checkin the file for PDF generation.

Ask;
Is there any API to skip the security warning to disable any security warnings in the excel to update the properties seamlessly. FYI, we have used setEnableMacro API to overcome this issue, but its not helping out.

Sample files attached.

Thanks.

screenshot2.png (28.7 KB)

screenshot1.png (31.4 KB)

31130372.zip (96.7 KB)

2

@Sai_Prasad,

I think you may try to set relevant settings/options in MS Excel (e.g., 2019) manually to skip/remove those security warnings and other configurations. Please note, these are application level settings and nothing to do with Aspose.Cells which is just file format API:

  1. Click File|Options menu. Now select “Trust Center” from “Excel Options” dialog box.
  2. Click “Trust Center Settings” button to open its dialog.
  3. On the Trust Center dialog box, select “Message Bar” from left frame and on the right frame, click “Never show information of blocked content”.
  4. Similarly on the Trust Center dialog box, select “Macro Settings” from the left frame and on the right frame, select Enable all macros… option. Also, check bottom checkbox if required.

Now open the (output) Excel file into MS Excel and everything should be Ok.

Hope, this helps a bit.