CALC - Function SMALL changed since version 6.2 - How now?

asked 2019-10-20 16:19:28 +0100

Ikke gravatar image

To get a decreasing choiselist I use the following formula:

{=IF(ROW(G2:G150)-ROW(G2)+1>COUNT(H2:H150);"";INDEX(G:G;SMALL(H2:H150;ROW(INDIRECT("1:"&ROWS(G2:G150))))))}

Until version 6.1.5.2 this function was functioning ok. But since version 6.2 is according the Release Notes a change in the function Small made. See: https://wiki.documentfoundation.org/R...

As far as I can see the Help in Calc isn't updated yet. How should the above function now be?

edit retag flag offensive close merge delete

Comments

Mike Kaganski gravatar imageMike Kaganski ( 2019-10-20 16:22:47 +0100 )edit