Description: When merging cells in Libreoffice Calc, there is an option to append the hidden cells into the main cell. However when this option is used, cells do not retain their structure, i.e. text in lower cells do not remain lower but get pushed to the right since there is no linebreaks and the result is only a single line. It would be nice if I could merge the cells while keeping the structure, like tabs and linebreaks, which are normally used when transferring tables in text-only applications. This would also make it easy to "unmerge" cells later, by simply copying that cell's content and pasting it at the destination. Steps to Reproduce: 1.create more than 1 adjacent cell with content in each cell 2.select the cells 3.right click and select merge cells Actual Results: Dialog box with options that do not include linebreaks Expected Results: Dialog box with option to keep cell structure using tabs and/or using linebreaks Reproducible: Always User Profile Reset: No Additional Info: Version: 7.3.7.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.3 Calc: threaded
+1
What exactly is a line break? Two characters CR/LF, I guess. And for horizontally merged cells you probably go with a tab character.
My guess, merging vertically a line break, horizontally a tab. But I tested that tabs are not displayed in cells. ="hola"&CHAR(9)&"adios"
(In reply to m.a.riosv from comment #1) > +1 + 1
We discussed the topic in the design meeting. While there are concerns that using #9/#13 is possible in general thinking of copy/paste, for example, such an improvement sounds good for many. Currently we separate everything with spaces and A1=1, B1=2, A2=3, B2=4 becomes "1 2 3 4" likewise A1:A4 or A1:D1. Giving better feedback on the configuration before merging is an improvement in itself. If this can be applied when splitting later it would be nice.