Attachment 49738 Details for Bug 39680 – a python listener macro that monitors A1 and adds/removes sheets based on its values

a python listener macro that monitors A1 and adds/removes sheets based on its values

monitorCellsForSheets.py (text/x-python), 2.41 KB, created by Onyeibo on 2011-07-29 23:05:32 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Onyeibo

Created: 2011-07-29 23:05:32 UTC

Size: 2.41 KB

patch

obsolete

>import uno, unohelper
>from com.sun.star.util import XModifyListener
>
>ctx = uno.getComponentContext()
>odoc = XSCRIPTCONTEXT.getDocument()
>osheets = odoc.getSheets()
>
>class myListener(XModifyListener, unohelper.Base):
>    diff = None
>    hotSheet = None #remove later
>    formerVal = None
>    numOfSheets = None
>    outputCell = None #remove later
>    minSheets = 2
>
>    def __init__(self,currentVal):
>        #self.doc = None
>        self.formerVal = currentVal #TODO: code to check that value is correct
>        self.numOfSheets = osheets.getCount()
>        self.hotSheet = osheets.getByName('Sheet1') #remove later
>        self.outputCell = self.hotSheet.getCellRangeByName('E1') #for feedback-remove later
>    
>    def modified(self, oEv):
>        currentVal = oEv.Source.Value
>        self.diff = currentVal - self.formerVal
>        if (self.formerVal < self.minSheets) and (currentVal < self.minSheets):
>            self.outputCell.FormulaLocal = "STILL AT MINIMUM" #pass
>        elif self.diff > 0:
>            self.outputCell.FormulaLocal = "ADDED " + str(self.diff)
>            #for x in range(0, abs(self.diff)):
>                #osheets.copyByName('Sheet2','sheet' + str(self.numOfSheets+1),\
>                #self.numOfSheets)
>                #self.numOfSheets+=1
>        elif self.diff < 0:
>            self.outputCell.FormulaLocal = "REMOVED " + str(abs(self.diff))
>            #for x in range(0, abs(self.diff)):
>                #lastSheetName = osheets.getByIndex(self.numOfSheets-1).Name
>                #osheets.removeByName(lastSheetName)
>                #self.numOfSheets-=1
>        else: #zero difference
>            self.outputCell.FormulaLocal = "NOTHING TO DO" #pass
>        self.formerVal = currentVal
>        
>    def disposing(self, oEv):
>        pass
>               
>
>def Start():
>    #mri(osheets)
>    osheet =  osheets.getByName('Sheet1')
>    ocell = osheet.getCellRangeByName('A1')
>    startValue = ocell.Value
>    monitor = myListener(startValue)
>    ocell.addModifyListener(monitor)
>
>def mri(target): 
>    mri = ctx.ServiceManager.createInstanceWithContext("mytools.Mri",ctx)
>    mri.inspect(target)
>
># the helper implements all the vanilla UNO-interfaces that belong to every 
># object. You may override them. See source code of unohelper module.
>g_ImplementationHelper = unohelper.ImplementationHelper()
>g_ImplementationHelper.addImplementation(
>    myListener,
>    'com.sun.star.util.XModifyListener',()
>)
>g_exportedScripts = Start,

Actions: View

Attachments on bug 39680: 49738

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.