1.1.9
14/12/2009
added 'Regional format' to options
added a new warning message for header rows
added 'From Columns' option to Auto Populate
added 'From Element' option to Auto Populate
changed Auto Populate layout to be more accommodating
1.1.8
26/11/2009
added 'Append' to add multiple files together
added 'Data Quality' setting to Random Data Generator
added 'Force unique column names' setting to the open dialog
added 'Populated count' to data analysis report as well as percentage
added 'Cell editor' to edit and context menu
changed auto update to show better error messages
changed auto update to force admin elevation if needed
fixed saving not persisting line break chosen
fixed force qualifiers on newly created columns
1.1.7
18/9/2009
added 'Ignore NULL characters' to loading options
changed Text Mining to accept more number formats for Aggregated Count
changed Assign CSV to ignore Spaces and Tabs
fixed saving to properly escape embedded qualifiers
fixed AutoUpdate showing blank message box
fixed 'Text Mining' error message not showing column name
fixed Skip and Limit Rows getting stuck after a file change
fixed 'New File' failing if previous file opened with Skip Rows set
1.1.6
4/9/2009
added 'IsEmpty' and 'IsNotEmpty' to Filter
added 'Split Cells' to editing
added 'None' rule to Filter
added 'Auto Update' facility
changed 'Cell Shifting' functionality
changed 'Skip Rows' and 'Row Limit' to not persist after file change
changed Message Box layout for small messages
fixed Delete key removing row when editing a cell
fixed Export messages to now say Save
1.1.5
29/7/2009
added Adding of rows
added Deleting of rows
added Cloning of rows
added File > New for creating new blank files
added Pressing space edits the current cell
added 'Space' as a delimiter
added Replace Line Breaks to Tidy action
added 'Insert Column' to 'Modify Structure'
changed action dialog grids to auto expand to fit contents
fixed Refresh glitch on main grid after action complete
fixed File not found on old file in open history dropdown
fixed Deduplication statistics showing wrong percentage
fixed Unsaved changes warning not showing after certain actions performed
fixed 'Modify Structure' field already exists error if just changing case
fixed Installation defaulting to correct 64bit program files path
fixed auto detection leaving delimiter blank on 'Open dialog'
fixed current format not changing after a 'Save As' was performed
fixed Down (from top) and Up (from bottom) ignoring 'Current Column' option in 'Find'
1.1.4
26/6/2009
added better keyboard usage in filters
added 'Convert escaped characters' to options
added 'Stem Words' and 'Homophones' to Text Mining
added 'Statistics' to the end of a Deduplication
added 'Force qualifiers around all cells' to Save As
fixed 'Row Limit' and 'Skip Row' settings not being saved for fixed width
fixed Show/Hide details tab setting not being persisted
fixed incorrect warning count after filter applied
1.1.3
5/5/2009
added 'Regular Expressions' to filters
added 'Sum' column to 'Data Analysis' to show total value on numeric columns
added 'Text Mining' action
added 'Row limit' to settings for re-use
added 'Skip rows' to settings for re-use
added sorting on the warning column
added 'Line break' option to Open file
added 'Revert History' to edit menu
changed 'Warnings' to be persisted between actions
changed 'Regular Expressions' to be tested for validity before usage
fixed 'Save As' not using the open files path as the default destination
fixed 'Regular Expressions' on find being incorrectly forced to upper case
fixed CSV Easy not appearing in Alt-Tab when dialogs are open
fixed exception occurring when file loaded with errors
1.1.2
26/3/2009
added 'Deduplication' action
added 'Write split remainder to additional file' option
fixed User edits causing 'Filter' to incorrectly suppress certain rows
fixed 'Current Column' being ignored for 'Replace All' and 'Count' in Find & Replace
fixed warning message referring to the wrong column
fixed 'Auto Update' failing if behind a web proxy
1.1.1
3/3/2009
fixed 'Find' failing to function if a row contained warnings
fixed 'Randon Data Generator' giving an error if used immediately after loading CSV Easy
fixed 'History' failing to revert when file contained rows with multiple warnings
1.1
27/2/2009
added 'History' function to go back to previous states of change in the working file
added Apostrophe character to available qualifiers
added 'Ignore commented rows' to options
added loading & saving of filters
added Check for out of memory when performing analysis
added loading and saving of internal binary format
added 'Skip analysis of first row' to Data Analysis
changed 'Find & Replace' with a brand new, faster engine
fixed Warning count showing after a sort
fixed 'Sort' incorrectly applying user edits
1.0.7
31/12/2008
added many more delimiters
added 'Splitting' to 'Save As' to break up data into multiple files
added 'Extra columns' to 'Random Data Generator'
added storing of 'Random Data Generator' settings
added 'Internal Browser' option for use with reports
changed the maximum number of records 'Random Data Generator' can create to 10,000,000
fixed 'Random Data Generator' randomly freezing when the record type was US
fixed 'Save As' not showing new format in toolbar correctly
fixed 'Save As' changing the current file when it was to XML format
fixed crash when saving after a load with skip rows in use
1.0.6
12/12/2008
added return key now start a Find
added storing of the last find criteria
added 'Skip x rows' to open dialog
changed 'Save As' to make the saved filename the current working file
fixed crash when performing a find and then resizing/moving the main window
fixed crash when trying to save a single column data set with user edits applied
fixed Warning message referring to the wrong number of columns
1.0.5
16/11/2008
fixed minor bug in v1.0.4 causing Save functions to produce an error everytime
1.0.4
14/11/2008
added Row numbers to the grid with an option to toggle them on or off
added 'Undo' to the Edit menu
added 'Greater than' and 'Less than' to filter conditions
added highlighting of current row
added added a pre-check to determine if the temp folder drive has enough space to fit the processing file
added 'Paste Special' to the Edit menu
added Regular Expression searching to 'Find & Replace'
added 'Shift Cells Left' and 'Shift Cells Right' to Edit menu
changed the maximum width of a column when autosizing the grid after load
changed Cut, Copy and Paste to also work on a cell contents when not in edit mode
changed error message to a more meaningful one when the temp folders drive is full
changed Populated percentage on 'Data Analysis' report to show up to two decimal places for better accuracy
fixed bad percentage values on some finds
fixed 'Find & Replace' not working when using 'Whole words only' and the word being found is the last word
fixed having a filter with no value against a condition could cause an error to occur if no data matched any rules
fixed when file with no header has columns renamed the header flag is automatically set to allow saving to write the column names correctly
fixed 'Find & Replace' not setting the contents of the lower tabs correctly after the current cell has changed
fixed long distinct values on 'Data Analysis' report, these are now truncated
fixed 'Min Width' incorrectly showing zero instead of the minimum width on the 'Data Analysis' report
1.0.3
29/9/2008
added multi-column sorting function
added 'Trim white space around column names' option to open dialog
added 'Filter' to the right click context menu on the main grid
added 'Random Data Generator' action
added 'Row limiter' to open dialog, allowing you to specify how many rows to load from the source file
added 'Substitute blank column names' to options. If a blank column is found, it is substituted with a derived one in the form of __blank_col_x where x is a number starting from 1
added 'Online Help' menu
changed the amount of memory used when loading a file. This is now dramatically lower, especially on large files
fixed bad content resizing on filter window
fixed 'Replace all' on current column not working
fixed blank rows at the start of a file causing file to load incorrectly when 'Ignore Blank Rows' was set in the options
fixed 'Data Analysis' incorrectly identifying some numerical values as dates
fixed closing a file would leave the title bar and warning count of the previous file
1.0
15/8/2008
added Saving in a Fixed Width format
added storing the layout of a fixed width file when you do a full scan
added a maximise button to the open file dialog
changed Contents field on inspector tab to fill the available space on the tab
fixed opening a blank file into the fixed width dialog could cause a crash
0.1.4
13/8/2008
added 'Filter' action to allow you to query the data and create a specific dataset such as only the rows in London etc...
added 'Viewing Browser' option to specify which browser to view reports with
added support for loading fixed width files
fixed error when saving, if warnings have been removed from any rows
fixed How to edit message does not show after a Data Analysis run now
0.1.3
30/7/2008
added opening of files by dragging and dropping them on to the main window
added a message to explain editing after a load
added 'Check for updates automatically' in the options for users not permanently connected to the internet
added 'Assign CSV format automatically' to pre-scan the file you choose to try and determine its format
added remaining warning count to the status bar
added 'Warn about short rows' option. Disabling this will stop warnings showing for rows with a short number of columns. The row will be padded to fit automatically
added 'Save' to allow quick replacement of the source file in the same format
changed 'Export' to 'Save As' to make more windows standard
fixed when a file has opened the grid now gets the focus, enabling you to navigate with the keyboard without having to click the grid first
fixed bad height on lower tabs after resizing main window
fixed warning icon not disappearing when first row had warnings removed
0.1.2
4/7/2008
added 'All Files' option to open dialog
added +$./\ as possible delimiters
added 'Current Column' option to find and replace
added 'Ignore blank rows' to options
changed incorrect column count on rows from errors to warnings, enabling fixing of the issue within the application
fixed 'Whole Words' replace option
0.1.1
23/6/2008
initial public beta release
