Description: Export xlsx/xls with "Automatically wrap text" turned off for cells containing line breaks with Ctrl+Enter, and when you open it again, the wrapping setting is turned on. Steps to Reproduce: 1.enter any text 2.Press Ctrl+Enter to break a line in the middle of text 3.Right click on that cell -> Format Cells -> Alignment tab 4.Make sure "Wrap text automatically" of Properties, is turned off 5.Export to xlsx or xls file 6.Open xlsx/xls file 7.Check "Wrap text automatically" setting Actual Results: "Wrap text automatically" setting is turned on Expected Results: "Wrap text automatically" setting is turned off Reproducible: Always User Profile Reset: No Additional Info: Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: ja-JP (ja_JP.UTF-8); UI: en-US Calc: threaded I checked and reported based on the information in the Ask below: https://ask.libreoffice.org/t/topic/98573
Issue has been reproduced.
I reproduced it Version: 7.6.3.2 (X86_64) / LibreOffice Community Build ID: 29d686fea9f6705b262d369fede658f824154cc0 CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL threaded
Also repro with Latin fonts, so it is not related to CTL nor specific to Japanese fonts. Saving as ods is fine.
There are several similar reports about exporting or saving the "wrap text automatically" cell attribute to either xlsx or to xls, but please note: * a cell containing multiple lines ([CTRL]+[ENTER]), with wrap text ON, exports correctly; * a cell containing multiple lines ([CTRL]+[ENTER]), with wrap text OFF, exports with wrap text ON. IOW, a cell containing multiple lines (with each line introduced with [CTRL]+[ENTER] within the same cell) is _always_ exported with wrap text ON > BUG. Also note that the way the text is displayed within the cell is not necessarily an indication of the status (ON/OFF) of the "wrap text automatically" attribute. You have to either check the cell properties or the status of the related icon on the toolbar.
Created attachment 191147 [details] Excel: a cell with a line break with wrap disabled I *suspect* that this is required in Excel: from a quick test, disabling wrap in a cell there merges the lines into a single line. Code reading is necessary, but most likely this it NOTABUG / NOTOURBUG (because it's an external application limitation).
There is difference of key code with calc and Excel for meaning break Line. In calc, that is Ctrl+Ent. But in excel, that is Alt+Ent. Is this difference concered with this issue?
(In reply to watanabe nobuo from comment #6) > There is difference of key code with calc and Excel for meaning break Line. > Is this difference concered with this issue? No.