[Solved] Hide all columns

[antipod-sh]

Hi! My English is bad, sorry! )
I need to hide first column, but after the code processing all the columns are hiding.

Code: Select all

ServiceManager = CreateObject("com.sun.star.ServiceManager");
Desktop = ServiceManager.createInstance("com.sun.star.frame.Desktop");
Document = Desktop.LoadComponentFromURL("private:factory/scalc", "blank", 0, Array);
Sheets = Document.getSheets();
Sheet = Sheets.getByIndex(0);
Col = Sheet.Columns(0);
Col.IsVisible = 0;

1c7.7 -> OpenOffice 3.1

[FJCC]

The syntax Columns(0) is an OOo Basic shortcut for Columns.getByIndex(0). Does this version work?

Code: Select all

ServiceManager = CreateObject("com.sun.star.ServiceManager");
Desktop = ServiceManager.createInstance("com.sun.star.frame.Desktop");
Document = Desktop.LoadComponentFromURL("private:factory/scalc", "blank", 0, Array);
Sheets = Document.getSheets();
Sheet = Sheets.getByIndex(0);
Col = Sheet.Columns.getByIndex(0);
Col.IsVisible = 0

[antipod-sh]

The syntax Columns(0) is an OOo Basic shortcut for Columns.getByIndex(0). Does this version work?

Code: Select all

Col = Sheet.Columns.getByIndex(0);

Big thanks! It's work!