Excel insert rows to Table breaks table and formulas
I have a table in Excel that has formulas in half the columns. When I add a row in excel, the formulae are copied into the appropriate cells, and then I enter data into the other cells.
When I add rows to table via the Flow Excel Action "Add Rows", the rows are added below the table--where the footer is summing totals. This breaks the formulas in the footer.
Further, when I leave the columns that have existing formulas blank in Flow, they default to '0's. I'd like to be able to add rows without values and have those columns left empty. Which I hope/assume would follow the default Excel behavior of copying over formulas.
Finally, because of at least one of the above behaviors, my Excel file was "broken" and had to be repaired when I opened it. And of course, all the footer formulas were broken.