You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/09/05 16:49:50 UTC
[Bug 123190] New: CSV import: sticky "from row" leads to truncated
or empty imports
https://issues.apache.org/ooo/show_bug.cgi?id=123190
Bug ID: 123190
Issue Type: DEFECT
Summary: CSV import: sticky "from row" leads to truncated or
empty imports
Product: Calc
Version: 4.0.0
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: issues@openoffice.apache.org
Reporter: tim@idgevanston.com
CC: issues@openoffice.apache.org
The "From Row" option should reset to zero or be highlighted/pop up a query to
the user if greater than zero. I was unable to get data into OO Calc from CSV
files after changing the value to "2000" once. I could not figure out why all
my imports were empty. (I was lucky, because if I had done "from row 5" I would
have been losing data and be unaware it was happening.)
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123190] CSV import: sticky "from row" leads to truncated or
empty imports
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123190
Edwin Sharp <el...@mail-page.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords|needmoreinfo |
Status|UNCONFIRMED |CONFIRMED
Ever confirmed|0 |1
--- Comment #4 from Edwin Sharp <el...@mail-page.com> ---
Thank you for the explanation.
>From row field having memory even after closing AOO is indeed a bad thing.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123190] CSV import: sticky "from row" leads to truncated or
empty imports
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123190
tim@idgevanston.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |tim@idgevanston.com
--- Comment #2 from tim@idgevanston.com ---
Created attachment 81494
--> https://issues.apache.org/ooo/attachment.cgi?id=81494&action=edit
Screenshot with explanation
I was asked to attach a sample CSV file, but the defect would be true with ANY
CSV file. To reproduce:
1) Import a CSV file and set all your import setting, INCLUDING making "From
row:" greater than 1.
2) Open a second, different CSV file. Setting are matched to your last import,
including "From row:" line.
This is easily overlooked and can cause unexpected results.
I suggest one of the following solutions
A) a warning if >1 to alert user
B) an auto-reset to 1
C) only make "sticky" for the same exact filename.
D) A color highlight in GUI interface for this area if greater than 1
Method A, the warning, is my preferred solution. (I guess you could include a
checkbox asking to suppress the warning on future imports for people who always
want to skip row 1, for example.)
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123190] CSV import: sticky "from row" leads to truncated or
empty imports
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123190
Edwin Sharp <el...@mail-page.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
CC| |elish@mail-page.com
--- Comment #1 from Edwin Sharp <el...@mail-page.com> ---
Please attach CSV file.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123190] CSV import: sticky "from row" leads to truncated or
empty imports
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123190
--- Comment #3 from tim@idgevanston.com ---
See screenshot and explanation.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.