ESM Formatting in SpotlightXL

The External Source Model (ESM) view offers users essential formatting options to enhance the presentation and readability of data. Users can personalize their ESM views with the following features:

• Number Formats: Select from various formats, including currency, percentages, red brackets, and decimal places.
• Text Formatting: Apply styles such as bold, italics, underline, font color, and background color.
• Header Row: Keep the header row visible while scrolling through extensive datasets.

How to Apply Formatting in the ESM View?

Users can format numbers in the ESM view using options for currency, percentages, red brackets, and decimal places. Here’s how to use these formatting options:

1. In SpotlightXL, navigate to Analyze > Design View.
2. Select the desired ESM view.
3. Click the Home tab.
   
   
4. Apply the formatting options as needed.
   
   
5. Return to the SpotlightXL tab.
   
   
   Note:

   Formatting applied to the first cell in a column will automatically apply to all cells within that column.

6. Optionally, click Properties to set the decimal value and freeze the header:
   
   1. Enter the required decimal value in the Decimal field.
      
      Note:

      The defined decimal values will apply to all columns. However, if a specific column has its own decimal formatting, it overrides the general decimal setting.

   2. To freeze the header row, set Freeze Header Row to Yes.
      
7. Click Save As and provide a name for the view.
8. Finally, click Save.