Setting must be greater than 0 to freeze any header rows (by default it's 1). If you want the header row (or rows) to always be visible when you scroll down a file, this setting allows that to happen. That setting is 0 by default, so you must change it either by calling the Set Number of Header Columns or Set Header Columns to Selected Column commands or right-clicking on a row and selecting the Set Header Columns to Selected Column option. Setting must be greater than 0 to freeze any header rows. If you have records with a lot of columns and you want the first few to always be visible, you can freeze them with this setting. That will give you a list of choices and it will automatically write your choice to the Settings file. To change this, it's best to use the Set Font command. You can set this to a negative value so the first record starts at 1. Some CSV files have several rows of meta-data before the records start. If you're on row 25, you know that's the 25th row of data. Because most CSV files have a single row for the header, when this setting is 0 (the default), the first record of data starts at row 1. This determines where the row labels start counting.
This determines where the column labels start counting. You can change the height by manually dragging the row label to a new height or by using the Set Selected Row heights command. If disabled, the rows will stay at this height regardless of any editing until you manually change the height. If Auto-Fit Row Height is enabled, a row's height will change to accomodate the new data. This is the height of empty rows in pixels. You can change the width by manually dragging the column label to a new width or by using the Set Selected Column Widths command. If disabled, the columns will stay at this width regardless of any editing until you manually change the width. If Auto-Fit Column Width is enabled, a column's width will change to accomodate the new data. This is the width of empty columns in pixels. Refresh: It'll simply reload the file to show the changes.Īsk: It'll ask you whether you want it to reload the file or ignore the changes. If you have a file open in Modern CSV and another program or process saves it, this setting determines how the program reacts to that save. more than a few thousand).Ĭommand: Set Behavior When File Is Changed Externally Without that limitation, a single rogue cell with dozens of newlines could cause the entire row to take up several screens worth of width and necessitate excessive scrolling.įor performance reasons, this setting is not recommended for files with many rows (i.e. If that setting is 240 (which is the default value), then no row can be taller than 240 pixels. However, it is limited by the Maximum Row Height for Auto-Fit setting. When enabled, this seting will ensure that each row is only as tall as the tallest cell and no taller. Without that limitation, a single rogue cell with 5,000 characters could cause the entire column to take up several screens worth of width and necessitate excessive scrolling.įor performance reasons, this setting is not recommended for files with many columns (i.e. If that setting is 800 (which is the default value), then no column can be wider than 800 pixels. However, it is limited by the Maximum Column Width for Auto-Fit setting. When enabled, this seting will ensure that each column is only as wide as the widest cell and no wider. You can either set the delimiter to (auto) or delete the row from the file. If it's not auto-detecting delimiters when you expect it to, check that file first and make sure that extension isn't set to a specific delimiter. Keep in mind this setting is overridden by the File Extension Options file. When enabled, the program will auto-detect the delimiter of new files opened in the program. Retain Sort and Filters Upon File Refresh Minimum File Size to Ask About Opening in Read-Only Mode (MB)Ģ5. Let Editor Pane Consume Navigation Keystrokesġ7. Behavior When File Is Changed Externallyġ4.
0 kommentar(er)
