CalcBASIC: How to delete active sheet?

lonk · November 30, 2019, 10:18am

From the code:

ThisComponent.getCurrentController.getActiveSheet

How can I delete this active sheet ?

And if the active sheet was locked, how can I delete this locked active sheet ?

mikekaganski · November 30, 2019, 11:00am

schiavinatto · November 30, 2019, 11:38am

Sub RemoveByNamePlanS ( X As String)
'================================================|
thisComponent.getSheets.RemoveByName( X )
End Sub

lonk · November 30, 2019, 2:40pm

Thank you so much for your support.

Khob Khun Krab

SM_Riga · November 30, 2019, 10:58am

Hello @lonk

Example:

oSheet = ThisComponent.getCurrentController.getActiveSheet
sName = oSheet.Name
ThisComponent.Sheets.removeByName(sName)

Deletes sheets with isProtected = True property as well.

lonk · November 30, 2019, 2:37pm

Dear @SM_Riga, my life saver,

This is what I’m looking for.

Khob Khun Krab

lonk · December 1, 2019, 10:18am

One-lined code

ThisComponent.Sheets.removeByName(ThisComponent.getCurrentController.getActiveSheet.Name)