Ask Your Question

In Calc How do I save sort criteria [closed]

asked 2018-03-08 18:18:41 +0100

jwbruce gravatar image

updated 2020-08-07 14:28:48 +0100

Alex Kemp gravatar image

I have a complex, 9-criteria, sort in a spread sheet I use daily. When I save and close it, only the first three criteria are saved. I want it to save all 9 criteria.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-07 14:29:10.645049

2 Answers

Sort by » oldest newest most voted

answered 2018-03-08 22:49:17 +0100

m.a.riosv gravatar image

updated 2018-03-08 22:50:20 +0100

If I'm not wrong it needs to have a defined data range, Menu/Data/Define range, while in a cell of the range, set up the sort criteria and options.

edit flag offensive delete link more

answered 2018-03-09 19:08:37 +0100

jwbruce gravatar image

Thank you, but that didn't work. When I reopen the spreadsheet, it saved only the first three criteria in the sort.

edit flag offensive delete link more


Please use comments for comment. Can you report the bug

m.a.riosv gravatar imagem.a.riosv ( 2018-03-09 22:18:50 +0100 )edit

Question Tools

1 follower


Asked: 2018-03-08 18:18:41 +0100

Seen: 390 times

Last updated: Mar 09 '18