Activity for Alexander Arkhipov
-
Alexander Arkhipov posted a comment on discussion General Discussion
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...
-
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...
-
It is possible, but i have to do it every time? Can it be fixed?
-
Hello and thanks for excel writer library. The minimal code to reproduce the issue is this: using namespace SimpleXlsx; CWorkbook wb; CWorksheet& ws = wb.AddSheet( L"отчет" ); ws.BeginRow( 23.25 ); ws.AddCell( L"=SUM(C3:C4)" ); ws.EndRow(); wb.Save( "1.xlsx" ); It saves file, file can be opened normally, but after user closes file (no changes were made), excel asks if he should save changes. I attached example.
1
