EmEditor Home - EmEditor Help - Dialog Boxes - Customize dialog box
CSV page
The CSV page allows you to customize settings related to the CSV formats.
CSV Formats list box
Displays the list of defined CSV formats. In order to be detected when a file is opened, CSV formats must be checked in the CSV files to Detect list box in the File page of configuration properties. The priority order of the detection is the order specified in this list box.
Add button
Adds an item to the list.
Delete button
Click this button to delete the selected item from the list.
Up button
Move the selected item up on the list.
Down button
Move the selected item down on the list.
Select All button
Select the entire list.
Toolbar button title check box and text box
Specifies the title separately from the CSV format name.
Delimiter text box
Specifies a delimiter to separate the data items. The delimiter can include the following escape sequences. The delimiter is a string up to 39 character long.
\a |
Warning (Bell) |
\b |
Backspace |
\t |
Horizontal tab |
\v |
Vertical tab |
\\ |
Backslash |
\xhhhh |
Unicode character in hexadecimal notation |
Quotation Mark text box
Specifies a quotation mark to quote data items. The quotation mark can include the above escape sequences. The quotation mark must be exactly one character.
Allow delimiters in quotes check box
Specifies whether the delimiters should be allowed in quotes.
Allow newlines in quotes check box
Specifies whether newline characters should be allowed in quotes.
Use Escape Character check box
Specifies whether delimiters and backslashes should be escaped by a backslash. This option allows a nonstandard CSV format, which does not allow delimiters in quotes.
Lines of headings text box
Specifies the number of lines that are headings in a CSV document.
Max lines to detect text box
The number specifies the maximum number of lines to detect as a CSV document. When a file is opened, EmEditor counts the number of delimiters in the number of lines specified here, and if all lines have the equal number of delimiters, the file is detected as the CSV document. Regardless of this option, the CSV document must be at least two lines. Moreover, CSV formats must be checked in the CSV files to Detect list box in the File page of configuration properties.
Min delimiters to detect text box
The number specifies the minimum number of delimiters to detect as a CSV document. For example, if one line contains only 3 delimiters in a CSV document, if the number in this text box is 3, this file would be detected as the CSV file. However, if the number in this text box is 4, the file would not be detected as the CSV file. Moreover, CSV formats must be checked in the CSV files to Detect list box in the File page of configuration properties.
First line to detect text box
The number specifies the line number of the first line to detect as a CSV document. For example, if the first 3 lines of a document do not contain delimiters, and if the number in this text box is 3, EmEditor would ignore the first 3 lines and dectect the rest of the document as the CSV file.
Max newlines in a cell text box
Specifies the maximum number of newlines that can be embedded in a cell. This option is only available if the Allow newlines in quotes option is set.
Validate CSV and Output Errors check box
If this is checked, when the CSV mode is switched, EmEditor checks the validity of CSV, and displays issues and information in the Output bar when it detects errors or special status. If Allow newlines in quotes check box is checked, and if embedded newlines are detected, it will displays the information even if there are no issues.
Drag separators only in headings and the ruler with the mouse check box
Specifies whether separators can be dragged with the mouse only in headings and the ruler. If this is not checked, separators can be dragged everywhere in the document.
Read only in headings check box
Specifies whether headings should be read only.
Adjust Separator Positions Automatically check box
If this is checked, separator positions will be adjusted automatically when the document mode is switch to a CSV mode and other major edits have occurred.
Adjust Separator Positions in Visual Lines Only check box
If this is checked, separator positions can be adjusted only in the visible lines of the CSV document. If this is not checked, separator positions are adjusted from the first up to 1,000 lines.
Double-click to Select a Cell check box
If this is checked, double-clicking on a cell will allow you to edit the selected cell.
Switch to Cell Selection Mode Automatically check box
If this is checked, the Cell Selection Mode will be selected after a CSV document is opened.
Show Balloon Tip on Cell Selection Button check box
If this is checked, a ballon tip will be displayed on Cell Selection button when the document mode is switch to a CSV mode.
Automatically Show/Hide Cell Toolbar check box
If this is checked, the Cell toolbar appears when a CSV document is active and the cell selection mode is selected.
Automatically Set Focus check box
If this is checked, EmEditor automatically sets focus to the cell toolbar.
Automatically Adjust Height check box
If this is checked, EmEditor automatically adjusts the height of the cell toolbar.
Show Column Header check box
If this is checked, EmEditor automatically displays the column header when a CSV document is opened.
Use Alphabetical Characters for Column Header check box
Uses alphabetical characters for the column header.
Use Zero-Based Characters for Column Header check box
Uses zero-based numerical characters for the column header.
Enable AutoFill in Cell Selection Mode check box
If this is checked, AutoFill handle will be displayed at the bottom right corner of the selected cell border under the CSV selection mode. You can drag the handle to continue a series or pattern into neighboring cells. Double-clicking the AutoFill handle while the selected cell is at the top of the CSV document, the above behavior can be applied to the entire column of the document.
Enable Drag and Drop to Move or Copy Cells in Cell Selection Mode check box
If this is checked, you can drag a border of the selected cell(s) to move or copy the selection. While the whole column(s) or line(s) are selected, dropping with the SHIFT key reorders the column(s) or line(s).
Keep Number of Columns Same while Editing in Cell Selection Mode check box
If this is checked, EmEditor keep the number of columns same while editing in the cell selection mode.
Press TAB key to Create a New Cell in Cell Selection Mode check box
If this is checked, pressing the TAB key to go to the next cell will cause a new cell created if the current cell is the rightmost cell.
Double-Click Header/Line Numbers to Create a New Column/Line check box
If this is checked, double-clicking the header or line numbers causes EmEditor to create a new column or line.
Double-Click Outside to Create a New Cell check box
If this is checked, double-clicking outside of editable cells will cause EmEditor to create a new cell.
Default Column Width text box
Specifies the default value of column width.
Reset button
Resets to default settings.
Copyright © 2003-2020 by Emurasoft, Inc.
