# -*- coding: iso-8859-1 -*-

#. // _ca_SheetGrid.py

#. // Quadrille la feuille.
def ca_SheetGrid( oSheet ):
   oRange = oSheet.getCellRangeByPosition( 0, 0, 1023, 1048575 ) # // Max col - 1 et max row - 1
   oRange.setPropertyValue( "TopBorder"   , [ 0, 0, 2, 0 ] )
   oRange.setPropertyValue( "BottomBorder", [ 0, 0, 2, 0 ] )
   oRange.setPropertyValue( "LeftBorder"  , [ 0, 0, 2, 0 ] )
   oRange.setPropertyValue( "RightBorder" , [ 0, 0, 2, 0 ] )
   oRange = None
   return 0

'''
Dernière modification : 2022-02-20

[Exemple]

import sys
sys.path.append( "modules" )

from _ca_SheetGrid import ca_SheetGrid # // Quadrille la feuille.

from _lo_LibreOfficeNew import lo_LibreOfficeNew # // Ouvre Libre Office.
from _lo_MakeProperty   import lo_MakeProperty   # // Créer une propriété Libre Office.

oServiceManager = lo_LibreOfficeNew()
if oServiceManager is None:
   quit()

args1    = lo_MakeProperty( oServiceManager, "Hidden", False )
oDesktop = oServiceManager.createInstance( "com.sun.star.frame.Desktop"  )
oDoc     = oDesktop.loadComponentFromURL( "private:factory/scalc", "_blank", 0, [ args1 ] )
oSheet   = oDoc.GetSheets().GetByIndex( 0 )

ca_SheetGrid( oSheet )

oServiceManager = None

[/Exemple]
'''