Created attachment 203807 [details] Example file from Excel 2013 Excel has a weird behavior regarding manual line breaks in referenced cells: it ignores these. Calc on the other hand respects these, causing layout differences. 1. In Excel, in A1 write two words and separate them with Alt+Enter: Hello World 2. Make a simple reference in B2: =A1 -> resulting text does not have the manual line break: HelloWorld 3. Save as XLSX, open it in Calc -> B2 has the line break, also it is taller just like row A. Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 620(Build:0) CPU threads: 16; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: de-DE (hu_HU); UI: en-US Calc: threaded and all the way back to 3.3 Ideally this weird behavior could be mimicked with a compatibility option or similar.
Created attachment 203808 [details] The example file in Excel and Calc side by side
Could it be a corner case. I don't think it would be considered a usual practice to reference cells with line breaks in order to obtain a cell without line breaks.