[Solved] AutoFill and custom sort list

Discuss the spreadsheet application

[Solved] AutoFill and custom sort list

Postby jjon » Fri Apr 19, 2019 11:53 pm

It took me forever just to figure out how to define a custom sort list (Letter Grades: A+ A A- B+ etc. With 0 and X at the end). Fine and good. But then I discovered that if I entered an 'x' in the top cell of a column and tried to 'fill down' with identical values by dragging, my new custom sort list is what got filled in. Is there any way to disable a sort list such that it only 'fills down' when explicitly invoked?
Last edited by jjon on Sat Apr 20, 2019 1:07 am, edited 1 time in total.
OpenOffice 4.1.6
macOS 10.12.6 (16G29)
jjon
 
Posts: 7
Joined: Fri Apr 19, 2019 11:40 pm

Re: AutoFill and custom sort list

Postby FJCC » Sat Apr 20, 2019 12:40 am

If you hold down the CTRL key while dragging, the fill will repeat the value you entered.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7303
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

[Solved] AutoFill and custom sort list

Postby jjon » Sat Apr 20, 2019 12:59 am

FJCC wrote:If you hold down the CTRL key while dragging, the fill will repeat the value you entered.

Oh Man! Could it really be that easy? <slapsForeheadWithPalm/> Yes. It really is! How do you find out obvious stuff like that?
OpenOffice 4.1.6
macOS 10.12.6 (16G29)
jjon
 
Posts: 7
Joined: Fri Apr 19, 2019 11:40 pm

Re: [Solved] AutoFill and custom sort list

Postby FJCC » Sat Apr 20, 2019 2:18 am

I found it in the Help under sort lists;applying.
"Hold down Ctrl if you do not want to fill the cells with different values."
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7303
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA


Return to Calc

Who is online

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