Calc - Column/Row Headers from macro

View: New views
4 Messages — Rating Filter:   Alert me  

Calc - Column/Row Headers from macro

by Bart Aimar-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

can I swicth the "Column/Row Headers" visibility from macro ?


thanks for answers



Bart




--
------------------------------------------------
  Bartolomeo Aimar - architetto
  via Sant'Anselmo 27 - 10125 Torino (Italy)
  e-mail: bart.aimar@...
  web: http://aimar.mrjive.it
------------------------------------------------


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...


Re: Calc - Column/Row Headers from macro

by Bart Aimar-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message



Bart Aimar ha scritto:

> can I swicth the "Column/Row Headers" visibility from macro ?
>

Noway ?

Strange!

but may be due to my bad english...

I try to rephrase:

Is possible from macro to control the "Column/Row Headers" visibility?

(Like:
Tools > Options > OpenOffice.org Calc > View > Window > Column/Row Headers )

Thanks in advance,

Bart

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...


Re: Re: Calc - Column/Row Headers from macro

by Ariel Constenla-Haile :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello Bart,

On Monday 07 September 2009, 09:18, Bart Aimar wrote:
> Is possible from macro to control the "Column/Row Headers" visibility?
>
> (Like:
> Tools > Options > OpenOffice.org Calc > View > Window > Column/Row Headers
>  )

http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/SpreadsheetViewSettings.html#HasColumnRowHeaders

Supposing ThisComponent is a Calc doc., and it has a controller, you can do

ThisComponent.getCurrentController().setPropertyValue(_
"HasColumnRowHeaders", True)

Regards
--
Ariel Constenla-Haile
La Plata, Argentina

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...


Re: Re: Calc - Column/Row Headers from macro

by Bart Aimar-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Ariel Constenla-Haile ha scritto:
> Hello Bart,

hai Ariel


> http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/SpreadsheetViewSettings.html#HasColumnRowHeaders
>
> Supposing ThisComponent is a Calc doc., and it has a controller, you can do
>
> ThisComponent.getCurrentController().setPropertyValue(_
> "HasColumnRowHeaders", True)

Perfect! :-)

Thanks


Bart

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...