Bug 142205 - future request:Non-printable shapes(Improved compatibility with EXCEL)
Summary: future request:Non-printable shapes(Improved compatibility with EXCEL)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.0.alpha0+
Hardware: All Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Print
  Show dependency treegraph
 
Reported: 2021-05-11 01:23 UTC by qve00761
Modified: 2021-05-11 10:44 UTC (History)
1 user (show)

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


Attachments
NonPrintableShape (225.00 KB, application/vnd.ms-excel)
2021-05-11 01:27 UTC, qve00761
Details

Note You need to log in before you can comment on or make changes to this bug.
Description qve00761 2021-05-11 01:23:25 UTC
Description:
Feature Request

The xls and xlsx files created in Excel may have non-printable shapes or non-printable text boxes.
For example, there are notes and supplementary information in non-printable text boxes.

L.O does not have a function to exclude them from printing. 
Attribute information that is non-printable is lost. 

So I must delete them before printing.

In some cases, the original xls or xlsx file is corrected and returned to the creator of the original Excel file.
In that case, I want to make as few changes to the original document as possible.
However, due to compatibility issues with EXCEL, unintended changes are made. 


Steps to Reproduce:
1.Load xls and xlsx files containing non-printable shapes by CALC.
2.Print.
3.Non-printable shapes will also be printed. 


Actual Results:
Attribute information that is non-printable is invalid in CALC 


Expected Results:
In CALC, an interface is provided for the shape to specify information that is non-printable. 
Shapes that are non-printable are not printed. 

Attribute information of shapes that are non-printable can be read from xls or xlsx files by CALC.
Attribute information of shapes that are non-printable can be written to xls or xlsx files  by CALC.



Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice 7.2.0.0alpha0+(x86)
Comment 1 qve00761 2021-05-11 01:27:14 UTC
Created attachment 171855 [details]
NonPrintableShape

Sample of non-printable shape(xls)
Comment 2 NISZ LibreOffice Team 2021-05-11 07:41:44 UTC
Confirming there is no similar option on the Calc UI in:

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: d7f734db2c078ced3ce08ad58cd816a79abe3bcf
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

bug 119764 requests the support of this feature for XLSX files. 
We can keep this bug for the UI/ODF part.