Bug 159901 - Calc=>Style: Hidden when print (Ukryj na wydruku)
Summary: Calc=>Style: Hidden when print (Ukryj na wydruku)
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.4.1 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-02-26 10:48 UTC by Jaroslaw
Modified: 2024-02-27 22:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
file with how to work "hidden when print" (13.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-02-27 07:00 UTC, Jaroslaw
Details
Modified sample file (19.70 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-02-27 22:30 UTC, m_a_riosv
Details

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