Description:
AutoFormat applies format styles to the data in the row instead of to the row, resulting in nonsense formatting if the rows are sorted via AutoFilter

Steps to Reproduce:
1.Enter some data in a sheet
2.apply AutoFilter to the data via Data -> AutoFilter
3.apply AutoFormat to the data via https://help.libreoffice.org/7.5/en-US/text/scalc/guide/autoformat.html. Choose "Simple Grid Rows" format
4. sort the data via any header row dropdown

Actual Results:
Rows will sort into new order bringing their original color (light or dark) with them, leaving you with regions of multiple rows of dark or light highlighting next to each other.

Expected Results:
data in rows sorts independently of the alternating light and dark color of the rows.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 24.2.0.3 (X86_64) / LibreOffice Community
Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded