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

2012-07-23 Thread Andreas Säger
Am 20.07.2012 21:37, Johnny Rosenberg wrote: 2012/7/20 Andreas Säger: 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 M

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

2012-07-20 Thread Johnny Rosenberg
2012/7/20 Andreas Säger : > 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

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

2012-07-20 Thread Andreas Säger
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 oDat

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

2012-07-20 Thread Andreas Säger
Am 20.07.2012 18:56, Johnny Rosenberg wrote: 2012/7/20 Andreas Säger: 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 an

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

2012-07-20 Thread Tom Davies
wrote: From: Jon Morgan Subject: Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro) To: users@global.libreoffice.org, users+h...@global.libreoffice.org Date: Friday, 20 July, 2012, 18:28 Please unsubscribe me. On 7/20/2012 11:56 AM, Johnny Rosenberg wrote: > 2

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

2012-07-20 Thread Jon Morgan
Please unsubscribe me. On 7/20/2012 11:56 AM, Johnny Rosenberg wrote: 2012/7/20 Andreas Säger : 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 f

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

2012-07-20 Thread Johnny Rosenberg
2012/7/20 Andreas Säger : > 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?

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

2012-07-20 Thread Andreas Säger
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). -- View this message in context: http://nabble.documentfoundation

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

2012-07-20 Thread Johnny Rosenberg
2012/7/20 Johnny Rosenberg : > 2012/7/20 Andreas Säger : >> Try my "SpecialCells" extension which selects combinations of cell types: >> http://user.services.openoffice.org/en/forum/download/file.php?id=11048 >> > > Okay, I didn't install any extensions before, at least not since quite > a along ti

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

2012-07-20 Thread Johnny Rosenberg
2012/7/20 Andreas Säger : > Try my "SpecialCells" extension which selects combinations of cell types: > http://user.services.openoffice.org/en/forum/download/file.php?id=11048 > Okay, I didn't install any extensions before, at least not since quite a along time ago. So I grabbed your file, Tools →

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

2012-07-20 Thread Andreas Säger
Try my "SpecialCells" extension which selects combinations of cell types: http://user.services.openoffice.org/en/forum/download/file.php?id=11048 -- View this message in context: http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996615.html Sent fr