[Solved] createSearchDescriptor Does Not Work

[Robitron]

Okay, I copied and pasted this example taken from https://wiki.openoffice.org/wiki/Docume ... ity_Search
Here is the example:

Code: Select all

Sub Test
Dim SearchDesc As Object
Dim Doc As Object
 
Doc = ThisComponent
SearchDesc = Doc.createSearchDescriptor
SearchDesc.SearchString="turnover"
SearchDesc.SearchSimilarity = True
SearchDesc.SearchSimilarityAdd = 2
SearchDesc.SearchSimilarityExchange = 2
SearchDesc.SearchSimilarityRemove = 2
SearchDesc.SearchSimilarityRelax = False
Found = Doc.findFirst (SearchDesc)
 
Do Until IsNull(Found)
  Found.CharWeight = com.sun.star.awt.FontWeight.BOLD
  Found = Doc.findNext( Found.End, SearchDesc)
Loop
End Sub

Here is the error:

So is this outdated or is there something else I'm missing?

What I am looking to do is set up a code that will search the contents of the cell and determine if it contains a phrase regardless of capitalization. So if this is outdated, could someone point me in a good direction to achieve this end? Thanks.

[JeJe]

That macro is for a text document and won't work in a spreadsheet document. If you do a search here or google openoffice search contents of cell you should get something for a spreadsheet

[Robitron]

That macro is for a text document and won't work in a spreadsheet document. If you do a search here or google openoffice search contents of cell you should get something for a spreadsheet

Wow, how did I miss that? lol Thanks. I acutally found the UCase and LCase functions so I just converted the text in the cell to lowercase with the RType = LCase(Cell1.String) and used the Select Case option to put it right.

At least it's doable but if I had several options, it would be a bit much to set up the Select Case for all of them. Fortunately, there are only two choices for this cell that are acceptable.

[dandv]

That macro is for a text document and won't work in a spreadsheet document.

That is not exactly true, or useful. createSearchDescriptor is a method of individual sheets, not the whole spreadsheet document. But it does work in Calc.

If you do a search here or google openoffice search contents of cell you should get something for a spreadsheet

Really. Do try that please.

The OO/LO API is so stuffy, confusing and the documentation so spread all over the place and hard (or impossible, for JavaScript macros) to find, that it helps to be more specific than "Google it".

Here's the code to do a reverse search in LibreCalc for the text in the current cell. Useful to navigate to its last occurrence.

Code: Select all

Sub FindBackwards
    doc = ThisComponent
    sheet = doc.getCurrentController.activeSheet
    search = sheet.createSearchDescriptor()
    With search
        .SearchString = doc.currentSelection.String
        .SearchCaseSensitive = true
        .SearchBackwards = true
        .SearchByRow = true
    End With

    result = sheet.findNext(doc.currentSelection, search)
    doc.CurrentController.Select(result)
End Sub

[JeJe]

That is not exactly true, or useful. createSearchDescriptor is a method of individual sheets, not the whole spreadsheet document. But it does work in Calc.

The reason the OP's code failed was because there isn't a method ThisComponent.createSearchDescriptor if its a spreadsheet. That was the problem and I think I explained it.

Really. Do try that please.

I did. I suggested an exact search which I will have found yielded results I thought might be useful.

The OO/LO API is so stuffy, confusing and the documentation so spread all over the place and hard (or impossible, for JavaScript macros) to find, that it helps to be more specific than "Google it".

So few people use JavaScript in OO that you're not going get much in the way of documentation. Hmmm... you seem to have resurrected this old thread mainly to have a go at me... which I find strange... especially for a first post...


Edit:
People here try and help each other... if you think someone's solution isn't quite there... well that happens a lot... all you need do is post your better one...

[dandv]

Really. Do try that please.

I did. I suggested an exact search which I will have found yielded results I thought might be useful.

Why not post the actual result then?

So few people use JavaScript in OO that you're not going get much in the way of documentation.

Why does a JavaScript API even exist then, if it's undocumented?

Hmmm... you seem to have resurrected this old thread mainly to have a go at me...

Huh? I have no idea who you are. I'm peeved at this archaic API. I come from the web development world, where API quality (and documentation) is paramount. Have a look at the Twitter, GitHub, or Firebase APIs to see what a well-documented non-verbose API looks like. If OO/LO were a SAAS startup competing with other modern startups, this API would absolutely not fly.

if you think someone's solution isn't quite there... well that happens a lot... all you need do is post your better one...

That's exactly what I did in the code I posted.

[RusselB]

I'm peeved at this archaic API.

The API, to my knowledge, falls under the same licencing agreement as the rest of the Apache OpenOffice software.
Simply put, you are free to look at and modify the software to your own needs.

[Villeroy]

There is no JavaScript API. The API is the same for all languages with a lot of extra glue for StarBasic. There is a bridge for JavaScript, BeanShell and there is one for Python because these bridges had been implemented at some early stage around 2005 proving that it possible to plug any object oriented language to this API without much effort. There is also a bridge for the Rexx langauge which can be added. I've never seen any JavaScript macros other than proof of concept snippets. Number one is StarBasic, number two is Python when it comes to macro scripts. Python and Java are the commonly used languages for extensionsSince since we Basic can not define its own UNO classes. The API may be arcane but it is self-documenting. There are two similar extensions MRI and XRay to unveil the self documentation. [Tutorial] Introduction into object inspection with MRI