How to autocomplete formulas in LibreOffice Calc

Try

Enter

Works like a charm.