Sorting is the process of arranging the data in alphabetical or numeric order either in ascending order or descending order.
1. Absolute Cell Reference
Ex: $A$5
2. Relative Cell Reference
Ex: A5
3. Mixed Cell Reference
Ex: $A5 or A$5
In Calc, each sheet can have a maximum of 1,048,576 rows (65,536 rows in Calc 3.2 and earlier) and a maximum of 1024 columns. LibreOffice Calc can hold up to 32,000 sheets.
the maximum number of individual sheets in a complete worksheet is 10000.
it will work for only Date Type of Vales.