<div class='ui dimmer modals page' style='display: none;'><div id='helpie-password-modal' class='pauple_helpie ui modal small' style='display: none;'><div class='ui header'><i class='circular lock icon'></i> Password Protected</div><div class='item-content'><br /><label for='password_check'>Enter Password : </label><p><input type='password' id='password_check' name='password_check' class='password' value='' required></p></div><div class='actions'><div class='ui black deny button'>Nope</div><div class='ui positive right labeled icon button'>Yep, that's right!<i class='checkmark icon'></i></div></div><div class='clear'></div></div></div>{"id":84437,"date":"2026-10-15T12:39:50","date_gmt":"2026-10-15T15:39:50","guid":{"rendered":"https:\/\/reportei.com\/central-de-ajuda\/google-sheets-precautions-lors-de-la-validation-des-donnees\/"},"modified":"2026-10-15T13:12:40","modified_gmt":"2026-10-15T16:12:40","slug":"google-sheets-precautions-lors-de-la-validation-des-donnees","status":"publish","type":"pauple_helpie","link":"https:\/\/reportei.com\/fr\/central-de-ajuda\/google-sheets-precautions-lors-de-la-validation-des-donnees\/","title":{"rendered":"Google Sheets : pr\u00e9cautions lors de la validation des donn\u00e9es"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Lors de la connexion d\u2019une feuille, vous d\u00e9finissez les colonnes d\u2019une feuille verticale ou les lignes d\u2019une feuille horizontale \u00e0 utiliser pour les indicateurs, graphiques et tableaux. Vous pr\u00e9cisez \u00e9galement comment interpr\u00e9ter les donn\u00e9es gr\u00e2ce \u00e0 leur&nbsp;<a href=\"https:\/\/reportei.com\/fr\/central-de-ajuda\/integration-sheets-comment-classer-les-colonnes-ou-les-lignes-de-la-feuille-dans-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">classification<\/a>. Ces r\u00e9glages sont effectu\u00e9s \u00e0 l\u2019\u00e9tape de validation des donn\u00e9es :<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"600\" src=\"https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-1024x600.png\" alt=\"\" class=\"wp-image-57994\" srcset=\"https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-1024x600.png 1024w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-300x176.png 300w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-768x450.png 768w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-1536x900.png 1536w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-2048x1199.png 2048w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-750x439.png 750w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-400x234.png 400w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-essa-configura-o-pode-ser-alterada-depois\"><span id=\"helpie-sp-1\"><strong>Peut-on modifier cette configuration ensuite ?<\/strong><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Non.<\/strong>&nbsp;Chaque colonne ou ligne doit \u00eatre correctement class\u00e9e \u00e0 cette \u00e9tape. Cette configuration&nbsp;<strong>ne peut pas \u00eatre modifi\u00e9e ult\u00e9rieurement<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pour changer les donn\u00e9es utilis\u00e9es, leur organisation ou leur classification, il faut&nbsp;<strong>supprimer l\u2019int\u00e9gration actuelle et reconnecter la feuille<\/strong>&nbsp;avec sa nouvelle structure.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-por-que-n-o-poss-vel-mudar-a-configura-o-dos-dados-ap-s-esta-etapa\"><span id=\"helpie-sp-2\"><strong>Pourquoi la configuration est-elle fig\u00e9e ?<\/strong><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lors de la connexion, Reportei interpr\u00e8te la structure de la feuille \u00e0 partir des colonnes ou lignes et de leur classification. Cela garantit une lecture correcte des donn\u00e9es.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cette configuration constitue le squelette de la feuille. Elle est enregistr\u00e9e puis sert de base \u00e0 tous les indicateurs, graphiques et tableaux des rapports et tableaux de bord.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pour modifier un type ou une classification enregistr\u00e9e, vous devez donc reconnecter la feuille, associer la nouvelle structure et recr\u00e9er les indicateurs et visualisations sur cette base.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-posso-alterar-minha-planilha-depois-da-integra-o\"><span id=\"helpie-sp-3\"><strong>Puis-je modifier la feuille apr\u00e8s connexion ?<\/strong><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c9vitez les changements de structure dans la feuille d\u2019origine, car ils peuvent perturber les rapports. Voici quelques exemples :<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Pour une feuille verticale :<br><br><\/strong>\u274c Supprimer ou r\u00e9ordonner les colonnes<br>\u274c Ins\u00e9rer des colonnes au milieu de la structure<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Pour une feuille horizontale :<br><br><\/strong>\u274c Supprimer ou r\u00e9ordonner les lignes<br>\u274c Ins\u00e9rer des lignes au milieu de la structure<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Si ces changements sont n\u00e9cessaires, reconnectez la feuille. Consultez l\u2019article <strong><em><a href=\"https:\/\/reportei.com\/fr\/central-de-ajuda\/google-sheets-puis-je-modifier-ma-feuille-apres-sa-connexion-a-reportei\/\">Puis-je modifier ma feuille apr\u00e8s sa connexion \u00e0 Reportei ? <\/a><\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-dica-final\"><span id=\"helpie-sp-3-1\"><strong>\ud83d\udca1 Conseil<\/strong><\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Avant la connexion, v\u00e9rifiez que toutes les colonnes n\u00e9cessaires sont pr\u00e9sentes, poss\u00e8dent des titres clairs et sont organis\u00e9es selon l\u2019usage pr\u00e9vu dans vos rapports.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Lors de la connexion d\u2019une feuille, vous d\u00e9finissez les colonnes d\u2019une feuille verticale ou les lignes d\u2019une feuille horizontale \u00e0 utiliser pour les indicateurs, graphiques et tableaux. Vous pr\u00e9cisez \u00e9galement comment interpr\u00e9ter les donn\u00e9es gr\u00e2ce \u00e0 leur&nbsp;classification. Ces r\u00e9glages sont effectu\u00e9s \u00e0 l\u2019\u00e9tape de validation des donn\u00e9es : Peut-on modifier cette configuration ensuite ? Non.&nbsp;Chaque [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"helpdesk_category":[4491],"helpie_tag":[],"helpie_add_tag":[],"helpie_up_tag":[],"class_list":["post-84437","pauple_helpie","type-pauple_helpie","status-publish","format-standard","hentry","helpdesk_category-google-sheets-fr"],"_links":{"self":[{"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/pauple_helpie\/84437","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/pauple_helpie"}],"about":[{"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/types\/pauple_helpie"}],"author":[{"embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/comments?post=84437"}],"version-history":[{"count":2,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/pauple_helpie\/84437\/revisions"}],"predecessor-version":[{"id":84843,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/pauple_helpie\/84437\/revisions\/84843"}],"wp:attachment":[{"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/media?parent=84437"}],"wp:term":[{"taxonomy":"helpdesk_category","embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/helpdesk_category?post=84437"},{"taxonomy":"helpie_tag","embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/helpie_tag?post=84437"},{"taxonomy":"helpie_add_tag","embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/helpie_add_tag?post=84437"},{"taxonomy":"helpie_up_tag","embeddable":true,"href":"https:\/\/reportei.com\/fr\/wp-json\/wp\/v2\/helpie_up_tag?post=84437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}