Issue 123190

Summary: CSV import: sticky "from row" leads to truncated or empty imports
Product: Calc Reporter: tim
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues, tim
Version: 4.0.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Screenshot with explanation none

Description tim 2013-09-05 14:49:50 UTC
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.)
Comment 1 Edwin Sharp 2013-09-08 07:13:57 UTC
Please attach CSV file.
Comment 2 tim 2013-09-09 14:26:35 UTC
Created attachment 81494 [details]
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.)
Comment 3 tim 2013-09-09 14:27:16 UTC
See screenshot and explanation.
Comment 4 Edwin Sharp 2013-09-09 18:57:32 UTC
Thank you for the explanation.

From row field having memory even after closing AOO is indeed a bad thing.