Bug 149614

Summary: Formatting does not disregard hidden rows when applying patterns.
Product: LibreOffice Reporter: yougen09
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: UNCONFIRMED ---    
Severity: enhancement CC: iavs.leroy
Priority: medium    
Version: 7.2.7.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description yougen09 2022-06-19 09:14:34 UTC 
Description:
Whenever I apply a pattern when I have hidden rows, the software assumes as if the rows are shown which creates an improper pattern.

Steps to Reproduce:
1.Hide Rows
2.Apply Auto Format (Odd and Even Rows Highlighting)


Actual Results:
Hidden rows are accounted as if they are not hidden.

Expected Results:
Highlighting every other row.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Mac OS X (All)
OS is 64bit: no
Comment 1 LeroyG 2022-06-19 14:19:39 UTC 
Menu Format - AutoFormat Styles (or equivalent button in Tools toolbar).

Maybe it can be added a checkbox to the dialog (something like "[] Count hidden rows/columns"). Changing Importance to Enhancement.

By the way, AutoFormat Styles can not be applied to discontinuos ranges (i.e., rows 1:3 and 5:6).

As a workaround (if there are no formula affected): add rows as necessary to hide an even number of rows in each continuos range.
Comment 2 lucia jon 2022-06-20 14:20:45 UTC Comment hidden (spam)
Comment 3 lucia jon 2022-06-20 14:22:13 UTC Comment hidden (spam)
Comment 4 lucia jon 2022-06-20 14:23:43 UTC Comment hidden (spam)