Re: [libreoffice-users] Calc suggestion

I asked for this as an enhancement. (Bug125848 
<http://bugs.documentfoundation.org/attachment.cgi?id=125848>).
It looks like the developers has plenty to do adding functions to be 
compatible with other spreadsheets (read: Excel?). So most likely it 
will be marked WONTFIX.
 I just asked for this function because
1) I needed it (instead of using workarounds), and
2) it would be nice if Calc sometimes was ahead of Excel.
But, as I said, if I am the only one in need for such function(s), it is 
undesirable to waste time on it.

Kolbjørn


*
*Den 20.06.2016 21:54, Kolbjørn Stuestøl skreiv:
> I have not found an active forum for developers so I am trying this 
> forum. Perhaps someone know where to post it?
>
> I would like to have a function who finds the first or last occurrence 
> of an item in a cell area.
> Something like
>
>    FIND.FIRST(B1:C20,A1) and FIND.LAST(B1:C20,A1)
>
> where A1 contains the needle (what should be found), C1:C20 the search 
> area (the heystack) and if found in C1:C20 returns the value of the 
> corresponding row from B1:B20.
>
> Also FIND.FIRST(B1:B20,A1) where the returned value is the address to 
> the actual cell in B1:B20 will do.
>
> A1 could contain a number value or something like "<5" to find the 
> first occurrence of a number less than 5. Including text would be top.
>
> What could this function be used for?
> If I for example are running a shop opening at 7 in the morning with a 
> few employers. (I assume the cash register is connected to Calc). What 
> time of the day is the first sale? If I never sell anything before 10 
> o'clock, I could save some wages, and consider sleeping 3 hours more 
> in the morning. :-)
> Or I could find out what day was the first rainy day in June or the 
> first frosty day in the autumn the latest 20 years, or when my 
> wildlife cameras first recognized an elk.
>
> I have not found this function in other spreadsheets, so perhaps Calc 
> will be the first one?
>
> I am now using a walk around, so I am not asking for how to do this 
> calculations. I am only asking for a function to do this in a simpler 
> way.
>
> Kolbjørn Stuestøl


--
Kolbjørn Stuestøl, Stuestølveien 212, 4580 Lyngdal
Telefon: (47) 38 34 78 62,  (47) 917 81 125
Stuestøl heimesider: http://www.stuestoel.no
Andre sider eg administrerer:
Lyngdal hagelag: http://lyngdal.hagelag.no
(Passive sider: http://www.stuestoel.no/hagelag/hagelag.php)
Mandal og Lister pyntegrøntlag: http://www.mlpynt.no

Member of the GIMP Documentation Team
Language coordinator LibreOffice (www.libreoffice.org/)


--
To unsubscribe e-mail to: users+unsubscribe@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