<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 - FILEOPEN XLSX Support Hungarian font style names in spreadsheet headers"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134826">134826</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX Support Hungarian font style names in spreadsheet headers
</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>Keywords</th>
<td>filter:xlsx
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</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>nagy.tibor2@nisz.hu, nemeth@numbertext.org, szucs.attila3@nisz.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>134391
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=163049" name="attach_163049" title="Example file from Excel with different styles applied to header text">attachment 163049</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=163049&action=edit" title="Example file from Excel with different styles applied to header text">[details]</a></span>
Example file from Excel with different styles applied to header text
This is split off from <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILESAVE XLSX Header character formatting partially saved (with default font)"
href="show_bug.cgi?id=134316">bug #134316</a>
In Excel if there is a header with custom font style set for the text, being
one of Normal, Bold, Italic Bold Italic, this localized style name is not only
displayed in the Excel GUI, but actually gets written into the XLSX file.
ISO/IEC 29500-1:2016(E) section 18.3.1.46 headerFooter (Header Footer Settings)
explicitly allows this for the &"font name,font type" formatting code.
Calc does not support reading this for many languages, English and German being
the exceptions so far.
Here we ask for addition of Hungarian too (and to open the gate for other
languages).
On the other hand exporting such localized font style names from a newly
created spreadsheet to XLSX works fine and Excel recognizes them correctly
(provided both Calc and Excel have same locale) – but Calc after a reload, does
not, except for files saved with German locale.
Steps to reproduce:
1. Open attached file
2. Go to Insert – Headers and Footers
Actual results:
The left and right side sections show all text in normal style.
Expected results:
The left and right side sections should display text in bold, italic,
bold+italic styles.
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] XLSX (OOXML) Header-footer related issues"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134391">Bug 134391</a>] [META] XLSX (OOXML) Header-footer related issues
</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>