From users-de-return-7696-archive-asf-public=cust-asf.ponee.io@openoffice.apache.org Fri Mar 2 11:44:17 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 270B018062F for ; Fri, 2 Mar 2018 11:44:16 +0100 (CET) Received: (qmail 91796 invoked by uid 500); 2 Mar 2018 10:44:16 -0000 Mailing-List: contact users-de-help@openoffice.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users-de@openoffice.apache.org Delivered-To: mailing list users-de@openoffice.apache.org Received: (qmail 91781 invoked by uid 99); 2 Mar 2018 10:44:15 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Mar 2018 10:44:15 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id EE86518053B for ; Fri, 2 Mar 2018 10:44:14 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.279 X-Spam-Level: * X-Spam-Status: No, score=1.279 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id DJd7TW4Tv08C for ; Fri, 2 Mar 2018 10:44:13 +0000 (UTC) Received: from mout.gmx.net (mout.gmx.net [212.227.15.18]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 1A51B5F126 for ; Fri, 2 Mar 2018 10:44:13 +0000 (UTC) Received: from [192.168.2.111] ([91.61.15.234]) by mail.gmx.com (mrgmx003 [212.227.17.190]) with ESMTPSA (Nemesis) id 0Ltr89-1ejugL1rCn-011C5R for ; Fri, 02 Mar 2018 11:44:12 +0100 To: users-de@openoffice.apache.org From: Semmel Subject: Abfrage auf leere Zellen in einem Datenbereich Message-ID: <681a5e94-bc75-cd75-b498-1c9990b694a3@gmx.ch> Date: Fri, 2 Mar 2018 11:44:12 +0100 User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:45.0) Gecko/20100101 Thunderbird/45.8.0 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------E5139F312D90EE09889F8C2D" X-Provags-ID: V03:K0:WaAbud+WDRmTibp62hSlZuY+DqbBnq7bwnbtkd7cuEpJGzycGS8 5JTpokWiOrSrn/I6x053xmtIW2yTtgvuVugeqBgEXZmKlmGa0INpm3ysPkqTYH4fcpTbi1S KonKJqIEw/r2xNMl4CaX5ecFP1oSA4EiOdX3Jc7YdzbY2CLsEkGYiWXmu6RK31VW228+Wfv r+SX59ICdrrAIJkyC9fyw== X-UI-Out-Filterresults: notjunk:1;V01:K0:6B88bypqSyI=:XO4VKeQBxT1fnrdNK3jrhv DjzJV1RYxPMPVMbPFNkyiQp8gCfcGnDIoTeU0OQvQ7N+eXCO5xhEa82BibKkZ4WcC3k/TYIjh m1u+/X0Ah9gvK7gWitOpKxmo3GroR18Xn+fCEOduuv1H+VcfNjMLWAYYkm/c5EWSz8p1Z2M1Y LATfR0y9qvRuP5YecvATFStkqd7N5W2wPhXrZ2FuYXIANLyTm57px6KfetrK8/YtVnp/CIXi6 9bMYF6tGYzykhtwL0VRJhhK/uFYcGI2XnLOWvnbEuEPvF7zW20uRPbAhzTmXtr2BThRk1lOjv jSeDjX+kph5JqxBeih8i+4lN2ADc5BA/hTPzFTDhzuADtlbdDZC+tg8RScEYckL0wRBQh2N+X urLebH3gxJ6gxE7Lk7z1XXf2kJ/3APKHHlKt9EwEjZSZhGEr66bkuuoA2P3sJWoYi5wms2MPS aEdIs8Mq6biKLiwi0er7QT6PyhAJDz+8V0gDTP3NDWPqfBvMjz9I4eGHX/Vt+TQEk4/DAN/XA 08eVowiTce7JgRRYO9PO9Gzp5jTkEsWkFh9n5aZH11HRT5Yn5pLR402gNg9DlrAjrBZR4ULhs T6VMMmsUCaMpmmUMtjHZl5Qef9D4L81iqhUwq4ZmTjWEHiNnr1uq0C8dgvGtSCYkdgPp5CJWh ib9Yk+5EcslvagrWB3Sn3z7Y+ZGz43IA3cezPF8sw5+JtzA+VlBwVGgk5AerTisOKamJPh+0V Iyxn9cNuzGvla+sxHVRg0bVWXBeska9fcgtBMHs+Xb5pAv0UeCijLID5GwgdnhCaUcPcZd4jF aVHZysqyABBHx5nxTRoCxf/v8FHT+gxsYPY3nFXRquXJ8oqCGw= --------------E5139F312D90EE09889F8C2D Content-Type: text/plain; charset=iso-8859-15; format=flowed Content-Transfer-Encoding: 8bit Ein "Moin" an die Listenteilnehmer, mein Problem mit Calc: wie pr�fe ich in einem Datenbereich (z.B. D3:E66), ob *keine* der Zellen leer ist? Meine Versuche mit =WENN(D3:E66<>"";"mind. eine Zelle leer";"alles okay") oder {=WENN(D3:E66<>"";"mind. eine Zelle leer";"alles okay")} bringen Fehlercodes oder anderen "Unfug". Wie muss ich die Formel �ndern? (... und bitte eine L�sung ohne Makros) Vielen Dank im Voraus. Gru�, Peter. --------------E5139F312D90EE09889F8C2D--