https://bugs.documentfoundation.org/show_bug.cgi?id=169326
Bug ID: 169326
Summary: FILEOPEN XLSX Calc does not ignore line break in
referenced cells text
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 108897
Created attachment 203807
--> https://bugs.documentfoundation.org/attachment.cgi?id=203807&action=edit
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.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
--
You are receiving this mail because:
You are the assignee for the bug.
