<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Calc enhancement: ignore rows when importing CSV"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138472#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Calc enhancement: ignore rows when importing CSV"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138472">bug 138472</a>
from <span class="vcard"><a class="email" href="mailto:J22Gim@gmail.com" title="J22Gim@gmail.com">J22Gim@gmail.com</a>
</span></b>
<pre>May I mention again that the original point of this is to avoid loading rows
with no data. This happens when the beginning (a given amount of rows) have
information about how data was stored, collected, calculated, etc. but it is
mostly metadata.
Here its an example of such file:
<a href="https://www.ncei.noaa.gov/pub/data/paleo/paleolimnology/northamerica/canada/ellesmere/sawtooth2020.txt">https://www.ncei.noaa.gov/pub/data/paleo/paleolimnology/northamerica/canada/ellesmere/sawtooth2020.txt</a>
So the original idea was to define a character or string which would be
encountered at the *beginning* of a row, and thus avoid loading that row.
Additionally, if that string is "" (ie empty string), it would be a way to
avoid loading empty files.
I am not sure (but also not against) about searching that string in anywhere in
the row. I can't imagine the usefulness of that, but if it is the same work
then why not.
Just wanted to reinforce the idea of the original post.
Thanks for this wonderful software!!
PD. CVS-related support will be increasingly important, as it is the preferred
format to work with Python, R, and many others. And Python (and many others)
already have libraries to load and save as XLSX, so LibreOffice should not stay
behind!</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>