Bug 159901

Summary:	Calc=>Style: Hidden when print (Ukryj na wydruku)
Product:	LibreOffice	Reporter:	Jaroslaw <j.fliski>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	UNCONFIRMED ---
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	7.6.4.1 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	file with how to work "hidden when print" Modified sample file

Description Jaroslaw 2024-02-26 10:48:43 UTC

Description:
Hidden ONLY info in cells, but not frame.
In my opinion: frame is part of cell.

Actual Results:
Print frames without info in cells

Expected Results:
Print clear space - no frames, no info in cells

More powerfulll effect: when all cells in row "Hidden when print" then this line height=0 to print.


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: pl
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

Comment 1 m_a_riosv 2024-02-26 22:22:14 UTC

Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.

Comment 2 Jaroslaw 2024-02-27 07:00:12 UTC

Created attachment 192815 [details]
file with how to work "hidden when print"

This file included information in what set (Sytle, conditional formating)

Comment 3 m_a_riosv 2024-02-27 22:30:26 UTC

Created attachment 192835 [details]
Modified sample file

You have set up the borders with direct format, which overrides the styles options.

The best way is to clear the direct format in those cells, and set up the styles, one for not protected, and one for use with the conditional format, making the second descending from the first, you only need to change the protection.