Issue with cell range not being set correctly with write_array_formula()

[jmcnamara]

Issue reported on StackOverflow.

The following doesn't write the array formula in cell B1 of Sheet2. This is due to a bug in the range calculation. The bug is hidden in Sheet1 due to other cells setting the range.

import xlsxwriter

workbook = xlsxwriter.Workbook('test.xlsx')

sheet1 = workbook.add_worksheet('Sheet1')
sheet2 = workbook.add_worksheet('Sheet2')

sheet1.write('A1', 'Foo')
sheet1.write('A2', 'Bar')

sheet1.write_array_formula('B1:B2', '{=Sheet1!$A$1:$A$2}')
sheet2.write_array_formula('B1:B2', '{=Sheet1!$A$1:$A$2}')

workbook.close()

[jmcnamara]

Fixed in XlsxWriter version 1.3.1.