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: jan_janousek, knmc, 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.
Comment 1 Jan Janousek 2022-02-22 13:03:58 UTC
The very same buggy behavior encountered (OpenOffice 4.1.11).
Comment 2 Keith N. McKenna 2022-02-23 20:40:07 UTC
Removed latest Confirmation, as the report has never been independently confirmed.
Comment 3 Jan Janousek 2022-02-23 22:11:56 UTC
You can easily confirm: Just try to follow the description...