Bug 149614 - Formatting does not disregard hidden rows when applying patterns.
Summary: Formatting does not disregard hidden rows when applying patterns.
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.7.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-06-19 09:14 UTC by yougen09
Modified: 2022-06-20 14:23 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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)