[Solved] Decline predictive text in Calc

Discuss the spreadsheet application

[Solved] Decline predictive text in Calc

Postby conbobulator » Sat Mar 23, 2019 7:47 pm

The predictive text feature is usually very helpful, but I can't work out how you say no to the predicted offering if my intended text is complete. For example, I want to write the 3 letter word "Sun" in a cell. I type in "S", "u" and "n" and at this point the cell contains "Sunday" with the "day" part highlighted in blue. If I click on the next cell I want to work on, then "Sunday" is what gets left in that first cell. But I specifically wanted just "Sun". What do I have to do? I've tried pressing the ESC key before moving out of the cell, but that doesn't work.
Last edited by Hagar Delest on Sun Mar 24, 2019 8:52 pm, edited 1 time in total.
Reason: tagged solved
OpenOffice 4.1 on Windows 10 Education N
conbobulator
 
Posts: 2
Joined: Sat Mar 23, 2019 7:31 pm

Re: predictive text in Calc - how do you decline a suggestio

Postby mikele » Sat Mar 23, 2019 9:59 pm

Hi,
press Del before moving out?
LibreOffice 5.4.7 on LinuxMint/WinXP/Win7
mikele
 
Posts: 45
Joined: Wed Nov 21, 2018 11:11 am
Location: Germany

Re: predictive text in Calc - how do you decline a suggestio

Postby DolphyausDutchland » Sat Mar 23, 2019 9:59 pm

Hello,

try hitting the 'Backspace' key (upper to return key),
or turn off the Auto Suggestion in the Calc options
Beta-Version 1.4 of VideoPoker(with kind o' ~database functionality)
OpenOffice.org (OOo) 3.0.0 on Windows 7; Notebook with XP and Apache OpenOffice (AOO) 4.1.3
User avatar
DolphyausDutchland
 
Posts: 10
Joined: Thu Jan 01, 2015 5:30 am

Re: predictive text in Calc - how do you decline a suggestio

Postby conbobulator » Sat Mar 23, 2019 10:10 pm

Thank you both.
DEL and backspace both work.
Auto suggestion can be useful but I would rather you had to positively accept the suggestion than positively decline it.
OpenOffice 4.1 on Windows 10 Education N
conbobulator
 
Posts: 2
Joined: Sat Mar 23, 2019 7:31 pm


Return to Calc

Who is online

Users browsing this forum: MSN [Bot] and 12 guests