[Libreoffice-bugs] [Bug 134855] New: EDITING Header text has character limit in Excel which can be broken by Calc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134855

            Bug ID: 134855
           Summary: EDITING Header text has character limit in Excel which
                    can be broken by Calc
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org
            Blocks: 104839

Created attachment 163101
  --> https://bugs.documentfoundation.org/attachment.cgi?id=163101&action=edit
Example file from Excel with 253 characters in the header

In Excel there is a limitation on the combined text length of the header/footer
text of 255 characters, including the left/center/right parts and all
formatting, documented in [MS-OI29500] under:
2.1.619 Part 1 Section 18.3.1.41, firstFooter (First Page Footer) 
2.1.620 Part 1 Section 18.3.1.42, firstHeader (First Page Header) 
2.1.631 Part 1 Section 18.3.1.57, oddFooter (Odd Page Footer) 
2.1.632 Part 1 Section 18.3.1.58, oddHeader (Odd Header) 

(although
2.1.1455 Part 1 Section 21.2.2.59, evenFooter (Even Footer) 
2.1.1456 Part 1 Section 21.2.2.60, evenHeader (Even Header) 
do not mention it, at least in my copy.)

The Excel GUI enforces this limit at document creation time, but Calc does not.
Consequently it is possible to create headers/footers of 255 character or
longer, save them as XLSX which causes an “Invalid contents detected” warning
in Excel.


Steps to reproduce:
    1. Open attached file in Calc
    2. Go to Insert – Headers and footers
    3. Add one more character to the header, save the file and open it in Excel

Actual results:
Excel detects invalid contents in the file. If you let it fix, it will remove
all the sheet properties from /xl/worksheets/sheet1.xml

Expected results:
Calc could have an option to enforce 255 character header / footer length limit
at editing time, for OOXML-heavy environments.

LibreOffice details:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: f7eff4319be741143f6d8d5e0f2995e3ce46b126
CPU szálak: 4; OS: Windows 6.3 Build 9600; Felületmegjelenítés: Skia/Raster;
VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200716/dc110fe1/attachment.htm>