Turn off Transition Formula Evaluation

Oct 15, 2013 at 4:38 PM
Hi, when i export using the example CreateEmptyExcelFile. I have noticed "transition formula evaluation" is checked by default export.

You can see this value by going to
Excel options > Advance >
and it's at the bottom.

Having this value checked is causing issues for me, can it be disabled?

Namely, the issue is when exporting a Date, if you F2 to edit the date, then push escape, the date will change to 1900/01/01. I believe this is because of this transition formula evaluation.

Many thanks,
Oct 16, 2013 at 9:13 AM
The solution was in the latest examples, i must have been using an older version.

((HSSFSheet)hssfworkbook.GetSheetAt(0)).AlternativeFormula = false;
((HSSFSheet)hssfworkbook.GetSheetAt(0)).AlternativeExpression = false;
Marked as answer by tonyqus on 10/26/2013 at 5:36 PM