Ooo_extensions/OooCalcBase.py at master · carlfahl/Ooo_extensions · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
#
# OooCalcBase -
#
# Copyright 2013 Fahlstrom Research LLC
#
# Author : Carl A. Fahlstrom
#

import re
from utils_fr_ooo import string2num

class OooCalcBase(OooBase):
	'''
	'''

	def __init__(self):
		'''
		'''

		super(OooCalcBase, self).__init__()
		self.model.enableAutomaticCalculation(False)
		self.sheets = self.model.getSheets()
		self.calc_sheet = self.sheets.Sheet1
		self.cursor = None

	def get_rowcol(self, str1, str2):
		'''
		'''

		pattern_num = re.compile(r'[0-9]+')
		pattern_let = re.compile(r'[A-Z]+')
		try:
			if pattern_let.search(str1):
				colnum = string2num(str1)
			else:
				if pattern_num.search(str1):
					colnum = int(str1)
		except:
			print "Setting column integer failed"
			pass
		try:
			if pattern_num.search(str2):
				rownum = int(str2)
		except:
			pass

		return colnum, rownum

	def run_recalc(self):
		'''
		'''

		self.model.calculateAll()

	def set_cursor(self, num1, num2, num3, num4):
		'''
		'''

		self.cursor = self.calc_sheet.getCellRangeByPosition(num1, num2, num3, num4)