Viewing intermediate results
From Apache OpenOffice Wiki
This script was published by kilorun and at the OpenOffice Basic, Python, BeanShell, JavaScript Forum.
kilorun wanted to develop a Python macro embedded in a Calc document to scrape data from various web pages and paste some results in cells in the spreadsheet, without having to wait until the macro had finished before seeing the results.
Original code
import time def myTest3(): oDoc = XSCRIPTCONTEXT.getDocument() oSheets = oDoc.getSheets() mySheet = oSheets.getByName("Sheet1") # set up Status Indicator Controller = oDoc.getCurrentController() DocFrame = Controller.getFrame() oStatusIndicator = DocFrame.createStatusIndicator() oStatusIndicator.start( "", 1 ) mySheet.getColumns().removeByIndex(0, 1) oStatusIndicator.setText( "Process started" ) for i in range(0,5): oStatusIndicator.setText( "Processing: " + str(i) ) mySheet.getCellByPosition(0,i).Value = i time.sleep(1) oStatusIndicator.setText( "Process finished" )