[Libreoffice-bugs] [Bug 134826] New: FILEOPEN XLSX Support Hungarian font style names in spreadsheet headers

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 134826
           Summary: FILEOPEN XLSX Support Hungarian font style names in
                    spreadsheet headers
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nagy.tibor2 at nisz.hu, nemeth at numbertext.org,
                    szucs.attila3 at nisz.hu
            Blocks: 134391

Created attachment 163049
  --> https://bugs.documentfoundation.org/attachment.cgi?id=163049&action=edit
Example file from Excel with different styles applied to header text

This is split off from bug #134316
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


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=134391
[Bug 134391] [META] XLSX (OOXML) Header-footer related issues
-- 
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/20200715/25360910/attachment-0001.htm>