Bug 121768 - Character font effect Overline is not retained on round trip to OOXML
Summary: Character font effect Overline is not retained on round trip to OOXML
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.6.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2018-11-28 16:23 UTC by David Allman
Modified: 2019-05-28 14:29 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David Allman 2018-11-28 16:23:27 UTC
Description:
I put an overline on several numbers in Calc, but after I saved them and return to the spreadsheet, the overline had disappeared.

Steps to Reproduce:
1.enter number in a cell
2.click on Format>Text>Overline
3.Save spreadsheet
4.Reopen spreadsheet

Actual Results:
Was visually there, on return to spreadsheet, it was not there.

Expected Results:
No longer visible 


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 V Stuart Foote 2018-11-28 18:59:52 UTC
No problem saving and reopening our native ODF .ods

But the font attribute "Overline" does not survive round trip to OOXML .xlsx, though "Underline" does.

Needinfo to OP, is this with save-as format MS OOXML, and does is it retained for you in native ODF .ods? 

=-testing-=

On Windows 10 Ent 64-bit en-US (1803) with current master
Version: 6.3.0.0.alpha0+
Build ID: f21d2b48bd68424a96aa6cd5572e368208378291
CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-11-27_00:26:54
Locale: en-US (en_US); UI-Language: en-US
Calc: CL

and on 6.1.3.2
Comment 2 QA Administrators 2019-05-28 02:47:46 UTC Comment hidden (obsolete)
Comment 3 David Allman 2019-05-28 12:51:10 UTC
I quite using the over-line function.
Comment 4 V Stuart Foote 2019-05-28 14:29:42 UTC
Loss of cell overline font effect on round trip to OOXML is confirmed.

Version: 6.2.4.1 (x64)
Build ID: 170a9c04e0ad25cd937fc7a913bb06bf8c75c11d
CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: CL

Valid issue. But seems OOXML does not support Font effect formatting for overline. And MS Office 2016 opens ODF (Text, Spreadsheet, Presentation) containing them without any overline font effects.