Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

Am 20.07.2012 21:37, Johnny Rosenberg wrote:
> 2012/7/20 Andreas Säger<villeroy@t-online.de>:
> > Am 20.07.2012 14:19, Andreas Säger wrote:
> > > Try my "SpecialCells" extension which selects combinations of cell types:
> > > http://user.services.openoffice.org/en/forum/download/file.php?id=11048
> >
> > Done. Snippet recorded by the MRI inspector:
> >
> > > Sub Snippet(Optional oInitialTarget As Object)
> > >    Dim oDatabaseRanges As Object
> > >    Dim oObj_1 As Object
> > >    Dim oFilterDescriptor As Object
> > >    Dim oFilterFields As Object
> > >
> > >    oDatabaseRanges = oInitialTarget.DatabaseRanges
> > >    oObj_1 = oDatabaseRanges.getByIndex(0)
> > >    oFilterDescriptor = oObj_1.getFilterDescriptor()
> > >
> > >    oFilterFields = oFilterDescriptor.getFilterFields()
> > > End Sub
> >
> >
> >
> > And this is the output for oFilterFields:
> >
> > > (Name)        (Value Type)             (Value)  (AccessMode)
> > > (0)
> > > Connection    .sheet.FilterConnection  AND      [ReadWrite]
> > > Field         long                     0        [ReadWrite]
> > > Operator      .sheet.FilterOperator    EMPTY    [ReadWrite]
> > > IsNumeric     boolean                  True     [ReadWrite]
> > > NumericValue  double                   0.0      [ReadWrite]
> > > StringValue   string                   ""       [ReadWrite]
> > > (1)
> > > Connection    .sheet.FilterConnection  OR       [ReadWrite]
> > > Field         long                     0        [ReadWrite]
> > > Operator      .sheet.FilterOperator    EQUAL    [ReadWrite]
> > > IsNumeric     boolean                  False    [ReadWrite]
> > > NumericValue  double                   0.0      [ReadWrite]
> > > StringValue   string                   ""       [ReadWrite]
> >
> >
> > The blank field (0) uses c.s.s.sheet.FilterOperator.EMPTY with any content.
> > The empty string field (1) uses c.s.s.sheet.FilterOperator.EQUAL with string
> > content "".
>
> Thanks. I'll take a closer look at it tomorrow. Too tired and confused
> right now.

Quite confusing, indeed. My "Done" posting refers to my other posting:

> Am 20.07.2012 18:56, Johnny Rosenberg wrote:
> > 2012/7/20 Andreas Säger<villeroy@t-online.de>:
> > > As far as I know, the find/replace tool can not find empty strings nor
> > > blanks.
> > > The standard filter can. It has an "-- empty --" option for the blanks and
> > > one empty entry at the end of the combo box for the empty strings (if any).
> >
> > Can I use that in a macro? How?
>
> Apply such filter manually and inspect the filter descriptor with its filter fields.

This is what I've done. I applied such a filter and ran MRI against the 
filter descriptor with the above results.


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted