Sorting is the process of arranging the data in alphabetical or numeric order either in ascending order or descending order.
1. Absolute Cell Reference
2. Relative Cell Reference
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.