Apache OpenOffice Community Forum

Code: Select all

Sub PlusOne
oDoc = ThisComponent
oCell = oDoc.getCurrentSelection 
oCell.Value = oCell.Value + 1
End Sub

Code: Select all

Sub PlusOne
oDoc = ThisComponent
oSheet = oDoc.getSheets.getByName("Sheet1")
oCell = oSheet.getCellRangeByName("A1")
oCell.Value = oCell.Value + 1
End Sub

Code: Select all

#!/bin/bash
COUNTFILE=~/counter.txt
COUNTVAR=0

function finish {
    echo $COUNTVAR > $COUNTFILE
    echo -e "\nCaught EXIT and saved $COUNTVAR to $COUNTFILE"
}

trap finish EXIT

if [ -f $COUNTFILE ]; then COUNTVAR=`cat  $COUNTFILE`; fi
while true; do
    echo -e "Add integer to $COUNTVAR [default 1]: \c"
    read NUM
    if [ -z $NUM ]; then NUM=1; fi
    let COUNTVAR+=$NUM
done

Code: Select all

$ counter.sh
Add integer to 129 [default 1]: ads
Add integer to 129 [default 1]: gfds
Add integer to 129 [default 1]: 
Add integer to 130 [default 1]: 
Add integer to 131 [default 1]: 12
Add integer to 143 [default 1]: ^C
Caught EXIT and saved 143 to /home/username/counter.txt