Easy CSV Editor1.59

Bug fixing

• Fixes a corner case where a CSV file wouldn't be loaded with the right settings after that file was edited in an external app and reverted in Easy CSV Editor. Introduced in Version 1.58 Date Recognition
• Starting from this version, Easy CSV Editor detects the dates used in the CSV file.
• The detected date formats can be visualised and changed from "Document Properties" sidebar ("View" -> "Show Document Properties" menu item).
• New documents that you create will have the default date formats set to a combination of short date and short and medium time, as set on your system.
• There are new filter rules to accommodate the dates: "Date is", "Date is before", "Date is after", "Date is between".
• Sort is improved to properly handle the date comparison.
• "Min Date" and "Max Date" are now available as additional calculations in the bottom status bar. Other Improvements
• "Clear Filters" now just unhides all hidden rows, without actually removing the filters from the list. Bug fixing
• Fixes a crash which happened when opening two or more files at once and quickly pressing "Done" in the "Input Preferences" sheet. (Thanks Laurent for reporting and helping me to reproduce this issue!)
• Fixes an issue where the "Input Preferences" sheet would unexpectedly appear when having a CSV file opened in Easy CSV Editor but edited in another app. Introduced in Version 1.57 Improvements
• Greatly improves the loading time of very large documents. In some cases the files will be loaded 50% faster than before.
• Improves the filtering of very large documents. Especially visible when they have more than 500000 rows. Bug fixing
• Fixes a performance issue when dealing with extremely large fields (i.e. more than 100000 characters each field). Introduced in Version 1.56 Improvements
• You can now change the column set for a filter rule, after creating this rule. Bug fixing
• "Copy As" -> "CSV Using Current Properties" now works as it's supposed to, taking into account the properties which are currently set for the CSV.
• Fixes a performance issue when selecting "Sort" or "Filter" sidebar and the CSV has many tens of thousands of columns (i.e. 50000 columns). Introduced in Version 1.55 Bug fixing
• Fixes a crash introduced in the previous update. Introduced in Version 1.54 Improvements
• Detection of links and URLs can be switched off from "Preferences" -> "View" -> "Detect: Links and URLs".
• Improves the detection of patterns from cells when performing autofill, so the leading zeroes, which might exist in the cells (i.e. "0001", "0002") are now properly respected when generating new values (i.e. for the aforementioned sequence, the improved version will generate "0003", "0004"). Introduced in Version 1.53 Improvements
• "Text Transformations" -> "Enclose In" -> "Custom..." now allows you to specify either the begin text or the end text, thus enabling you to prefix the content of your cells or to append to it.
• The font of the big text box above the status bar can be configured from "Preferences" -> "View" -> "Text box font".
• Adds "Sort Selected Cells" as an option available in the "Sort" sidebar (in the "Choose what to sort" pop-up). As its name implies, it allows you to sort only the selected cells, as opposed to entire rows, as previously was the only option available. Bug fixing
• Fixes an issue where no row is shown after choosing "Clear Filters" and there is no filter rule in the "Filter" sidebar.
• Fixes an issue where "Find" -> "Find Next" and "Find" -> "Find Previous" weren't working as expected, unless you displayed the "Find" bar first.