796833 – Excel csv Format misprocessed

Bug 796833 - Excel csv Format misprocessed

Summary: Excel csv Format misprocessed

Status:	RESOLVED FIXED

Alias:	None

Product:	GnuCash
Classification:	Unclassified
Component:	Import - CSV (show other bugs)
Version:	3.1
Hardware:	PC Mac OS

Importance:	Normal normal
Target Milestone:	---
Assignee:	import
QA Contact:	import

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2018-08-29 15:27 EDT by David
Modified:	2018-09-04 05:29 EDT (History)
CC List:	3 users (show)

See Also:

Attachments
Test csv file from Excel (113 bytes, text/csv) 2018-08-29 15:27 EDT, David	no flags	Details
Screen shot of importer (290.59 KB, image/png) 2018-08-29 15:29 EDT, David	no flags	Details
View All Add an attachment (proposed patch, testcase, etc.)

Description David 2018-08-29 15:27:57 EDT

Created attachment 372954 [details]
Test csv file from Excel

When using a csv file saved from Excel for Mac 2011, importer cannot recognize EOL characters. Users on Gnucash-users have reported similar problems with other versions of Excel. A simple csv file is attached, along with the screenshot of the resulting GnuCash import window, showing the lack of new lines.

It would seem prudent to have some means of choosing from among the most common EOL settings. This would allow users the flexibility to try a different setting if their results are incoherent.

Comment 1 David 2018-08-29 15:29:17 EDT

Created attachment 372955 [details]
Screen shot of importer

Comment 2 Geert Janssens 2018-09-04 05:29:25 EDT

Thanks. I have committed a fix that will become part of gnucash 3.3.

Note You need to log in before you can comment on or make changes to this bug.