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.
3.Non-printable shapes will also be printed.
Attribute information that is non-printable is invalid in CALC
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.
User Profile Reset: No
Created attachment 171855 [details]
Sample of non-printable shape(xls)
Confirming there is no similar option on the Calc UI in:
Version: 126.96.36.199.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
bug 119764 requests the support of this feature for XLSX files.
We can keep this bug for the UI/ODF part.