EnableOutlining

Aspose.Cells Product Family
1

Is there a property in Aspose to enable outlining like in Excel automation:

Sub test()
    Dim ws As Worksheet
    Set ws = ActiveSheet
    '                                               Here
    ws.Protect WorksheetPassword, True, True, True, True, False, False, False, False, False, False, False, False, True, True, True
    ws.EnableOutlining = True
    
End Sub

Thanks,
Dean Kinnear

2

@Moonglum
It‘s the feature of VBA and it only works in current application .
Please check Book1.zip (13.8 KB)

If you click the button, the worksheet is protected and the outlining is enabled. But if you save the file, then re-open it with MS Excel, you will the outlining is disabled again.
So I do not think we can support it by changing setting in the file.
If you can make outlining always enabled when the worksheet is protected, please share file here.

3

We are building workbook on server side, then downloading to client. The value would still be there, correct? It is only on close that the workbook loses the runtime property.
If feasible, can I request Aspose.Cells add this method?

Thanks,
Dean Kinnear

4

@Moonglum
No.
In fact, there is no such value in the file.
It only occur in the view of MS Excel application when you click that button in book1.xlsm.
If the file is closed, it will disappear too. So when the file is reloaded in MS Excel, outlining is disabled again.