Issue 127817

Summary: "Wrap text automatically" is always set on .xls file with linefeeds in cells
Product: Calc Reporter: peterB <Peter.Binney>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: Peter.Binney
Version: 4.1.5   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Excel_autoWrapText.ods - export to .xls and reopen to show problem none

Description peterB 2018-07-14 10:36:51 UTC
Created attachment 86453 [details]
Excel_autoWrapText.ods - export to .xls and reopen to show problem

In .ods files, you can enter text on multiple lines, using Ctrl-Enter.
If a cell with such text has "Wrap text automatically" disabled (ie: default formatting), this is retained when you save and re-open the file.

But, if you save the file as .xls - Microsoft Excel 97/2000/XP (.xls) (*.xls) – and reopen it, cells with such text have auto-wrap set.

I attach Excel_autoWrapText.ods showing the problem when you export it to .xls and reopen.