OpenOffice.info

Code: Alles auswählen

import re

rex = re.compile(r'^(\w{3})(\d{2})(\d{3})(\d{2})(\d{3})(\d)$')

def specialformat(event):
    for cell in itersingle(event):
        try:
            if not cell.Tokens and rex.match(cell.String):
                cell.setString( rex.sub(r'\1-\2-\3,\4-\5-\6', cell.String))
        except:
            pass


def itersingle( selection ):
    for r in xrange(selection.Rows.getCount()):
        for c in xrange(selection.Columns.getCount()):
            yield selection.getCellByPosition(c, r)

Code: Alles auswählen

import re
rex = re.compile(r'(\w{3})(\d{2})(\d{3})(\d{2})(\d{3})(\d)')

def specialformat(context):
    context.setString( rex.sub(r'\1-\2-\3,\4-\5-\6',
                                context.getString()))