dracan / csvmatrix

CSV Editor for Windows

Dan Clarke

• Independent .NET developer/consultant
• Podcast Host: The Unhandled Exception Podcast
• YouTube: https://www.youtube.com/@danclarkeuk
• Newsletter: https://danclarke.beehiiv.com/subscribe?utm_source=GitHubProfile&utm_medium=website
• Microsoft MVP (developer technologies)
• Owner of Everstack
• Founder and organiser of the .NET Oxford and Azure Oxford user groups
• @dracan on Twitter
• @danclarkeuk on Threads
• mstdn.social/@danclarke on Mastodon

csvmatrix's Issues

Leading and trailing spaces in a line should be removed

Progressbar when busy

Add a progress bar for any operation that takes a while. Currently it looks like the app has hung. Depending on the operation, we might not be able to show the percentage, but at least we should have some form of animation indicating that something is happening.

Titlebar should display current filename

Change current delimiter

Column reordering

Insert new column

Currently the only way to insert a new column is to change the number of columns via the properties form. Need to be able to insert a new column at a certain position. Probably via a right-click context menu on the DGV columns' header.

Remember previous window size and position

Export to HTML

Search / replace functionality

Should include regular expression search

Support different delimiters

Investigate performance with large datasets

Look into virtual mode for the datagridview:

http://msdn.microsoft.com/en-us/library/2b177d6d.aspx

Array/List vs DataTable

Investigate the performance / memory benefits to using an array/list instead of a DataTable as the main storage.

Statusbar showing various stats

Intelligently calculate what delimiter to use when opening a CSV file

When loading a CSV, it needs to try to work out what delimiter to use, and select the correct radiobutton in the properties form.

Column addition / deletion

Import from SQL database tables

Various filtering and sorting functionality

Saving needs to add quotes when necessary

Currently when saving the CSV, it never writes quotes (so can produce invalid CSVs if a cell's content contains the delimiter or new lines.

Check for updates

Add a new menu option: "Help .. Check for updates".

New CSV File

Add new CSV file functionality.

Recent files

Add "Recent Files" submenu in the files menu.

Export to XML

Improved cell content editing for cells with large content

Sometimes there might be lots of data in a single cell. This needs to be made easier to edit. Perhaps double clicking on a cell will display a form with a large textbox allowing the user better editing of that cell's content.

User guide

This should just be a link in the help menu linking to the Github project's wiki page, where I'll create a user guide.

About box

This should contain a link to the project's Github URL.

Export subset of CSV

CSV header row needs to be optional

Currently the header row in is presumed to exist when loading a CSV. As this header row is optional, then we need to handle this. Not sure of the best way of detecting this. We might need a dialogbox with various options when loading the CSV.

Enable drag and drop file to open

Dragging a CSV file into the app should open it.

Aggregate information of selected cells in statusbar

For example: sum, average, etc. Obviously this is only if all the selected cells are numerical.

Handle line breaks in quoted fields

Multiple document tabs

Currently only a single document at a time is supported. Long term, this should have a multi-document interface.

Selected row/column indices/ranges in statusbar

Backup existing file before saving

Currently if an exception is thrown whilst saving a file, the file is left corrupt. If the user is overwriting an existing file, then this will cause data loss. Need to backup the existing file before overwriting it.

Version numbers

Decide on version numbering and add to both the about box and also the assembly info.

Editing header row values

Currently the header rows are the headers in the datagridview and are not editable. Need someway for the use to edit the text here.

Goto cell (ctrl-g)

Ctrl-G should open a dialog asking user to enter row and column number to goto.

Column width mode

Add new "View" menu. This should have a submenu called "Column Width" with the following options:

"None" - default
"Fill" - fill width of DGV
"Auto using header" - autofit based on header
"Auto using content" - autofit based on content

Custom delimiter textbox on being populated

If the CSV has a custom delimiter, the custom textbox in the properties form isn't populated when it's loaded.

Exception when loading an empty file

Auto update functionality

Icon required

Need a decent application icon

Load CSV via command line arguments

Need to be able to pass in a CSV to load via command line arguments. Also test when double clicking on a CSV file to load it with CsvMatrix.

Bulk export to SQL Server database

Exception when deleting a row, then saving

Transpose functionality

Remove duplicate rows

Ability to change date formats

Improve handling of invalid csv files

Currently an exception is thrown on invalid data. This needs to be more user friendly, and display line number of the invalid data.

Settings dialog

Exception when opening a file locked by another process