# Column Formatting

In ViewZen Analytics, **column formatting** refers to the ability to customize the appearance and structure of header, data and footer displayed in columns within a grid or table.

In **ViewZen Analytics**, the following column formatting options are available

### Text

These settings only apply to text fields. Following properties can be set

* **Wrap** - If enabled, long text strings can be wrapped within a given space to avoid overflow or truncation.
* **Length** -This prooperty can be used to set a maximum character limit for the text.
* **Word Break** - If enabled, this option allows long words to be broken and continued on the next line. 

### Text Align

**Text alignment** refers to the positioning of the text within a column or cell in a grid or table. Text can be aligned in various ways depending on the type of data. The following alignment options are supported

* **Left Alignment**: Text is aligned to the left side of the column or cell. This is commonly used for text-based data, such as names, descriptions, or labels.
* **Center Alignment**: Text is centered within the column or cell. Center alignment is often used for headers, titles, or numeric data that should appear equally balanced.
* **Right Alignment**: Text is aligned to the right side of the column or cell. This alignment is typically used for numeric data, such as monetary values, percentages, or quantities, ensuring that the numbers align neatly for easier comparison.

### Label Settings

* The **font type, size, text color and background color** of the header, footer text or the value.
* Text formatting options like **bold, italics, and underline** can be applied to the of the header, footer text or the value.

### Formatting

**Numeric Data**

Various formats can be applied to the header, footer text and the values.

* **Display Formats**
  * **Number** - Number fields can be displayed in one of the following formats
    * Crores
    * Lakhs
    * Thousands
    * Billion
    * Million
    * Indian NS (with Suffix)
    * Western NS (with Suffix)
    * Indian NS (with separator)
    * Western NS (with separator)
    * **Percentage**
    * **Currency** - The currency of the selected country. 
    * **Finance**
    * **Accounting** - The accounting year of the selected country.
    * **Decimals** - Decimals settings allow users to control the number of decimal places displayed in numerical values. E.g., 0 for whole numbers, 2 for 2 digits after decimal.
    * **Prefix** - The **Prefix** setting allows users to add a predefined text or symbol before numerical values in axis labels.
    * **Suffix** - The **Suffix** setting allows users to add a predefined text or symbol after numerical values in axis labels.

**Time based Data**

One of the pre-configured formats can be selected or a custom data format can be determined.

**Text Data**

These formatting options don't apply to text data.

### Column Width

Can be used to set a fixed width for the column in pixels. By default, all columns will have an equal width.

### Apply To

Apply To provides the option to apply the setting to either the Header Text or the Footer Text or the Value.

<figure><img src="https://2529980633-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FK8cCKBpIeUsWEwOw3Fbj%2Fuploads%2FZbKl6kx8iM20G5mQnbGH%2Fcolumnformatting.jpg?alt=media&#x26;token=3392747c-48f7-4c3c-a0d3-28ad8358b98e" alt=""><figcaption><p>Column Formatting</p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://viewzenlabsug.gitbook.io/userguides/viewzen-analytics/dashboard/create-a-dashboard/toolbar/place-components/properties/format-properties/column-formatting.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.