Calc sort not using changed menu

English
,
#1

Sheet was sorted using menu with column headings by Column A, G (Winery, location). Saved. Windows restarted. Attempt to sort by G, D (location, year). No changes or error messages. Sorting with range and no labels works.
wine work.ods (38.6 KB)

Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded

#2

Add some column label to cell I1. The empty cell prevents detection of column labels.

1 Like
#3

Added label and tried sorting by Location (G). Still no change.

#4

Thanks for the quick response. Didn’t work tho.

#5
  1. Click any single cell in the column you want to sort.
  2. Click a quick sort button “A-Z” or “Z-A” on the main toolbar.
    W9EkHeiH12
#6

Let’s go step by step.

  1. Select cell A1 of Sheet1.
  2. Menu / Data / Sort.
    As a result, the cell range A1:I77 should be selected.
    The sorting dialog shows the keys: winery, Wine, Year.
    Right?
#7

No. It shows whatever criteria I entered in menu. Just doesn’t sort by that criteria, only the first criteria I used. Earlier comment suggested using the A:Z sort which worked for the location column and reset the sort menu. Once I use the menu again, say sort on wine/year, using the menu will only sort on wine year regardless of what is entered.

#8

Comment to Villeroy, his works for a single criteria and resets the data/sort menu. Next sort using menu becomes the only order for subsequent menu use.

I do thank you both for helping me.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.