[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 Mike Kaganski changed: What|Removed |Added Resolution|WORKSFORME |WONTFIX -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 Heiko Tietze changed: What|Removed |Added Blocks||120219 Resolution|--- |WORKSFORME Status|NEW |RESOLVED --- Comment #12 from Heiko Tietze --- Let's resolve it WF then. Meanwhile we have the Data Provider [1] that, while still in experimental state, should be already capable of filtering as requested. So ultimately WFM. Meta ticket is bug 120219. [1] https://libreoffice-dataproviders.blogspot.com/2021/08/data-providers.html [2] https://help.libreoffice.org/6.1/en-US/text/scalc/01/data_provider.html Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=120219 [Bug 120219] [META] Data provider bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 --- Comment #11 from Mike Kaganski --- IMO a clear WONTFIX. It would be something absolutely non-standard, implementing a very specific use case, but not helping at infinite number of alternative "filtering" scenarios. In case of "automation", you need a custom macro or the like. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||109239 CC||79045_79...@mail.ru Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=109239 [Bug 109239] [META] CSV import and export dialog bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 --- Comment #10 from j22...@gmail.com --- In the example file above, I would define the character "#" and thus all the rows starting with "#" would be ignored, and the file would contain only the data (eg for plotting, analysis, etc.) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 --- Comment #9 from j22...@gmail.com --- 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: https://www.ncei.noaa.gov/pub/data/paleo/paleolimnology/northamerica/canada/ellesmere/sawtooth2020.txt 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! -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 --- Comment #8 from Heiko Tietze --- (In reply to V Stuart Foote from comment #7) > No this would not be a columnar filtering. Here we are seeking to avoid > parsing entire _rows_ ... Ack, my mistake. But still, filtering 1..10, 25, 735 or the like is very special and better done internally. Or per extension. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 --- Comment #7 from V Stuart Foote --- (In reply to Heiko Tietze from comment #6) > ... since we have a dropdown "Column Type" where > "Hide" is an option, we could easily add "Delete" to the list. This wouldn't > affect the usability of the import dialog. But still, it's hard to imagine > that users click through all columns for fine-tuning the import. > ... No this would not be a columnar filtering. Here we are seeking to avoid parsing *entire* rows from the sourced CSV--think of comments/meta data surrounding the CSV. If the row or "record" matches the search the entire row would be excluded from the import, and not be parsed for columnar fielding. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 Heiko Tietze changed: What|Removed |Added CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org Keywords|needsUXEval | Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #6 from Heiko Tietze --- I fully agree with Miguel. But since we have a dropdown "Column Type" where "Hide" is an option, we could easily add "Delete" to the list. This wouldn't affect the usability of the import dialog. But still, it's hard to imagine that users click through all columns for fine-tuning the import. Maybe the better solution is a special extension or some kind of raw data preparation before the import. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 --- Comment #5 from m.a.riosv --- (In reply to V Stuart Foote from comment #4) > ... > Yes true except, pre-filtering the Text Import dialog could eliminate > unwanted stanzas/rows from the source CSV before they are parsed against the > field separators--both improving the accuracy of the data import, and > avoiding need to clean up data after the import. Maybe, but I don't think pre-filtering is so easy to implement, with that kind of pseudo-csv, e.g. difficult to know on where column the searched string is, or not all the data to eliminate with searched string it's in the same row. I'm not against, but IMO there are a lot of better things to get developers attention. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 --- Comment #4 from V Stuart Foote --- (In reply to m.a.riosv from comment #3) > With a few steps can be done after import, with more flexibility. > > On the sheet, e.g. select the column with the text to find, [Ctrl+H]"Find & > Replace", search for the string(s), Find All, click on the sheet window > title (to retain selected founded cells) and [Ctrl-] to delete all rows with > founded cells. Yes true except, pre-filtering the Text Import dialog could eliminate unwanted stanzas/rows from the source CSV before they are parsed against the field separators--both improving the accuracy of the data import, and avoiding need to clean up data after the import. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #3 from m.a.riosv --- With a few steps can be done after import, with more flexibility. On the sheet, e.g. select the column with the text to find, [Ctrl+H]"Find & Replace", search for the string(s), Find All, click on the sheet window title (to retain selected founded cells) and [Ctrl-] to delete all rows with founded cells. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV
https://bugs.documentfoundation.org/show_bug.cgi?id=138472 V Stuart Foote changed: What|Removed |Added Keywords||needsDevEval, needsUXEval Summary|Calc enhancement: ignore|Calc enhancement: ignore |rows when importing CVS |rows when importing CSV CC||er...@redhat.com, ||ko...@libreoffice.org, ||libreoffice-ux-advise@lists ||.freedesktop.org, ||vstuart.fo...@utsa.edu --- Comment #2 from V Stuart Foote --- Reasonable enhancement. Suppress import of a row matching some string. Imagine it could best be accomplished within the Import Text dialog using ICU regex. Perhaps in Other Options area, a Field to enter a regex string and Check-box to enable--then exclude the "row" from text column parsing. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs