User Activity

  • Posted a comment on discussion General Discussion on SimpleXlsxWriter

    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.

  • Modified a comment on discussion General Discussion on SimpleXlsxWriter

    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...

  • Modified a comment on discussion General Discussion on SimpleXlsxWriter

    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...

  • Modified a comment on discussion General Discussion on SimpleXlsxWriter

    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...

  • Modified a comment on discussion General Discussion on SimpleXlsxWriter

    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...

  • Modified a comment on discussion General Discussion on SimpleXlsxWriter

    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...

  • Modified a comment on discussion General Discussion on SimpleXlsxWriter

    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...

  • Modified a comment on discussion General Discussion on SimpleXlsxWriter

    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...

View All

Personal Data

Username:
dizzy1984
Joined:
2023-07-29 16:27:02.625000

Projects

  • No projects to display.

Personal Tools

MongoDB Logo MongoDB