Download it now!
Bug 120164 - FILEOPEN XLSX Different font effects (Overlining, Strikethrough) in a cell
Summary: FILEOPEN XLSX Different font effects (Overlining, Strikethrough) in a cell
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2018-09-27 19:12 UTC by Gabor Kelemen
Modified: 2019-12-30 07:32 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file with strikethrough and overlining (16.86 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-09-27 19:12 UTC, Gabor Kelemen
Details
Screenshot of the file in Excel and Calc side by side (95.46 KB, image/png)
2018-09-27 19:13 UTC, Gabor Kelemen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen 2018-09-27 19:12:40 UTC
Created attachment 145222 [details]
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
Comment 1 Gabor Kelemen 2018-09-27 19:13:38 UTC
Created attachment 145223 [details]
Screenshot of the file in Excel and Calc side by side
Comment 2 MM 2018-10-02 21:59:50 UTC
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
Comment 3 QA Administrators 2019-12-10 04:06:09 UTC Comment hidden (obsolete)
Comment 4 Roman Kuznetsov 2019-12-30 07:32:00 UTC
still repro in

Version: 6.5.0.0.alpha0+ (x64)
Build ID: 42a1a1c6b91907f81e15066ffab219411f18c4db
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded