[Libreoffice-bugs] [Bug 121167] New: FORMATTING: document (.xlsx) formatting deteriorates due to incorrect parameter order at styles.xml (<cellXfs><xf PARAMS ... />)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 121167
           Summary: FORMATTING: document (.xlsx) formatting deteriorates
                    due to incorrect parameter order at styles.xml
                    (<cellXfs><xf PARAMS ... />)
           Product: LibreOffice
           Version: 6.1.2.1 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: meltsv at rambler.ru

Description:
I have a template (.xlsx) with 1 formatting cell (aligment, height, width,
wrap). It is perfectly displayed in Excel (2010) and Calc (6.1.2.1). 

Set value to second cell by C# code and EPPlus (test Console App .NET 4.7.1 and
last EPPlus 4.5.2.1). Finally document is perfectly displayed only in Excel,
but in Calc without good formatting. If open it in Excel and Save then new
document is displayed perfectly in Calc too. I unpacking .xlsx and compared
xl/styles.xml after epplus file and after excel saving. I find significant
changes in block <cellXfs><xf PARAMS ... />, namely in the order of parameters.
If get block <cellXfs> from Excel file and set it to epplus file, pack to .xlsx
then it is displayed perfectly in Calc. 

Faced with this problem on a large template in production, this is a test
example. Checked it on some machines. Later I will report a bug in EPPlus.

Steps to Reproduce:
1. Create new .xlsx document in Excel
2. Format "A2" cell - height, width, wrap, aligment, etc.
3. Set value to "A1" cell by EPPlus (and C# for example)


Actual Results:
Formatting "A2" cell is preserved in Excel, but no in Calc

Expected Results:
Formatting "A2" cell is preserved in Excel and Calc


Reproducible: Always


User Profile Reset: Yes



Additional Info:
I don't find "Add an Attachment", all files in cloud
https://1drv.ms/f/s!ArAS3ailIBF4iexR4-0LtWwE3SFOQA 

Версия: 6.1.2.1 (x64)
ID сборки: 65905a128db06ba48db947242809d14d3f9a93fe
Потоков ЦП: 8; ОС:Windows 10.0; Отрисовка ИП: по умолчанию; 
Локаль: ru-RU (ru_RU); Calc: group threaded

-- 
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/20181104/fe1858ea/attachment.html>