Bug 136006 - Shapes in LO Calc do not get hidden from print preview UI when hidden from printing
Summary: Shapes in LO Calc do not get hidden from print preview UI when hidden from pr...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro
  Show dependency treegraph
 
Reported: 2020-08-22 07:27 UTC by Aswin
Modified: 2021-07-23 03:38 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
The file can be used to reproduce the scenario (9.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-08-22 07:33 UTC, Aswin
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Aswin 2020-08-22 07:27:39 UTC
Description:
When I add a shape to a spreadsheet and hide it from printing using a macro, the shape gets hidden from printing, but not in the print preview and when exporting it as a pdf. This issue is only present in Calc and not in draw

Steps to Reproduce:
1. Add a shape in a calc spreadsheet and assign a name to the shape
2. Hide the shape from printing by executing a macro as shown in attached file
3. Check print preview or export the file as a pdf

Actual Results:
The shape is visible in the print preview UI and while exporting as a pdf

Expected Results:
The shape should have been hidden in the print preview UI and while exporting as a pdf


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.3.6.2
Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497
CPU threads: 4; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; 
Locale: en-IN (en_IN.UTF-8); UI-Language: en-US
Calc: threaded

I have tried this in OO 4.1.5 and it is reproducible.
Comment 1 Aswin 2020-08-22 07:33:10 UTC
Created attachment 164547 [details]
The file can be used to reproduce the scenario
Comment 2 Vladislav Kim 2021-07-22 09:26:15 UTC
Repro in 

Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 6; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL