Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 10B1A200C2E for ; Sun, 5 Mar 2017 17:45:49 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 0F4BE160B6B; Sun, 5 Mar 2017 16:45:49 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 5698E160B57 for ; Sun, 5 Mar 2017 17:45:48 +0100 (CET) Received: (qmail 3040 invoked by uid 500); 5 Mar 2017 16:45:47 -0000 Mailing-List: contact utenti-it-help@openoffice.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: utenti-it@openoffice.apache.org Delivered-To: mailing list utenti-it@openoffice.apache.org Received: (qmail 3028 invoked by uid 99); 5 Mar 2017 16:45:47 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 05 Mar 2017 16:45:47 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 9D2C0C248B for ; Sun, 5 Mar 2017 16:45:46 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id hnaEBGDd1bUL for ; Sun, 5 Mar 2017 16:45:44 +0000 (UTC) Received: from mail-oi0-f50.google.com (mail-oi0-f50.google.com [209.85.218.50]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 1F8435F1B3 for ; Sun, 5 Mar 2017 16:45:44 +0000 (UTC) Received: by mail-oi0-f50.google.com with SMTP id 126so23716145oig.3 for ; Sun, 05 Mar 2017 08:45:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=vLd9mmbUXQQb+391XydD28AZWZH/M0+vmZcadf3cGlM=; b=hlN69OFl3vsBRZM8ktF12tsczt/Yqv9/nrrFH6BerFb84/txW/BenTM2vOTFSkvbBU 2FO1q7eLdnA6Hez6jWreLAexe+s8+ZLZsJwX7bxQ8J7vNWtyQKjF3hs5rIcFXtN55gju asVbrR3FOMMlTQVaqMHLDi+Dl4bwdmyNZCqNyo6Q+G+nXSBJbQDXpmV9/c/AgTTcc6dK poRhStzr233B7qUn0SBFNbNONE3y5GV2X+Uujbj0HnjTD8t7t93CrxN1i4HFpcO0lBiR TWhdMIpl/ry8go15SnEcMLT5pZIKD92MdqNoNkzsjQBhXKDvgspzRtHeVbEEckVLg81Y YPhQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=vLd9mmbUXQQb+391XydD28AZWZH/M0+vmZcadf3cGlM=; b=l5A8VB1mGTv6gI0TGebfxy7vp3p5niREKt/08rpX1fa3hSUOHDaJJjF8RVJeAK6olr ORFj3Z017BAaHoXzejtAEobOe9xTR9ydvIvGMAIGEMeHfcecLFXsIxHYFUgQOUOIpwYv k/aN8J7w4vgjEXZCoEhjgf0RDUcPSVyp6V/EMVJGOoAogmewSLFa938UL1n0P+Kl7Y5U X7ywjlHoqDraA5+Gtc/GFhxbh6zL+Tl+hwbbCzP5axq0Ew4v4ju+e+00Yhb63Hbs1Rg/ WoLymM53iKGIIAWhGmwu8oxcPWD1uN+0JA1kh98PLfBuHp74g3fKKVwnqnK/EtUP+mvJ TMuw== X-Gm-Message-State: AMke39kNJY2j0T6KsUAEnKey7IsyZRaV2v0IZRFD+Jd9cdwJ99H6DT1wpyEE+JozBmpZ6ifThk1t1GwXFEJZSA== X-Received: by 10.202.58.69 with SMTP id h66mr5718031oia.30.1488732342790; Sun, 05 Mar 2017 08:45:42 -0800 (PST) MIME-Version: 1.0 Received: by 10.202.229.133 with HTTP; Sun, 5 Mar 2017 08:45:12 -0800 (PST) In-Reply-To: References: From: Diego Maniacco Date: Sun, 5 Mar 2017 17:45:12 +0100 Message-ID: To: utenti-it@openoffice.apache.org Content-Type: multipart/alternative; boundary=001a113cdd887551030549fe825c Subject: Re: [utenti-it] trasformazione archived-at: Sun, 05 Mar 2017 16:45:49 -0000 --001a113cdd887551030549fe825c Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Non conosco il formato sxl, ma ho fatto una prova con LibreOffice 5.1.6. - ho inserito in colonna A una serie di date come nel tuo esempio. - ho selezionato la colonna A e impostato il formato data come DD-MM-YYYY (in italiano prob. GG-MM-AAAA) - sempre con la colonna A selezionata ho richiamato Edit/Cerca e sostituisci e rimpiazzato ' con NULLA. La colonna A =C3=A8 stata riletta e le ceklle sono diventate date. diego --------------------------------------- Diego Maniacco, Bolzano (Italy) diego.maniacco@gmail.com --------------------------------------- 2017-03-05 17:14 GMT+01:00 Arturo Cilio : > ho un foglio elettronico sxl con dei dati, per esempio '01-12-2016, da > trasformare in data come levo quell'apostrofo davanti a tutta la colonna > senza farlo uno per uno? > Grazie > Arturo Cilio > --001a113cdd887551030549fe825c--