{"id":1586,"date":"2018-02-07T21:24:15","date_gmt":"2018-02-07T20:24:15","guid":{"rendered":"http:\/\/mackid.legtux.fr\/?p=1586"},"modified":"2018-02-26T19:00:15","modified_gmt":"2018-02-26T18:00:15","slug":"libreoffice-nom-de-cellule","status":"publish","type":"post","link":"https:\/\/mackid.legtux.org\/?p=1586","title":{"rendered":"LibreOffice &#8211; Nom de cellule\u2026 [M\u00e0J]"},"content":{"rendered":"<p class=\"p1\">Pour \u00e9viter d\u2019avoir des formules du style =B1+B2 qui ne sont pas facilement compr\u00e9hensible vous pouvez nommer les cellules pour avoir ici une formule du type =A+B, l\u2019avantage est d\u2019avoir une formule claire et d\u2019\u00e9viter d\u2019aller cliquer sur les cellules concern\u00e9es.<\/p>\n<div id=\"attachment_1587\" style=\"width: 680px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1587\" class=\"size-large wp-image-1587\" src=\"http:\/\/mackid.legtux.fr\/wp-content\/uploads\/2018\/02\/screenshot_9851-1024x199.png\" alt=\"\" width=\"670\" height=\"130\" srcset=\"https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/screenshot_9851-1024x199.png 1024w, https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/screenshot_9851-300x58.png 300w, https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/screenshot_9851-768x149.png 768w, https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/screenshot_9851.png 1336w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><p id=\"caption-attachment-1587\" class=\"wp-caption-text\">Ici la cellule B1 s\u2019appelle \u00ab\u00a0A\u00a0\u00bb et la cellule B2 s\u2019appelle \u00ab\u00a0B\u00a0\u00bb<\/p><\/div>\n<div id=\"attachment_1588\" style=\"width: 680px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1588\" class=\"size-large wp-image-1588\" src=\"http:\/\/mackid.legtux.fr\/wp-content\/uploads\/2018\/02\/screenshot_9853-1024x199.png\" alt=\"\" width=\"670\" height=\"130\" srcset=\"https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/screenshot_9853-1024x199.png 1024w, https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/screenshot_9853-300x58.png 300w, https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/screenshot_9853-768x149.png 768w, https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/screenshot_9853.png 1336w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><p id=\"caption-attachment-1588\" class=\"wp-caption-text\">La cellule B3 contient la formule =B1+B2 et la cellule B4 contient la formule =A+B<\/p><\/div>\n<p class=\"p1\">Vous pouvez nommer les cellules avec une lettre ou un nom complet\u2026<\/p>\n<div id=\"attachment_1589\" style=\"width: 680px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1589\" class=\"size-large wp-image-1589\" src=\"http:\/\/mackid.legtux.fr\/wp-content\/uploads\/2018\/02\/LO_V5162-1024x595.png\" alt=\"\" width=\"670\" height=\"389\" srcset=\"https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/LO_V5162-1024x595.png 1024w, https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/LO_V5162-300x174.png 300w, https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/LO_V5162-768x446.png 768w, https:\/\/mackid.legtux.org\/wp-content\/uploads\/2018\/02\/LO_V5162.png 1054w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><p id=\"caption-attachment-1589\" class=\"wp-caption-text\">Bug du C<\/p><\/div>\n<p class=\"p1\">Sauf que Libre Office comporte un bug et refuse d\u2019appeler une cellule \u00ab\u00a0C\u00a0\u00bb ! Toutes les autres lettres seules sont accept\u00e9es, \u00ab\u00a0Ca\u00a0\u00bb est accept\u00e9, \u00ab\u00a0C1a\u00a0\u00bb est refus\u00e9 alors que \u00ab\u00a0D1a\u00a0\u00bb est accept\u00e9\u2026 C\u2019est incompr\u00e9hensible !<br \/>\n[M\u00e0J] M\u00eame probl\u00e8me avec le \u00ab\u00a0R\u00a0\u00bb.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pour \u00e9viter d\u2019avoir des formules du style =B1+B2 qui ne sont pas facilement compr\u00e9hensible vous pouvez nommer les cellules pour avoir ici une formule du type =A+B, l\u2019avantage est d\u2019avoir une formule claire et d\u2019\u00e9viter d\u2019aller cliquer sur les cellules concern\u00e9es. Vous pouvez nommer les cellules avec une lettre ou un nom complet\u2026 Sauf que [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1586","post","type-post","status-publish","format-standard","hentry","category-mac"],"_links":{"self":[{"href":"https:\/\/mackid.legtux.org\/index.php?rest_route=\/wp\/v2\/posts\/1586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mackid.legtux.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mackid.legtux.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mackid.legtux.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mackid.legtux.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1586"}],"version-history":[{"count":2,"href":"https:\/\/mackid.legtux.org\/index.php?rest_route=\/wp\/v2\/posts\/1586\/revisions"}],"predecessor-version":[{"id":1595,"href":"https:\/\/mackid.legtux.org\/index.php?rest_route=\/wp\/v2\/posts\/1586\/revisions\/1595"}],"wp:attachment":[{"href":"https:\/\/mackid.legtux.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mackid.legtux.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mackid.legtux.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}