EMS logo

Products Navigation

Data Export for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Export for SQL Server

On-line Documentation

Notes


Notes are used to keep remarks or comments for a cell. Note's data are stored separately from ones of the cell. They are displayed as a triangle in the cell's upper right corner. Note appears as a hint when you point at the cell containing a note with a mouse.

 

If you need to create a note:

  • set the cell coordinates (Col and Row);
  • enter text of a note for the cell;
  • set the font and fill properties using the corresponding tabs.

 

Format-specific options - MS Excel - Extensions - Notes

 

The Font tab allows you to specify properties of the font that will be used in the output Excel file notes.

 

Use the Font and Size drop-down lists to select the font and size to be applied to the output text.

Use the buttons below to set font color, make text bold, italicized, strikethrough text, set underline effects, specify text horizontal and vertical align.

 

Format-specific options - MS Excel - Extensions - Notes - Font

 

You also can select preferable text Orientation.

 

Use the Fill tab to set the note fill type and color.

 

Format-specific options - MS Excel - Extensions - Notes - Fill

 

Select the fill type first: Solid or Gradient. The direction needs to be specified for gradient fill: horizontal, vertical, diagonal (down, down), from corner or from center.

 

Press the btnExportData_BackgroundColor button on the left to set the background color for the fill pattern.

Press the btnExportData_ForegroundColor button on the right to set the foreground color for the fill pattern.

 

Use Transparency slider to define visibility level of the note.