It is a Defined Table! When designed properly, all formulas, formats, or whatever, are applied automatically to new rows. The only condition for this is, that every column can in entire datarange contain only single formula, single format, or whatever.

Some of your Table columns contain 2 different formulas or formats! So it is for Excel to decide - and who knows what the decision will be!