Re: [libreoffice-users] Calc suggestion

Hi Kolbjørn,

I just want to make sure expectations here are realistic (I believe I 
was one who commented on the bug). Our project works by the "doers 
deciding" - so even if 100 users say they'd like the feature, *at most* 
this would result in the enhancement going to NEW as a valid enhancement 
request and then *very likely* would sit there for a long time (until a 
developer with the skills required *volunteered* to implement it.

I've pointed out a couple issues with adding entirely new functions:

1) We (The Document Foundation) does not control ods standards, I 
suggested to you that you poke them to see if they're at all interested 
in adding a new standards;

2) When there is currently a workable formula (even if requiring some 
nested functions) - the reason is that there are almost infinite 
combinations of nested functions that people use - if we start taking 
enhancements based on "well one function could replace this x(y(z(#,#))) 
function" than we almost have no limit. I could almost immediately file 
probably two dozen such requests.

Again, just trying to keep things realistic. Best case is that this goes 
to "NEW" just as a "fine it's a valid enhancement" but then it'll almost 
definitely sit there (possibly indefinitely).


Warmest Regards,

Joel



On 6/26/2016 12:01 PM, Kolbjørn Stuestøl wrote:
> 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


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


--
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