CSV Editor Pro 28.0

Paste Column/Paste New File: the Sort Method of each column will be auto-detected by examining the contents of the first 100 rows.
Graph/Histogram/Pie Chart: the numeric formats of the CSV data is now expected to match the system's "Region and Language" settings. For example, a Greek number is formatted like "12.345,67".
Graph: the system's "Region and Language" settings are now used to interpret the date format. This allows the system to interpret non-English dates better than how it was done previously, such as "Diciembre 20, 2023" for a Spanish user. If the date cannot be interpreted, it will fallback to the old method, so this should not cause any problems.
Histogram: added the ability to change the background color.
Preferences: added an option to control what portion of the filepath is displayed on the Welcome Panel's Recent Files list. Previously, only the filename was displayed.
Preferences: added an option to alphabetize the Welcome Panel's Recent Files list. Previously, the list was always in order of recency.
Preferences: the "Full Path On Caption" option has changed from a checkbox to a combobox named "File On Caption" with a third option to show the filename without the extension.
Histogram: past entries in the Bottom Label field are now remembered in a drop-down list.
Pie Chart: the "Add Slice" tool now remembers past color settings. Previously only the original set of slices would remember their colors.
Because CSV Editor Pro is now a 64-bit app, the memory limit for the Undo tool has increased from 10 MB to 100 MB.
Set Entire Column: this tool now remembers all settings.
Preferences: added the "Enter Moves Down" option. Previously this was only located on the Options menu.
Export To JSON: added the ability to select which columns will be exported.
Command Line: if the file doesn't exist, and doesn't have an extension, and there is only one file with that name, it is assumed the user is referring to that file.
Preferences: moved the "Reopen Files From Last Session" option to a new tab named "Welcome".
Pie Chart: moved the Digits field to the second window where changes can be observed instantly.
Histogram: the "Title" and "Bottom Label" fields are now controlled by a checkbox.
File Properties: when pasting a password, if the length of the password is over the limit, an error will now appear. Previously the password would be truncated and the user would have no idea why it wasn't working.
Graph: when opening the example csv file for the first time, the column names will be automatically populated.
Redesigned the "Blues" skin.
The Multiline editor and Warnings no longer have a 3D border.
Fixed: the Column Sort Method and Alignment toolbar icons were affecting the last column heading that was right clicked on rather than the column with focus.
Fixed: right clicking on a column heading and changing the Alignment was only working if a cell in the column had input focus.
Fixed: selecting text in a cell with mouse, then right clicking without releasing the left mouse button, would prevent switching to other tabs until giving focus to another cell.
Fixed: Histogram: if the "Maximum Value" was creating one or more empty datapoints, the rightmost value was incorrect.
Fixed: Graph: when "X-Axis Input" is set to "Text", the value on the graph is now the total of all rows that have the same text, rather than ignoring all but the first one.
Fixed: Graph: there could be a hang if the date range was extreme, or if dates are not interpreted correctly.
Fixed: Graph: a row could be omitted from the graph if it contained a date with an invalid time.

Added the ability to encrypt and password protect a CSV file. Open the file, launch the File Properties tool, check the "Password" box, enter a password, and then save the file.
Export To HTML: added the ability to select which columns will be exported.
Pie Chart: on the second dialog, a "Value" and "Final Label" columns have been added. The Final Label column is calculated from the contents of the Label and Value columns, which are editable. This makes it easy to customize the pie chart.
Pie Chart: added the ability to add a new slice that was not in the source data.
Graph: added the ability to control the number of digits after the decimal point on the left Y-axis.
Graph: Units Position: added a third option to hide the units.
Histogram: added the ability to control the number of digits after the decimal point on the Y-axis.
Set Entire Column: Perform Math: this now obeys the operating system regional numeric format settings.
Multiline editor: Added the Ctrl+Shift+Del hotkey, which deletes everything until the end of the line.
Multiline editor: Ctrl+Del no longer deletes the newline if the next word extends to the end of the line.
Paste Column: the "Insert After" field is hidden if the file has no columns.
Search Table: if a regex replacement string refers to a nonexistent substring (e.g. $1), this will now display an error.
Quick Text: added the ability to sort the list.
Quick Text: the Rename tool now has a hotkey, F2.
Jump To Row: this now ignores the thousands separator, per the operating system regional numeric format settings.
Spell Check Table: this now reports the total number of words that were added to the dictionary.
Toolbar: added the ability to place a "Column Alignment" icon on the toolbar, although it is hidden by default.
Graph: it is now possible to check the "Bottom Label" box, but leave the text empty, to eliminate the Bottom Label completely.
Histogram: the "Title" field will now remember past inputs in a drop-down list.
Added the ability to delete an item from the File History at the bottom of the File menu.
Graph/Histogram/Pie Chart: clicking the "Copy" button now shows an animation to indicate that something happened.
Removed the "Don't Print" column option since the columns can now be selected on the Print dialog.
Fixed: Paste New File: removed the unnecessary "Insert After" field.
Fixed: Export To HTML: removed the unused "Print Preview" checkbox.
Fixed: when a batch file opens multiple CSV files all at once, more than one instance could open.
Fixed: Set Entire Column: Insert Prefix/Append Suffix: this was broken in 8-bit character mode.
Fixed: menus did not support fixed-pitch fonts.

Fixed: only the first 101 rows were being read from files that have not been saved in the past (since 25.0).

When a file is opened for the first time, the Sort Method of each column will be auto-detected by examining the contents of the first 100 rows.
When a file is closed, minor table preferences are now recorded, including the column widths, column sorting, sort method, and focus cell. Previously these preferences were only recorded if the file was saved. However, please note that this only happens if the file has been saved at least once in the past.
Filter: Conditional mode: added support for parenthesis.
Print: there is now a checklist of the columns that will be printed.
Graph: it is now possible to put text labels on the X-axis. Set X-Axis Input to "Text". Previously only dates or numbers were supported.
Graph: added the ability to place the X-axis units above each data point. Previously they were always below the graph.
Graph: added the ability to control the minimum value of the Y-axis.
Histogram: added the ability to place a text label on the Y-axis.
Histogram: added the ability to control the number of digits after the decimal point for X-axis values. Previously this was always 0.
Histogram: added the "Draw Horizontal Lines" option.
Pie Chart: the slice colors are now remembered.
Pie Chart: the Decimal Digits setting can now be negative, in which case the absolute value is used, except that trailing zeros are trimmed.
Pie Chart: added a "Reset Colors" button to the second window.
Export JSON: added the option of exporting as rows containing each column, rather than columns containing each row.
Table Statistics: for numeric columns, the minimum and maximum values are now reported.
Set Entire Column: Perform Math: added the ability to calculate an exponential.
Spell Check Table: this now reports the total number of cells that were spell checked.
Split Column: the "Keep Separator" field is now remembered.
A file named "Example Histogram.csv" is now installed. It is useful for testing the Histogram tool.
File Properties: if the "No Column Names" box is checked, and all column names are blank, the columns will be named "A", "B", "C", etc.
Toolbar: added the ability to place a "Column Sort Method" icon on the toolbar, although it is hidden by default.
The "Select All Rows" tool now has a hotkey, Ctrl+Shift+A.
Shift Cells Left/Right: the Preview now includes the "#" column.
Help file: added a chapter on the "Cell" menu.
Help file: Search tab: added two buttons that allow you to jump to the next/previous search occurrence.
The buttons on the last window of the Graph tool now match those from the Pie Chart tool.
When restoring the previous session, the "File is completely empty" warning is now suppressed.
Fixed: if a popup window is created while the parent window is minimized, it could appear on the wrong monitor.

The Alternating Rows and Row Dividers submenus now show what the "Default" option is defaulting to.
When the "Multiline Editing" or "Warnings" toolbar icon is highlighted, the text is now drawn in a better color.
Editboxes: added the "Dictate" tool.
Histogram: Color: added a "Load default value" tool to the context menu.
Fixed: serious bug with loading skins.

Added a tool for generating a Histogram from CSV data.
Added support for Print Preview. The Print Preview window also adds some new capabilities, such as Landscape orientation, customizable header and footer, and adjustable margins.
Added the "Import From Database" tool.
Added to the Options menu tools for resetting the toolbar to two themes, one with text labels and one without.
Set Entire Column: added the ability to perform a mathematical operation on each cell.
Paste Column: there is now an option to paste data starting at the row with focus rather than the top.
Graph: added an optional third dataset.
Graph: each CSV file now maintains a separate set of the settings that appear on the Graph configuration window.
Split Column: added an option that controls if the separator is deleted, left in the source column, or left in the new column.
Graph: added the "Y-Axis Range" option. This allows you to force the Y-Axis for dataset 2 to cover the same range as dataset 1.
Set Entire Column: the dialog now allows the user to choose which column will be affected.
Graph: added the "No Labels On Y-Axis" option for dataset 2.
If there is a single row selected, it can now be deselected by clicking on the cell in the "#" column.
Import From CSV: if the "No Column Names" box is checked, the user can now choose the column mapping as normal. Previously the Column Mapping window would not appear and the mapping was assumed to be in the same order.
Pie Chart: on the second window, added the ability to delete a slice.
Added the "Cell Edits Affect All Selected Rows" preference. When this feature was added in 22.0, there was no option to disable it.
Drag and drop text: when the mouse cursor is near the top or bottom edge, the table will now automatically scroll in that direction.
Graph: split the "Data" tab into separate "X-Axis" and "Y-Axis" tabs. Other settings have been rearranged as well.
Graph: the Top/Bottom/Left/Right labels will now be omitted if unchecked rather than using a default. Previously there was no way to have a blank label.
When the mouse moves over the "#" column, if the row is selected, the mouse cursor will change to indicate that the row can be dragged to a new position.
Spell Check Table: this now reports the total number of misspelled words that were ignored.
A file named "Example Graph.csv" is now installed. It is useful for testing the Graph tool.
Reopen Files From Last Session: this now also remembers the focus order of the documents.
Graph: the active tab is now remembered between sessions.
Shift Column/Row: the meaning of the Pivot Column/Row has changed, it is now the last to be unaffected.
The table's horizontal scrollbar's slide button is now a width that is proportional to how much of the table is visible.
Help: the layout is now tighter. Numerous improvements to the Search tab.
The File menu will now use a smaller font if it is not fitting on the screen.
The Pie Chart tool can now appear on the toolbar, although it is hidden by default.
Fixed: Combine Columns: No Column Names + Delete Source Column: the column names were not being auto-generated.
Fixed a bug that was causing an unnecessary usage of memory in many situations.
Fixed: Destructive Paste: the preview was incorrect if the number of pasted rows was equal to the number of rows in the table, or if pasting on the first row.
Fixed: Print would print a blank page if the filename of the CSV file contained unicode.
Fixed: the Interface Editor was messing up the Skin Elements list if any element was changed.
Fixed: the out-of-memory mitigation mechanism was not working (since 22.0).
Fixed: if "Lock File" is checked, and the file lacks write access, it would refuse to open. It will now open without locking.

Added the "Shift Column" tool.  This allows you to move cells in a column up or down by one row.
Added the ability to rearrange tabs by clicking and dragging them.
Added the "Make Sorting Permanent" tool to the Table menu.
Added the "Save All" tool.
Export To HTML: this now allows the user to specify the font, padding, and cell borders.
Pie Chart: if the Label column contains duplicates, they will be combined into one pie slice.
Undo: changes to the column settings on the Column menu or context menu can now be undone.
Undo: changing the Character Set on the File Properties window can now be undone.
Added the "Tab Name Ellipsis" preference.  When a filename is too long to fit on a tab, this determines where it is truncated with an ellipsis.
Paste New File: if the clipboard contains a file rather than CSV data, the file will be opened as if it was chosen in the Open File tool.
Added a "+" button on the tab bar which creates a new file.
Added the "Hide Extension On Tabs" preference.
Welcome: Ctrl+V now supports CSV data in the clipboard.  Previously it only a supported a copied file.
Added the Ctrl+Home/End hotkeys, which will jump to the first/last column in the current row.
Graph: when there are two datasets, and both datasets have "Bar" appearance, then the bars will be side by side.
Added the "Copy Rows: Ignore Hidden Columns" preference.
Graph: a "month/year" date format is now supported.  Also, "year/month" is supported as long as the year is 4 digits.
Detect External Changes: if the CSV file originally had a Byte Order Mark but no longer does, it is now assumed to be 8-bit ASCII, not unicode.
Table Statistics: this window is now a table of stats rather than a text report.
Added support for dropping multiple CSV files on the window caption.
Export Select Columns: if the export file is later opened, the "No Column Names" option is now remembered.
File Properties: there is now a tab named "Info" that shows some information about the CSV file.
Graph: improved the "Bar" graph appearance.
File Properties: Character Set: added a help button that takes you to the corresponding article on Wikipedia.
Copy Rows: this no longer copies the column names if "No Column Names" is checked.
Shuffle Rows: this now preserves the row selections.
Destructive Paste: the preview now obeys the "Fixed Width Font" option.
Shuffle Rows: this now prompts the user for confirmation since the operation cannot be undone.
Customize Toolbar: it is now possible to force a row-break.
Open File: the Progress Window won't appear until it's taken more than one second to open the file.
Drag-Select will now continue to auto-scroll even if the mouse moves up onto the column headings or down onto the horizontal scrollbar.
The toolbar will no longer lose the user's customization when a new version is installed and new icons have been introduced.
Small reduction in per-row memory usage, allowing larger files to be opened.
The toolbar is no longer visible if no files are open.
Restore Backup: this no longer closes the current file first.
Fixed: Move Column: if "No Column Names" is enabled, the column names were not being recalculated.
Fixed: Shift Cells: the error sound was playing if the dialog was canceled.
Fixed: Destructive Paste: the preview was not populating the "#" column.
Fixed: the Ctrl+Up/Down hotkeys were not working in the multiline editor.
Fixed: right clicking on a column heading and changing the Sort Method was not working if no cell had focus.
Fixed: when a new process is tasked with opening a CSV file, but it finds an existing process to open it in instead, the settings that the file was saved with were not being remembered.
Fixed: Drag-Select: if no rows are selected, they were all becoming selected at the beginning of the operation.

* Added a tool that displays the CSV data as a pie chart.
* It is now possible to "drag-select" a range of rows quickly.  Move the mouse cursor to the "#" column of the first row.  Press and hold the left mouse button.  Move the mouse up or down.  You will see rows being selected.  If the mouse is at the top row, the table will automatically scroll up.  Likewise, if the mouse is on the bottom row, the table will automatically scroll down.  Release the left mouse button when you have reached the last row that you wish to select.
* Filter: the Advanced mode now supports subexpressions enclosed in parenthesis.
* The Tabbed Document Interface can now be disabled on the Options menu.
* The "Import From CSV File" tool can now be undone.
* The "Column Settings" tool can now be undone.
* The Row Filter is now remembered for each tab independently.
* Export To HTML: added the ability to copy the HTML document to the clipboard.  Previously, only the raw HTML source code could be copied to the clipboard, as text.
* Print: added the ability to hide the column and row dividing lines.
* Graph: added the ability to control the appearance of the second dataset independent of the first.
* Detect External Changes: this no longer detects changes for all tabs when the main window becomes activated.  Instead, it detects changes only for the current tab, while other tabs will not detect changes until they are selected.
* When using Shift+Click to select a range of rows, if there are no selected rows, this will start from the row with focus.
* Paste New File: if the clipboard contains characters that are not present in the Default Character Set, the new file will default to UTF-8 instead.
* When undoing the Delete Column or Combine Columns tool, the column's Alignment and Sort Method are now recovered.
* Preferences: Character Set: added a "Preview" button that shows what characters are in the character set.
* New File: the File Properties window that automatically appears now has a Cancel button.
* Graph: added the "Diamonds" appearance option.
* Export to HTML: added an "Explore" button, and the size of the file is now reported.
* Welcome: Recent Projects: added a context menu button.
* Copy Column: the "Include Column Names" option is now remembered.
* When opening a file or creating a new one, the splitter above the Warnings/Multiline Editor will remember its position from the last file that was closed.
* There is now a visible divider between the tabs.
* Welcome: Recent Projects: added a "Copy Filepath" tool.
* The "Paste New File" tool now appears on the File menu.  Previously it only appeared on the Welcome Panel.
* The Create Row tool now has a hotkey: Ctrl+Alt+Insert
* Import From CSV File: this now moves focus to the first imported cell.
* The installer now registers CSV Editor Pro on the "Open With" shell menu for .CSV and .TSV files.
* Welcome: if the clipboard contains a CSV file, you can now press Ctrl+V to open the file.
* Print: added a "Help" button.
* Save As: this no longer allows you to save over a file that is open in another tab.
* It is now possible to enter csvedit.exe into the "Run" system dialog (Win+R) without a path.
* Fixed: after opening a file, creating a new file, or closing a file, the Multiline and Warnings toolbar icons were remaining highlighted.
* Fixed: the "Fixed Width Font" option was not taking effect when opening a file.
* Fixed: when undoing the Combine Columns tool, the column's original Don't Print and Don't Export settings were overwriting the next column's settings.
* Fixed: Export To HTML: this was specifying width=100 instead of width=100% for the table.  This also affected the Print tool.

* CSV Editor Pro now uses a Tabbed Document Interface.  It can have multiple files open for editing at the same time.  Each opened file appears as a tab below the toolbar.
* Filter: Advanced mode: added support for the "|" operator.
* The table now supports mouse tilt wheel.
* Graph: Appearance: added the "Curves" mode.
* The table now obeys the operating system's mouse wheel speed.
* Dragging and dropping a file onto the table will now launch the "Import From CSV File" tool.
* Graph: the inner box between the data and the labels is now optional, and is hidden by default.
* Graph: the "Solid" Graph Appearance now has a dark border along the top, and is a lighter color.
* The open/save dialog will now show .TSV files by default without having to switch to "All Files".
* Search Column: if no column is selected, this will now display a window that allows you to choose the column, with an alternate option of searching the entire table instead.
* Spell Check: pressing the Enter key when the Misspelled Word field has focus is now equivalent to clicking the Change button.
* Open Nonstandard File: if the file has a Byte Order Mark, the "Character Set" field is now disabled.  Previously it was enabled but ignored.
* Destructive Paste: added a Help button.
* Graph: the mouse hover balloon has changed from a simple rectangle to a rounded rectangle with a triangular tip.
* Table Statistics: the report now supports unicode characters.
* Help File: added a chapter on Character Sets.
* There is no longer a border around the table.
* Fixed: Trim Column Whitespace: the Column field was not supporting unicode column names.
* Fixed: UTF-7 was available to the Open Nonstandard File tool but did not appear on the File Properties window.
* Fixed: when the column sort method is "Memory", sorting was not tolerating leading whitespace, and the Table Statistics tool was not showing the correct total and average.
* Fixed: the Clipboard Inspector could display all zeros in the hex data for unsupported data types.
* Fixed: unminimizing on a secondary monitor was moving the window to the primary monitor.
* Fixed: error when saving a file to Google Drive.
* Fixed: the "2 columns have the same name" warning was displaying garbage for the column name on 8-bit files.
* Fixed: Deduplicate Rows: this was not accounting for changes made to the current cell being edited.
* Fixed: Help: Print: some hyperlinks were not followed by the page number.
* Fixed: rare crash when right clicking on an editbox.
* Fixed: Table Copy/Move Mode: this could corrupt non-ASCII characters when editing an 8-bit file.
* Fixed: when using both "No Column Names" and "Preserve Comments", the comments at the beginning of the file would be duplicated each time the file is saved.
* Fixed: copy/paste could fail if another window has the clipboard open.  Now it will retry many times over a brief period.
* Fixed: the Character Set setting on the Options menu was not being properly supported by many tools if set to anything other than "System Default".

* Unicode Character Map: added the ability to create a list of favorite characters.
* Open Nonstandard File: when you choose a character set, the file will now be saved in the chosen character set and not UTF-8. You can still change it to UTF-8 on the File Properties window if you like.
* Open Nonstandard File: if a character set is chosen, the next time the file is opened, that choice is remembered. This allows you to later use Open File instead of Open Nonstandard File.
* File Properties: you may now choose a particular Code Page. Previously you could only choose between ASCII and UTF-8.
* Added support for opening files that contain unicode characters in the filepath.
* When a file is opened, CSV Editor Pro will now detect what character or characters are used to terminate lines. When the file is saved, this convention will be honored. On the File Properties window, there is a new option named "Newline" where you can alter this.
* Added the ability to move an entire row with drag and drop (drag on the cell in the "#" column).
* Unicode surrogate pairs are now supported.
* Print: added the ability to specify the font size.
* Added the "Cell" menu. Previously it was necessary to right click on the cell to get access to these tools.
* Added the "Delimit All Cells" option to the File Properties window. If checked, when a file is saved, every cell is surrounded by quotes.
* Added a "Destructive Paste" tool. This overwrites cells with the clipboard data, starting at the cell with focus. This tool does not appear on a menu, its hotkey is Ctrl+Alt+Shift+V. Use with care.
* Improved file opening speed by 25%. Reduced memory usage.
* Added the ability to increase the padding between the rows of the table. Interface Menu > Configuration Editor > Tables > Vertical Row Padding.
* Graph: added the ability to specify the title that appears at the top of the graph.
* Graph: added a "Yearly" division.
* Added the ability to exclude columns from the "Export To HTML" tool.
* While tabbing or arrowing through cells, focus will now wrap to the next row. Previously, focus would stop at the left/right edge of the table.
* Trim Column Whitespace: added the "Reduce Multiple Spaces" option.
* Double clicking on a word to select it will now support non-ASCII letters. Previously this was only supported in UTF-8 files.
* Added the "Jump To Row" tool to the Table menu.
* Find: if the original search was backwards, Find/Next will continue in that direction. Previously, Find/Next always went forwards.
* Spell Check: while the Spell Checker window is visible, the highlighted selection will now flash between light and dark.
* Added the Table menu, and moved some options from the Tools menu there.
* Added the "/sep" command line switch, which allows you to specify the CSV separator.
* Added the "/a" command line switch, which allows you to associate a file type with CSV Editor Pro.
* Added the "Sort On Column" sub-menu to the Table menu.
* Added the "Current Cell" option to the "Spell Check Table" and "Trim Whitespace" windows.
* Rename Column: there is now a warning if the column name already exists. The Enter key is now equivalent to clicking the OK button.
* A file can now be dropped on the window caption, causing the file to be opened.
* Added a "Help" button to the Trim Whitespace window.
* Fixed: Associate File Type: this was not always reporting the existing association, and prompting if it should be changed.
* Fixed: rarely, balloon help was not appearing promptly, or not at all.
* Fixed: the executable was not signed with a SHA256 certificate, which could cause it to not be recognized as signed.
* Fixed: Print/Export To HTML: the characters <>& and newlines were not being encoded.