https://bugs.documentfoundation.org/show_bug.cgi?id=162805
Bug ID: 162805
Summary: AutoFormat for Tables does not play nice with
AutoFilter
Product: LibreOffice
Version: 24.2.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
