Issue 127817 - "Wrap text automatically" is always set on .xls file with linefeeds in cells
Summary: "Wrap text automatically" is always set on .xls file with linefeeds in cells
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.5
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-07-14 10:36 UTC by peterB
Modified: 2022-02-23 22:11 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Excel_autoWrapText.ods - export to .xls and reopen to show problem (11.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-07-14 10:36 UTC, peterB 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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...