LibreOffice Calc SEARCH and FIND functions

Posted by TTT on Super User See other posts from Super User or by TTT
Published on 2012-06-20T12:00:37Z Indexed on 2012/06/20 15:18 UTC
Read the original article Hit count: 380

Filed under:

libreoffice-calc

I am trying to process some data in Calc. One of the steps involve finding if a certain string is part of one of the column. I tried using FIND and SEARCH functions. Both behave in the same way and I am not getting correct results.

E.g. Say I have following strings in Column A

NY
SF
LON
CAN
US

and am trying to put following formula in column C

=SEARCH("NY",A2)

The result is - cell C2 will have 1 (which is correct) but if the same formula is copied to other cells in column C - it gives me "#VALUE!" error and I am unable to find out why ?

Any one has any ideas ?

Thanks in advance

TT

Related posts about libreoffice-calc

Changing the cell range of conditional formatting in LibreOffice Calc

as seen on Super User - Search for 'Super User'
Is there any way of changing the range of conditional formatting in LibreOffice Calc (version 3.6)? I have a set applied already to a range of cells, but there is no obvious way of changing which cells a given set of conditional formatting is applied to. I either have to copy and paste the formatting… >>> More
LibreOffice Calc SEARCH and FIND functions

as seen on Super User - Search for 'Super User'
I am trying to process some data in Calc. One of the steps involve finding if a certain string is part of one of the column. I tried using FIND and SEARCH functions. Both behave in the same way and I am not getting correct results. E.g. Say I have following strings in Column A NY SF LON CAN US and… >>> More
Flexible argument list in LibreOffice Calc Macro

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to write a function that geometrically links performance data which is usually provided as percentages, so the function will basically return (1+a)*(1+b)*(1+c)* … *(1+x)-1 This should be done using LibreOffice-calc and it should behave similarly to the regular sum function. As you may throw… >>> More
Change the icon color in LibreOffice Calc

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
There appears to be no way of changing icon color in a calc chart. After creating an XY scatter plot, I can select "format data series" and can change the icon symbol and size, but not the color. There is an drop-down for line color, but when I do not have lines displayed this drop-down menu is grayed… >>> More
System crash when trying to drag cells in LibreOffice Calc

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Some time after upgrady to Saucy I noticed several freezes and crashes when simply trying to drag content of selected cells to another place in LibreOffice Calc (version 4.1.2.3 from repository). The system stops responding - although for example Clementine still plays music from playlist - I am… >>> More

Developer IT