In my spreadsheet I have several cells named with a single letter (using Sheet -> Named Ranges and Expressions ->), for example "I" and "A".

If I enter a formula ending in "I" and hit the enter key, it changes the "I" to "IF()", if ending in "A" to "ACCRINT()", I have to click the tick button in the formula bar rather than hit [enter] to retain the "I" and "A" as I entered them.

Is there any way to stop this behaviour and make [enter] act in the same way as clicking the tick button. I have Tools - Options- LibreOffice - General - Extended tips unchecked.

David Lynch



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Reply via email to