Return-Path: X-Original-To: apmail-openoffice-users-de-archive@www.apache.org Delivered-To: apmail-openoffice-users-de-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0257018210 for ; Fri, 12 Jun 2015 07:29:31 +0000 (UTC) Received: (qmail 85620 invoked by uid 500); 12 Jun 2015 07:29:30 -0000 Delivered-To: apmail-openoffice-users-de-archive@openoffice.apache.org Received: (qmail 85590 invoked by uid 500); 12 Jun 2015 07:29:30 -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 85572 invoked by uid 99); 12 Jun 2015 07:29:30 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Jun 2015 07:29:30 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of joesch@j-m-schmidt.de designates 217.11.48.110 as permitted sender) Received: from [217.11.48.110] (HELO ngcobalt10.manitu.net) (217.11.48.110) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Jun 2015 07:27:14 +0000 Received: from Esprimo7935 (tmo-106-221.customers.d1-online.com [80.187.106.221]) (Authenticated sender: xjs01) by ngcobalt10.manitu.net (Postfix) with ESMTPSA id 5F2F71C89841 for ; Fri, 12 Jun 2015 09:28:56 +0200 (CEST) From: =?ISO-8859-15?Q?J=F6rg_Schmidt?= To: References: <5579E753.9080308@bobermayr.de> In-Reply-To: <5579E753.9080308@bobermayr.de> Subject: Re: Calc Autofilter aktiv? Date: Fri, 12 Jun 2015 09:29:54 +0200 Message-ID: <2340754DD7814A338C9EBD749908CD67@Esprimo7935> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.1.7601.17609 Thread-Index: AdCkgHibUU9Y64KCQZuywRB9aXOaoAAYJ05A X-Virus-Checked: Checked by ClamAV on apache.org Hallo,=20 > From: Bernd Obermayr [mailto:lists@bobermayr.de]=20 > ich m=F6chte mit Basic feststellen ob in einem Sheet ein Autofilter > aktiv ist. > Ich habe im Netz gesucht, aber nur Code f=FCr die Einrichtung eines > Autofilters gefunden oder z.B sowas hier: >=20 > Thiscomponent.DatabaseRanges.getByName("_autoRange1").AutoFilter >=20 > Das gibt mir die Antwort, ob =FCberhaupt ein Bereich f=FCr einen = Filter > vorhanden ist. (True) >=20 > Gibts nicht sowas wie' "oSheet.filtered" :) Ich f=FCrchte nein, aber ich bin nicht 100%ig sicher. Was k=F6nnte man tun? Z.B. Pr=FCfen ob alle Zeilen sichtbar sind und wenn das der Fall ist = annehmen das kein Filter aktiv ist. M=F6glicherweise k=F6nnte man auch mit einem Listener den Filterevent = bei der Anwendung des Filter detektieren und den Filterzustand dann in einer = Variable 'aufbewahren'. =20 Gru=DF J=F6rg --------------------------------------------------------------------- To unsubscribe, e-mail: users-de-unsubscribe@openoffice.apache.org For additional commands, e-mail: users-de-help@openoffice.apache.org