{"id":583,"date":"2009-12-20T10:24:23","date_gmt":"2009-12-20T08:24:23","guid":{"rendered":"http:\/\/www.guion78.com\/wordpress\/?p=583"},"modified":"2009-12-20T10:29:22","modified_gmt":"2009-12-20T08:29:22","slug":"stampa-unione-office-2003-date-e-importi","status":"publish","type":"post","link":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/","title":{"rendered":"Stampa unione Office 2003 date e importi"},"content":{"rendered":"<p>Dalla versione di Office 2003 la stampa unione avviene tramite il driver ODBC e non pi\u00f9 come avveniva con office 2000<\/p>\n<p>Detto, fatto\u2026 et <a title=\"Google Gruppi\" href=\"http:\/\/groups.google.it\/group\/microsoft.public.it.office.word\/browse_thread\/thread\/cbb8cb16bf66ba21\/0ecb14968a6ac823?lnk=st&q=%22Word+2000+contro+Word+2002+-+Stampa+Unione&rnum=1&hl=it#0ecb14968a6ac823\">voila\u2019<\/a>: il problema sta nel fatto che nella nuova versione di Word la connessione con i dati in Excel avviene via <a title=\"ODBC - Wikipedia\" href=\"http:\/\/it.wikipedia.org\/wiki\/ODBC\">ODBC<\/a>, e quindi si copia solo il valore, ma si perde qualsiasi informazione sulla formattazione dello stesso.<\/p>\n<blockquote><p>La soluzione e\u2019 forzare in <strong>Word<\/strong> la connessione ai dati via DDE:<\/p><\/blockquote>\n<ul>\n<li>\n<ul>\n<li>menu\u2019 <strong>Strumenti<\/strong> -> <strong>Opzioni<\/strong> -> tab <strong>Standard<\/strong><\/li>\n<li>spuntare la voce <strong>Conferma conversione all\u2019apertura<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Fatto questo, la prossima volta che si va ad impostare una stampa unione da Word, quando andremo a definire il file Excel dove prelevare i dati, verra\u2019 richiesta la modalita\u2019 di apertura: basta scegliere \u201c<strong class=\"ui\">Fogli di lavoro di Excel tramite DDE\u201d<\/strong> per ottenere la formattazione dei valori identica a quella impostata in Excel.<\/p>\n<p>Mentre scrivevo quest post, cercando ancora con Google, ho anche trovato un documento sul sito della Microsoft <span style=\"text-decoration: underline;\"><strong>che spiega nel dettaglio le tre soluzioni possibili al problema della perdita di formattazione quando si usa la stampa unione. Lo trovate <a title=\"i numeri non vengono uniti correttamente in Word\" href=\"http:\/\/office.microsoft.com\/it-it\/word\/HA011164951040.aspx\">qua<\/a>.<\/strong><\/span><\/p>\n<p>In sintesi:<\/p>\n<p>1) { MERGEFIELD \u201cPrezzo\u201d \t\t\t<strong>\\# $#.###,00<\/strong> }<br \/>\n2) { MERGEFIELD \u201cData\u201d \t\t\t<strong>\\@ \u201cg MMMM aaaa\u201d<\/strong> }<\/p>\n<p>Altre interessanti informazioni sulla stampa unione di Word 2002\/2003 li trovate sempre sul sito <a title=\"La stampa a unione di Word 2003\" href=\"http:\/\/office.microsoft.com\/it-it\/word\/HA010349201040.aspx\">Office Online<\/a> di Microsoft.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalla versione di Office 2003 la stampa unione avviene tramite il driver ODBC e non pi\u00f9 come avveniva con office 2000 Detto, fatto\u2026 et voila\u2019: il problema sta nel fatto che nella nuova versione di Word la connessione con i dati in Excel avviene via ODBC, e quindi si copia solo il valore, ma si [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"ngg_post_thumbnail":0,"footnotes":""},"categories":[10,4,152,14],"tags":[295,294,297,246,296],"class_list":["post-583","post","type-post","status-publish","format-standard","hentry","category-guide","category-informazioni","category-office","category-programmi","tag-date-word","tag-mergefield","tag-office-2003","tag-stampa-unione","tag-word"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Stampa unione Office 2003 date e importi - Guion Matteo<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Stampa unione Office 2003 date e importi - Guion Matteo\" \/>\n<meta property=\"og:description\" content=\"Dalla versione di Office 2003 la stampa unione avviene tramite il driver ODBC e non pi\u00f9 come avveniva con office 2000 Detto, fatto\u2026 et voila\u2019: il problema sta nel fatto che nella nuova versione di Word la connessione con i dati in Excel avviene via ODBC, e quindi si copia solo il valore, ma si [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/\" \/>\n<meta property=\"og:site_name\" content=\"Guion Matteo\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BlogMatteoGuion\/\" \/>\n<meta property=\"article:published_time\" content=\"2009-12-20T08:24:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2009-12-20T08:29:22+00:00\" \/>\n<meta name=\"author\" content=\"Gua78\" \/>\n<meta name=\"twitter:label1\" content=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gua78\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/12\\\/20\\\/stampa-unione-office-2003-date-e-importi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/12\\\/20\\\/stampa-unione-office-2003-date-e-importi\\\/\"},\"author\":{\"name\":\"Gua78\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/dc866ea65964583c162e5476e0ed60e9\"},\"headline\":\"Stampa unione Office 2003 date e importi\",\"datePublished\":\"2009-12-20T08:24:23+00:00\",\"dateModified\":\"2009-12-20T08:29:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/12\\\/20\\\/stampa-unione-office-2003-date-e-importi\\\/\"},\"wordCount\":213,\"commentCount\":0,\"keywords\":[\"date word\",\"mergefield\",\"office 2003\",\"stampa unione\",\"word\"],\"articleSection\":[\"Guide\",\"Informazioni\",\"Office\",\"Programmi\"],\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/12\\\/20\\\/stampa-unione-office-2003-date-e-importi\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/12\\\/20\\\/stampa-unione-office-2003-date-e-importi\\\/\",\"url\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/12\\\/20\\\/stampa-unione-office-2003-date-e-importi\\\/\",\"name\":\"Stampa unione Office 2003 date e importi - Guion Matteo\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#website\"},\"datePublished\":\"2009-12-20T08:24:23+00:00\",\"dateModified\":\"2009-12-20T08:29:22+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/dc866ea65964583c162e5476e0ed60e9\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/12\\\/20\\\/stampa-unione-office-2003-date-e-importi\\\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/12\\\/20\\\/stampa-unione-office-2003-date-e-importi\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/12\\\/20\\\/stampa-unione-office-2003-date-e-importi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Stampa unione Office 2003 date e importi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/\",\"name\":\"Guion Matteo\",\"description\":\"Il Blog ? finalizzato a dare una mano nei problemi informatici di tutti i giorni a tutti quelli a cui pu\u00f2 essere utile, spiegato in modo semplice e passo a passo\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/dc866ea65964583c162e5476e0ed60e9\",\"name\":\"Gua78\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg\",\"caption\":\"Gua78\"},\"description\":\"Amministratore del Portale\",\"sameAs\":[\"http:\\\/\\\/www.guion78.com\"],\"url\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/author\\\/administrator\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Stampa unione Office 2003 date e importi - Guion Matteo","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/","og_locale":"it_IT","og_type":"article","og_title":"Stampa unione Office 2003 date e importi - Guion Matteo","og_description":"Dalla versione di Office 2003 la stampa unione avviene tramite il driver ODBC e non pi\u00f9 come avveniva con office 2000 Detto, fatto\u2026 et voila\u2019: il problema sta nel fatto che nella nuova versione di Word la connessione con i dati in Excel avviene via ODBC, e quindi si copia solo il valore, ma si [&hellip;]","og_url":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/","og_site_name":"Guion Matteo","article_publisher":"https:\/\/www.facebook.com\/BlogMatteoGuion\/","article_published_time":"2009-12-20T08:24:23+00:00","article_modified_time":"2009-12-20T08:29:22+00:00","author":"Gua78","twitter_misc":{"Scritto da":"Gua78","Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/#article","isPartOf":{"@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/"},"author":{"name":"Gua78","@id":"https:\/\/www.guion78.com\/wordpress\/#\/schema\/person\/dc866ea65964583c162e5476e0ed60e9"},"headline":"Stampa unione Office 2003 date e importi","datePublished":"2009-12-20T08:24:23+00:00","dateModified":"2009-12-20T08:29:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/"},"wordCount":213,"commentCount":0,"keywords":["date word","mergefield","office 2003","stampa unione","word"],"articleSection":["Guide","Informazioni","Office","Programmi"],"inLanguage":"it-IT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/","url":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/","name":"Stampa unione Office 2003 date e importi - Guion Matteo","isPartOf":{"@id":"https:\/\/www.guion78.com\/wordpress\/#website"},"datePublished":"2009-12-20T08:24:23+00:00","dateModified":"2009-12-20T08:29:22+00:00","author":{"@id":"https:\/\/www.guion78.com\/wordpress\/#\/schema\/person\/dc866ea65964583c162e5476e0ed60e9"},"breadcrumb":{"@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/12\/20\/stampa-unione-office-2003-date-e-importi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.guion78.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Stampa unione Office 2003 date e importi"}]},{"@type":"WebSite","@id":"https:\/\/www.guion78.com\/wordpress\/#website","url":"https:\/\/www.guion78.com\/wordpress\/","name":"Guion Matteo","description":"Il Blog ? finalizzato a dare una mano nei problemi informatici di tutti i giorni a tutti quelli a cui pu\u00f2 essere utile, spiegato in modo semplice e passo a passo","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.guion78.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Person","@id":"https:\/\/www.guion78.com\/wordpress\/#\/schema\/person\/dc866ea65964583c162e5476e0ed60e9","name":"Gua78","image":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/secure.gravatar.com\/avatar\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg","url":"https:\/\/secure.gravatar.com\/avatar\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg","caption":"Gua78"},"description":"Amministratore del Portale","sameAs":["http:\/\/www.guion78.com"],"url":"https:\/\/www.guion78.com\/wordpress\/blog\/author\/administrator\/"}]}},"views":7493,"_links":{"self":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/posts\/583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/comments?post=583"}],"version-history":[{"count":0,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/posts\/583\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/media?parent=583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/categories?post=583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/tags?post=583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}