def addRow(self):
l = []
self.rowNumber += 1
for c in range(self.columnNumber):
l.append(Cell(self.rowNumber - 1, c))
l[-1].name = columns_labels.getLabel(self.labels, c + 1) + str(self.rowNumber)
self.matrix.append(l)
def __init__(self):
self.labels = columns_labels.generate(1) # Noms des colonnes
self.matrix = [[Cell(0, 0)]] # Initialisation de la matrice
self.matrix[0][0].name = columns_labels.getLabel(self.labels, 0) + str(1)
self.columnNumber = 1
self.rowNumber = 1
self.saved = True
self.title = "Nouvelle feuille"
def reset(self, initalRows, initalColumns):
self.__init__()
self.subsitute([[Cell(0, 0)]])
self.getCell(0,0).name = columns_labels.getLabel(self.labels, 0) + str(1)
self.addColumns(initalColumns - 1)
self.addRows(initalRows - 1)
self.columnNumber = initalColumns
self.rowNumber = initalRows
def horizontalPull(inputDecomposed, columns, labels):
elementList = copy.copy(inputDecomposed[0]) # Pour ne pas changer sur place la decomposition initiale
elementType = inputDecomposed[1]
for i in range(len(elementList)):
if elementType[i] == 'cell':
if elementList[i][0] != '$':
letters = ''.join([char for char in elementList[i] if char.isalpha()])
n = columns_labels.getColumn(letters) # On recupere le label de la colonne pour l'itérer columns fois
newletters = columns_labels.getLabel(labels, n + columns)
elementList[i] = newletters + elementList[i][len(letters):] # On change la partie des lettres
return ''.join(elementList)
def addColumn(self):
self.columnNumber += 1
for r in range(self.rowNumber):
self.matrix[r].append(Cell(r, self.columnNumber - 1, ))
self.matrix[r][-1].name = columns_labels.getLabel(self.labels, self.columnNumber) + str(r + 1)