Created attachment 145387 [details] Example file with cell content aligned with consecutive spaces and wrap text Attached XLSX was created with Excel. The text in cell A1 has Wrap text set and some consecutive spaces after the first word, as an attempt at manually determining the place of the line breaking. In Excel this pushes the next word to a new line, but the overall horizontal alignment of visible text in that line is not affected: we can add more spaces to the end, and nothing happens. In Calc all spaces are considered as part of the text to be horizontally aligned. We see a lot of such documents in the wild, so maybe a similar "let's figure out what they actually wanted" behavior would be desirable.
Created attachment 145388 [details] Screenshot of the document in Excel 2010 and Calc 6.1 Verzió: 6.1.0.3 Build az.: efb621ed25068d70781dc026f7e9c5187a4decd1 CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: alapértelmezett; Területi beállítások: hu-HU (hu_HU); Calc: group threaded
Seems another case to implement in LibreOffice a not right way to work on excel. What happen with LibreOffice people, that maybe use of the LibreOffice behavior.
Pro Excel: the text looks more sleek Pro LibO: the user can modify the text position with spaces like second line right-aligned Pro LibO: the content is more clear (select the white spaces in the function bar) and easier to edit (you can also select it on the cell) I tend to WFM, other opinions?
poeh... nasty question. @gabor: what happens in Excel if one increases row height? Will it split text over more lines, or ?? I'm trying to understand why we see 4 lines in Excel and 3 in Calc...
Forcing line break by spaces is bad practice and not needed at all. Excel has a proper line break, use Alt+Enter. That is correctly rendered in LibreOffice. The desired appearance is broken in Excel, if you alter the width of the cell. I would do nothing about the spaces. But I agree with Cor, that there is a problem with the cell height. Not only the total height is larger in LibreOffice than in Excel, but LibreOffice has a smaller line spacing than Excel.
(In reply to Cor Nouws from comment #4) > poeh... nasty question. > > @gabor: what happens in Excel if one increases row height? Will it split > text over more lines, or ?? > I'm trying to understand why we see 4 lines in Excel and 3 in Calc... That's bug #112561 - Excel uses a 1.12 line spacing for multiline text
For me the dealing with consecutive spaces is correct in LibreOffice and false in MSO Excel. The Excel-behavior misleads to wrong formatting as we can see in the attached example spreadsheet. This is a WFM. But beside the space handling, the visual appearance of this example cell text is indisputably negative in LibreOffice. The cell/row height is defined by Excel/xlsx and doesn't depend on the multi-line text height of LibreOffice. For me, this is OK because otherwise all spreadsheets would look entirely different in both programs. Gabor mentioned bug 112561 which would solve the multi-line text spacing issue that also leads to the wrong-looking row height in the example file.
We discussed the topic in the design meeting and agreed on resolving as WFM.