search

goosepirate / lox365

⚗️ Lox365: XLOOKUP for LibreOffice
GNU General Public License v3.0
82 stars 5 forks source link

function SORT issue #13

Closed MRIG closed 9 months ago

MRIG commented 9 months ago

Hi, I'v downloaded en installed the extension in LO 7.6.0.3. Function SORT is available, seems to work when selected an array, But when entered, it displays only one cel (the first one), Something is wrong with [sort index] in my case. It doesn't accept any value for colomn/row. Any idea what is wrong or what I'm doing wrong? Thanks for the feature anyway!

Edit when used UNIQUE i got an similar issue. Only one value is displayed. kind regards

MRIG commented 9 months ago

okay, I have to select the checkbox for array, my mistake, new issue I've is that after add the function I can's change/edit or delete the function

goosepirate commented 9 months ago

Hi. Try selecting the entire cell range that the function is using first, then edit the formula.

MRIG commented 9 months ago

Hi. Try selecting the entire cell range that the function is using first, then edit the formula.

thanks, after some puzzling I got it

goosepirate commented 9 months ago

You're welcome.