We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to change the cell value in OlapGrid?

You can change the cell value in the OlapGrid in two ways.

  1. By using the QueryCellInfo event of the OlapGrid control.
  2. By editing the DOM element.

 

Using the QueryCellInfo event:

The QueryCellInfo event gives two parameters, CellDescriptor and Cell. The CellDescriptor parameter helps you to select the position of the cell and the Cell parameter helps you to change the cell value. By using the Text property in the Cell parameter, you can change the cell content.

Note: This event is invoked every time a new cell is created.

 

The following code example illustrates how to set or change the cell value of the OlapGrid by using the QueryCellInfo event.

 

C#

 

VB

 

Editing the DOM element:

Another method of changing the cell value is to edit the DOM element under the PreRender event. By using the FindControl() method, the OlapGrid can be tracked in the table pattern. The particular cell position in the table can be detected by iterating the rows and columns of the table. The path of the header cells in the table is different from other cell types because of the expanders in the header cells.

The following code example illustrates how to set or change the cell value of the OlapGrid by using the QueryCellInfo event.

 

C#

 

VB

 

Article ID: Published Date: Last Revised Date: Platform: Control:
5419 09/16/2015 09/16/2015 ASP.NET Web Forms (Classic) OlapGrid
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.