Bug #279
closedColumn Number Mismatch Errors
0%
Description
The daily software (20120811) now seems to handle the lines ending in CR (\r) only - maybe. At least the first 15 entries seem to be read fine.
I encountered a problem with CSV files created or edited by Mac Excel 11.6.5. I have created 9 entries in Excel and replicated them 3 times to get 27 entries (Test.csv). When I load the file (actually any Excel created or edited file with more than 15 entries), I get a Column Number Mismatch on every line starting with Line 16 (ColumnNumberMismatch.jpg). Reading CSV files longer than 15 entries that were created by CHIRP seem to work fine. So there seems to be a problem with Excel created or edited CSV files. Not sure if the problem relates back to Issue 271 or not.
I have tried the experiment with the KG-UV6D and the FT-8800R CSV files created/edited in Excel with the same results.
Regards,
Chuck
Files
| Test.csv (1.59 KB) Test.csv | |||
| ColumnNumberMismatch.jpg (164 KB) ColumnNumberMismatch.jpg |
Updated by Tom Hayward over 12 years ago
16-27 are missing a bunch of commas at the end of the line. The line endings are consistent (\r).
Updated by Chuck Burton over 12 years ago
Sorry, should have looked at it in a text editor. It is an Excel problem - thanks Microsoft. Thanks for fixing the \r problem.
Updated by Tom Hayward about 12 years ago
- Status changed from New to Rejected
Rejecting this bug as "not Chirp's fault"