[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[libreoffice-users] Can I stop Calc altering the formulas I enter?
- Subject: [libreoffice-users] Can I stop Calc altering the formulas I enter?
- From: David Lynch <firstname.lastname@example.org>
- Date: Mon, 25 Nov 2019 09:16:27 +0000
- To: "email@example.com" <firstname.lastname@example.org>
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.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
|Re: [libreoffice-users] Can I stop Calc altering the formulas I enter?||Brian Barker <firstname.lastname@example.org>|
- Prev by Date: Re: [libreoffice-users] LibreOffice and German software
- Next by Date: Re: [libreoffice-users] LibreOffice and German software
- Previous by thread: [libreoffice-users] LibreOffice and German software
- Next by thread: Re: [libreoffice-users] Can I stop Calc altering the formulas I enter?