I am very often using the below functionnality to save time in formatting tables, benefitting of the advanced formulas functionalities.
Nevertheless, i am regularly facing the below issue.
The situation :
In this example i have the below table formatted :
I am adding a row at the botom of the table :
As you can see, the row is automatically formatted, but instead of applying the expected format, the added row is blue....this blue color is coming from a row i had into my initial table before i converted it as an "Excel formatted table"....
If I insert a row in the middle of the table, the row is properly formatted.
In this example this is the color of the row that is not as expected but i faced some different cases, such as : "the dropdown list is not inserted when i add a row"....
What i would like ?
Know where i can modify the row used as a "template" to format the inserted row into my table. So that i can adjust it and avoid the issue i face