There is a specific case we are having problems with Array Formulas. The case is that we are clearing the table (containing the array formula column) of all its rows except for the first row (where we are only clearing none-formula cells). When we call the ListObjects “.Sort()” (and only when we call it) saving the file causes the Array Formula to be lost.
I have attached a small project to demonstrate the issue. If you run this project and use the attached input file “input with Array Formula.xlsx” you will see that the column "Average Pay"s Array Formula is lost in the generated file.
NOTE: If you comment out the line of code “l.AutoFilter,Sorter.Sort();” and re-run the project, the generated file actually retains the formula.
Am I missing something that I should be doing to prevent lost of Array Formulas?