<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - [FORMATTING] automatic column size for strings seems to be adjusted to string character count, not effective size (it disregards newline characters)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127027">127027</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>[FORMATTING] automatic column size for strings seems to be adjusted to string character count, not effective size (it disregards newline characters)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>minor
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>xtrajoris@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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:</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>