<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 - Calc enhancement: ignore rows when importing CVS"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138472">138472</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc enhancement: ignore rows when importing CVS
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>3.3.0 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</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>J22Gim@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Many times we get data files as CVS from 3rd parties. These files often have
comments and explanations which are not relevant to eg making plots.
It would be great to have an option in the CVS import dialog where the user can
ignore some rows. I am aware that you can "ignore" the first x rows, however if
you want to automate this task you would need to know X for each and all files
to be imported.
As comments rows start with different character in different uses or data
sources, it would be convenient to be able to chose that character.
So I propose to include an option in this dialog which let the user
"ignore rows starting with [] character" where [] is a text box.
Steps to Reproduce:
Open CSV in Calc.
Lets imagine the file has a number of rows (which you do not know in advance)
that are comments and you don't need them to work with Calc. Each line of the
comments starts with "#"
Actual Results:
You get a dialog where several options are presented, eg the character which
separates the values (eg "," ";" etc).
But you can not discard the comments rows. So you have to load the whole file,
then manually delete the rows.
Expected Results:
It would be great if there was the option in the import dialog, something like
a click box to activate the option "Ignore the rows starting with []" where []
is a text box where the user would place the "comment character" ("#" in this
case)
Reproducible: Always
User Profile Reset: No
Additional Info:
Additionally, this could be useful to ignore empty lines, for example writing
"" (empty string) into the "ignore box".</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>