CODEWITHSUNDEEP
javascriptopenoffice.orgopenoffice-calcopenoffice-basic
isapir
isapir

Reputation: 23590

OpenOffice Calc Javascript Function

I want to write a simple function to be used in OpenOffice Calc.

It would return true if the cell's value contains a substring, e.g.

function contains(string, substring) {

    return (string.indexOf(substring) > -1);
}

But I can't find any documentation or examples on that.

Any ideas?

TIA

Upvotes: 2

Views: 968

Answers (1)

Lyrl
Lyrl

Reputation: 935

Calc only accepts functions written in Basic. See this thread for a more complete answer: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=30664#p158532

Upvotes: 1

Related Questions