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: 2018-07-14 10:37 UTC (History)
1 user (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

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.