LibreOffice Calc - Programming Project - Search cells

view story

http://www.linuxquestions.org – Hi, I am researching for a scripting project using LibreOffice's Calc built in language. First, I never programmed in calc before and I don't know how to access the scripting screen? Can anyone help? I read some online so i know the language exists. anyhow, Let me tell a little about the project. Is it possible to check an array of cells for key words and return the value of a cell from a table or column? for Example. I have these financial entries A B C AMOUNT DESCRIPTION FORMULA $12.00 MINT CAFE 04598792 ? $13.00 Kelly's 1 (HowTos)