Governed Dashboards
  • About Dashboard Designer
    • What is Dashboard Designer?
    • Why is it used?
  • Getting Started
    • Accessing the Designer Module
    • Overview of Designer Module
      • Homepage
        • Guided Tour
        • Left Menu Panel
          • New
          • Manage
          • Open Dashboard
          • Preferences
          • Save As
          • Help
          • Exit
      • Dashboard Canvas Page
        • Right side Panel
          • Connection Page
          • Chart Container
          • Manage Window
          • Script Window
          • Guided Tour
        • Canvas Properties
        • Context Menu Properties
  • Create New Workspace
    • Workspace Creation: Complete Flow
    • Creating a Workspace
    • Renaming a Workspace
    • Deleting a Workspace
  • Create New Dashboard
    • Dashboard Creation: Complete Flow
    • Adding a New Dashboard
    • Create Connection
    • Drag and Drop Charts
    • Associate the Dataset
    • Preview the Dashboard
    • Save the Dashboard
    • User Alert Notification
  • Managing Options for a Dashboard
    • Open Dashboard in Designer
    • Publish a Dashboard
    • Share a Dashboard
    • Dashboard Version Control
    • Action Menu
      • Preview Dashboard
      • Export to Local Disk
      • Rename
      • Delete
      • Moving a Dashboard
      • Information Icon
      • Dashboard as Template
  • Connecting to a Data Source
    • Accessing the Data Connectors
    • Establishing a Data Connection
      • CSV Connection
      • Excel Connection
      • Data Service Connection
      • Data Science Service
      • Data Store Connection
      • Data Sheet
        • Data Sheet Enhancements
      • WebSocket Connection
      • Merged Connection
  • Charts Gallery
    • Charts
      • Area chart
      • Bar Chart
      • Bubble Chart
      • Circumplex Chart
      • Column Chart
      • Funnel Chart
      • Histogram Chart
      • Inverted Funnel
      • KPI Tile
      • Line Chart
      • Map Chart
      • Mito Plot
      • Mixed Chart
      • Pie Chart
      • Project Timeline
      • Pyramid Chart
      • Spark Line
      • Scatter Plot
      • Spider Chart
      • Waterfall Chart
    • Grids
      • Data Grid
      • Paging Grid
      • Data Sheet
      • Scorecard
      • Pivot Grid
    • Filters
      • Checkbox
      • Combobox
      • Hierarchical Combobox
      • List
      • Radio Button
    • Advanced Charts
      • Box Plot
      • Candle Stick
      • Chevron
      • Data Search
      • Decision Tree
      • Group Bar
      • Group Column
      • Heat Map
      • Text Analyzer
      • Time Series
      • Decomposition
      • Tree Map
      • Trellis
      • Word Cloud
    • Other Charts
      • Box
      • Bullet
      • Date Picker
      • Export
      • Filter Chips
      • Filter Saver
      • Gauge
      • Graphics
      • Guided Tour
      • H-Slider
      • Image
      • Info Button
      • Label
      • Legend
      • Progress Pie
      • Semi Gauge
      • Stepper
      • SVG Image
      • Text Box
      • Trend
      • URL Button
      • V-Slider
      • Tab Component
      • Inputbox component
      • Button component
    • Custom Charts
    • Common Chart Properties
      • Background
      • Title & Sub-title
      • X & Y Axis Properties
      • Legend Properties
      • Formatter
      • Axis Setup
      • Export Options
  • Dashboard Objects
    • Manage Dashboard Components
    • Dashboard Objects Properties
  • Configurations
    • Filtering the Data
    • Drill Through
    • Dataset Properties
    • Indicators in Charts
    • Tooltip(Default & Custom)
    • Data Label
    • Geo Mapping
    • Language Mapping
    • Legend Mapping
    • Alerts in Grids
  • Script Help Section
    • Navigate to Script Help page
    • How to use Scripts?
Powered by GitBook
On this page
  • Add Row
  • Ability to Freeze Columns
  • Edit the Frozen Column
  • Pagination Property
  • Delete Row
  • Save Option Update
  1. Connecting to a Data Source
  2. Establishing a Data Connection
  3. Data Sheet

Data Sheet Enhancements

This page lists all the enhancements that are released for the Data Sheet.

PreviousData SheetNextWebSocket Connection

Last updated 2 years ago

Please check out the given walk-through to understand the enhancements for Data Sheet.

Data Sheet Enhancements

The following enhancements are provided for Data Sheet as a Data source connection:

Add Row

Ability to Freeze Columns

Edit the Frozen Column

  • Navigate to the Dataset Properties and select a column.

  • Enable the Frozen Column option from the Properties tab of the Dataset.

  • The selected column gets frozen and becomes non-editable in the Preview mode.

  • Add a new row using the Add new Row option, the cell added under the frozen column is editable.

Pagination Property

Delete Row

Save Option Update

Please Note: Other than the above listed enhancements the below given enhancements are also provided to the Data Sheet data source.

  • Updated the JExcel DataGrid and JSuites library with the latest stable version (4.6.1).

  • Able to retrieve more records of data.

Provided the Add Row (+) option to add a new row in the Data Sheet.

The Freeze Column option can be enabled from the Properties tab provided for the Dataset.​​

​​

Provided pagination within the General Properties option. By enabling the Pagination option from the General properties, the page number gets displayed on the Data Sheet component.

Introduced the Delete Selected Row option with a confirmation message before a row gets deleted in the Preview mode.

The Save option gets updated in red color when something is edited in the datasheet.​​