[Libreoffice-bugs] [Bug 120164] New: FILEOPEN XLSX Different font effects (Overlining, Strikethrough) in a cell

[b***@bugs.documentfoundation.org]

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

Bug ID: 120164
Summary: FILEOPEN XLSX Different font effects (Overlining,
Strikethrough) in a cell
Product: LibreOffice
Version: 6.2.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@ubuntu.com

Created attachment 145222
--> https://bugs.documentfoundation.org/attachment.cgi?id=145222&action=edit
Example file with strikethrough and overlining

If we set a Superscript font effect with Strikethrough, and overlining, the
text looks different in LibreOffice Calc and Microsoft Excel.

Steps to reproduce:
1. Create a new spreadsheet with Microsoft Excel 2010/2013/2016
2. Fill the A1 cell with a simple text (e.g.: a2+b2=c2)
3. Set the numbers font effect to “Superscript”, and “Strikethrough” the first
two numbers.
4. Overline the A1 cell text with a single line.
5. Save the file as *.xlsx
6. Open the file with LibreOffice Calc

Actual results:
The underline is not continuous and under the “Strikethrough” numbers there is
another “strikethrough” line”.

Expected results:
The underline should be continuous and under the “Strikethrough” numbers should
not be another “strikethrough” line.

Version: 6.2.0.0.alpha0+
Build ID: a27ae800fed5a974c9b255f7ce2b38ec2dbaa426
CPU threads: 4; OS: Windows 6.3; UI render: default;
Locale: hu-HU (hu_HU); Calc: CL

[b***@bugs.documentfoundation.org]

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

--- Comment #1 from Gabor Kelemen <***@ubuntu.com> ---
Created attachment 145223
--> https://bugs.documentfoundation.org/attachment.cgi?id=145223&action=edit
Screenshot of the file in Excel and Calc side by side

[b***@bugs.documentfoundation.org]

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

MM <***@vivaldi.net> changed:

What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
Version|6.2.0.0.alpha0+ Master |6.0.6.2 release
Status|UNCONFIRMED |NEW

--- Comment #2 from MM <***@vivaldi.net> ---
Confirmed on windows 7 x64 with Version: 6.0.6.2 (x64)
Build ID: 0c292870b25a325b5ed35f6b45599d2ea4458e77
CPU threads: 3; OS: Windows 6.1; UI render: default

[b***@bugs.documentfoundation.org]

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

Roman Kuznetsov <***@mail.ru> changed:

What |Removed |Added
----------------------------------------------------------------------------
Blocks| |108897


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker