[Libreoffice-bugs] [Bug 138472] New: Calc enhancement: ignore rows when importing CVS

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138472

            Bug ID: 138472
           Summary: Calc enhancement: ignore rows when importing CVS
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: J22Gim at gmail.com

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".

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201124/f9e0da1d/attachment-0001.htm>