Because the values come from formulas, instead of using Google Apps Script using QUERY or SORT functions.

Regarding QUERY, you will have to use the ORDER BY clause to sort the values.

Because the values come from formulas, instead of using Google Apps Script using QUERY or SORT functions.

Regarding QUERY, you will have to use the ORDER BY clause to sort the values.

Related

• Google spreadsheets sorting confusion when using formulas