Forum Discussion
Pat-J
Jun 21, 2020Copper Contributor
L'insertion d'une ligne dans une table ne duplique pas les formules
Bonjour, Pour mieux gérer les données de mon tableur, j'ai transformé le contenu en table. J'avais compris que lorsque l'on insère une ligne dans un tableau, les formules et les MEFC étaient recond...
- Jun 24, 2020Hello there,
This is most likely an issue with the Table not recognizing the formula as a Calculated Column. This is something Excel senses when entering formulas, although there is an internal audit to determine the data type for a column. Before I tell you how to force this, there is the possibility of a setting being off, which you should check.
File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type:
Two settings reside here, ensure they're both checked. They are:
• Include new rows and columns in table
• Fill formulas in tables to create calculated columns
The latter of the above two items is the one you need checked for this specific issue. However, the former item should also be checked when working with Tables.
To ensure a Table column is recognized as a Calculated Column:
Copy the formula in desired column. Any row.
Select the entire column. Do not include headers or total row.
Clear contents. The keyboard 'Delete' key will do this, or right-click > clear contents.
Paste the formula into a single cell in desired column, confirm with ENTER.
The above should work for you. Ensure you are not filtering the Table or have any hidden rows when you do this.
Pat-J
Jun 25, 2020Copper Contributor
Thanks a lot !! Merci beaucoup, cela marche après avoir effacé les formules des cellules et copié ces formules dans les colonnes sans l'entête.
Et ce qui est bien aussi c'est que les mises en forme conditionnelles des colonnes restent aussi inchangées lorsque l'on insère une ligne.
Cela va bien me simplifier la tache ! Merci encore
Patrick
Zack Barresse
Jun 25, 2020Iron Contributor
Je suis content que ça ait marché pour toi! (Google translate ftw)