Ok i understand your point. But my small project uses just formulas of type "=SUM("A1:C1")" so i will make some patches to calculate resulting value and store it.
Today i got some free time to investigate problem further. I created my test 1.xlsx with SimpleXlsxWriter, copyed it, and saved using excel (i am using excel 2010). Then i compared changes between these two files: It appears that they differs in two files: .xlsx\xl\workbook.xml original <calcPr calcId="124519"/> saved <calcPr calcId="145621"/> According to this calcid is a formulas engine id, if its lower than current, document formulas are recalculated. I think its OK to use 999999 to avoid recalculation...
Today i got some free time to investigate problem further. I created my test 1.xlsx with SimpleXlsxWriter, copyed it, and saved using excel (i am using excel 2010). Then i compared changes between these two files: It appears that they differs in two files: .xlsx\xl\workbook.xml original <calcPr calcId="124519"/> saved <calcPr calcId="145621"/> According to this calcid is a formulas engine id, if its lower than current, document formulas are recalculated. I think its OK to use 999999 to avoid recalculation...
Today i got some free time to investigate problem further. I created my test 1.xlsx with SimpleXlsxWriter, copyed it, and saved using excel (i am using excel 2010). Then i compared changes between these two files: It appears that they differs in two files: .xlsx\xl\workbook.xml original <calcPr calcId="124519"/> saved <calcPr calcId="145621"/> According to this calcid is a formulas engine id, if its lower than current, document formulas are recalculated. I think its OK to use 999999 to avoid recalculation...
Today i got some free time to investigate problem further. I created my test 1.xlsx with SimpleXlsxWriter, copyed it, and saved using excel (i am using excel 2010). Then i compared changes between these two files: It appears that they differs in two files: .xlsx\xl\workbook.xml original <calcpr calcid="124519"> saved <calcpr calcid="145621"> According to this calcid is a formulas engine id, if its lower than current, document formulas are recalculated. I think its OK to use 999999 to avoid recalculation...
Today i got some free time to investigate problem further. I created my test 1.xlsx with SimpleXlsxWriter, copyed it, and saved using excel (i am using excel 2010). Then i compared changes between these two files: It appears that they differs in two files: .xlsx\xl\workbook.xml original <calcpr calcid="124519"> saved <calcpr calcid="145621"> According to this calcid is a formulas engine id, if its lower than current, document formulas are recalculated. I think its OK to use 999999 to avoid recalculation...
Today i got some free time to investigate problem further. I created my test 1.xlsx with SimpleXlsxWriter, copyed it, and saved using excel (i am using excel 2010). Then i compared changes between these two files: It appears that they differs in two files: .xlsx\xl\workbook.xml original <calcpr calcid="124519"> saved <calcpr calcid="145621"> According to this calcid is a formulas engine id, if its lower than current, document formulas are recalculated. I think its OK to use 999999 to avoid recalculation...
Today i got some free time to investigate problem further. I created my test 1.xlsx with SimpleXlsxWriter, copyed it, and saved using excel (i am using excel 2010). Then i compared changes between these two files: It appears that they differs in two files: .xlsx\xl\workbook.xml original <calcpr calcid="124519"> saved <calcpr calcid="145621"> According to this calcid is a formulas engine id, if its lower than current, document formulas are recalculated. I think its OK to use 999999 to avoid recalculation...