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ägerville...@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.FilterOperatorEMPTY[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.FilterOperatorEQUAL[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ägerville...@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+h...@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
Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)
2012/7/20 Andreas Säger ville...@t-online.de: 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 → Extension → Add…, the extension is now in the list. Now what…? How do I use it? Can't find it. Can I see the code? Sorry for these idiot questions… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- View this message in context: http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996615.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)
2012/7/20 Johnny Rosenberg gurus.knu...@gmail.com: 2012/7/20 Andreas Säger ville...@t-online.de: 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 → Extension → Add…, the extension is now in the list. Now what…? How do I use it? Can't find it. Can I see the code? Sorry for these idiot questions… Okay, got it. I needed to restart LibreOffice, then I found it easily. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- View this message in context: http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996615.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)
2012/7/20 Andreas Säger ville...@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? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- View this message in context: http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996716.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)
Please unsubscribe me. On 7/20/2012 11:56 AM, Johnny Rosenberg wrote: 2012/7/20 Andreas Säger ville...@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? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- View this message in context: http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996716.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)
Hi :) Pleas follow the guide at http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ We can't randomly unsubscribe people from this end but you can unsubscribe yourself just by following the instructions Apols and regards from Tom :) --- On Fri, 20/7/12, Jon Morgan fire...@wintersolace.com wrote: From: Jon Morgan fire...@wintersolace.com 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: 2012/7/20 Andreas Säger ville...@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? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- View this message in context: http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996716.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)
Am 20.07.2012 18:56, Johnny Rosenberg wrote: 2012/7/20 Andreas Sägerville...@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. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)
2012/7/20 Andreas Säger ville...@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.FilterOperatorEMPTY[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.FilterOperatorEQUAL[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. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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