Apache OpenOffice Community Forum

Posted: **Fri May 27, 2011 1:27 pm**

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

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

Posted: **Fri May 27, 2011 2:26 pm**

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

Posted: **Sat May 28, 2011 7:22 am**

FJCC wrote: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!

Apache OpenOffice Community Forum

[Solved] Hide all columns

[Solved] Hide all columns

Re: Hide all columns

Re: Hide all columns