<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - EDITING Header text has character limit in Excel which can be broken by Calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134855">134855</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING Header text has character limit in Excel which can be broken by Calc
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>libreoffice@nisz.hu
</td>
</tr>
<tr>
<th>CC</th>
<td>nemeth@numbertext.org
</td>
</tr>
<tr>
<th>Blocks</th>
<td>104839
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=163101" name="attach_163101" title="Example file from Excel with 253 characters in the header">attachment 163101</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=163101&action=edit" title="Example file from Excel with 253 characters in the header">[details]</a></span>
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</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Saved XLSX files that MS Excel can't open"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=104839">Bug 104839</a>] [META] Saved XLSX files that MS Excel can't open
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>