search

goosepirate / lox365

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

Filter not working #6

Closed densha closed 1 year ago

densha commented 1 year ago

Thanks Goose for your work on this extension! I've been trying to use this but look like the FILTER function doesn't work. Are you able to provide an example file that's working, or an example formula?

I've been troubleshooting this for the last 3 hours...lol. Looked on google and try many different variations of the Excel FILTER function but always returning no results.

goosepirate commented 1 year ago

Are you using Ctrl + Shift + Enter when entering the formula? See: https://help.libreoffice.org/latest/en-US/text/scalc/01/04060107.html

goosepirate commented 1 year ago

I'm guessing this is no longer an issue.