Description: I have a collection (CSV file) of very long strings containing newline characters to improve readability (not my choice - the API forces me to). When opening the CSV with LibreOffice Calc, the vertical size of the cells containing the 'array strings' is correct (shows multiple lines), but the horizontal cell size seems to be determined by the character count of the longest string, disregarding newline characters. As a result, the column is much broader than needs to be for this kind of content. It should only be as broad as the longest line (which ends on a newline character). Note: I don't know the earliest affected version, but it's been this way for as long as I can remember. At least 2 years? Steps to Reproduce: 1.create long strings that contain newline characters 2.save to csv 3.open again with Calc Actual Results: column with long strings is very broad Expected Results: column with long strings should be as broad as the longest line (which ends on a newline character) Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 153847 [details] screenshot
Apologies, it seems that there are NO newline characters present in the string. This means this bug considers text wrapping and is not based on the presence of newline characters. This implies the problem is more general that previously thought. I also added a screenshot.
Comment on attachment 153847 [details] screenshot the bottom few entries of column agg_sc exhibit text wrapping (as desired) but the column width is not adapted to the wrapped text.
Please attach an example document. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 159687 [details] example file exhibiting the bug csv file. the value in column 'agg_sc' exhibits the erroneous behaviour described in the original report.
[Automated Action] NeedInfo-To-Unconfirmed
Thanks, now I understand it and I found an older report. *** This bug has been marked as a duplicate of bug 59820 ***