[sspParticipant]

Thanks! it helped!

[sspParticipant]

Peter,

On “key press” event only we need to avoid the invalid characters(like minus,apostrophe etc), means we need to allow only digits with one decimal point (like 4.5,46.5 etc). No negative values and special characters should be allowed.

[sspParticipant]

Hi Dimitar,

Thank you so much for the reply!
It helped!!

[sspParticipant]

** how will I set the editable property of the jqxgrid’s cell depending on the row’s index??

[sspParticipant]

Hi Peter,

Thanks for the reply,
I could set the the column header’s height using columnsheight property!!

[sspParticipant]

Hi Dimitar,

I am not able to set the cell value to zero on cellbeginevent using the example code you have provided above.

Is it not possible to call setcellvalue inside cellbeginevent event like below?

$("#"+location+"Grid").bind('cellendedit', function (event) {
  var args = event.args;
  			var columnDataField = args.datafield;  			
  			var rowIndex = args.rowindex;			

<strong>$("#"+location+"Grid").jqxGrid('setcellvalue', rowIndex, 'strSurplusOrDeficit', 0);</strong>  			

  			});

Thanks & Regards,
Sandhya

[sspParticipant]

Hi Dimitar,

Sorry I had missed copying rowIndex lines in the above post,
‘setcellvalue’ doesn’t work for me even then,

$("#"+location+"Grid").bind('cellendedit', function (event) {
  var args = event.args;
  			var columnDataField = args.datafield;  			
  			var rowIndex = args.rowindex;			

$("#"+location+"Grid").jqxGrid('setcellvalue', rowIndex, 'strSurplusOrDeficit', 0);  			

  			});

And in the demo default functionality link you have mentioned above, I cant find the updating of the “Quantity per Unit” cell on the same row to 0 on editing “Product Name” cell value??

Thanks & Regards,
Sandhya

[sspParticipant]

I have to pass the title of the tab as arguments or is there a method to retrieve the index of the jqxTab based on the title of the tab?

[sspParticipant]

Hi Dimitar,

Even though I am able to sum up the grouped data using jqwidgets Grouping and Aggregates, I am supposed to display functionality of subtotal which we can see in excelsheet,

I want to do like this
taskA 1 5 3
taskA 4 8 5
sum 5 13 8
taskB 8 1 0
taskB 1 5 8
sum 9 6 8

I am trying to obtain the jqxgrid as in the following example:

Is this work around do able?

Thanks & Regards,

ssp

[sspParticipant]

I am trying to obtain the jqxgrid as in the following example:

http://dev.sencha.com/playpen/gxt/totals/

Please reply whether is it possible using your widgets?

Thanks & Regards,

ssp

[sspParticipant]

Even though I am able to sum up the grouped data using jqwidgets Grouping and Aggregates, I am supposed to display functionality of subtotal which we can see in excelsheet,

I want to do like this
taskA 1 5 3
taskA 4 8 5
sum 5 13 8
taskB 8 1 0
taskB 1 5 8
sum 9 6 8

Is this work around do able?

[sspParticipant]

Hi Peter,

Hope I am clear regarding my requirement on Grouping and Aggregates,
i.e. I will be grouping rows based on column A, whereas the sum of cost values should be done of column B.,
eg. when Hardware is grouped, I should get the sum in column B as 25,000( 20,000 + 5,000)

Hardware | 25,000
Hardware | 20,000
Hardware | 5,000
——————————————————————————–
Software | 5,000
Software | 3,000
Software | 2,000
——————————————————————————–

Is this scenario possible using groupsrenderer function??

Thanks & Regards,

ssp

[sspParticipant]

Hi Peter,

I have a concern regarding the above sample demo on Grouping and Aggregates,
i.e. I will be grouping rows based on column A, whereas the sum of cost values should be done of column B.,

Hardware | 25,000
Hardware | 20,000
Hardware | 5,000
Software | 5,000
Software | 3,000
Software | 2,000

Is this scenario possible using groupsrenderer function??

Thanks & Regards,

ssp

[sspParticipant]

Hi,

In my above post I meant, I have set the height and width of the grid, and autoheight=false,
I have to display only the rows with the data and empty rows should be avoided,
Is it possible to implement this??

Thanks & Regards,
Sandhya S P

[sspParticipant]

Hi Dimitar,

Thanks for the solution, one more clarrification!

I have set the height and width of my N-level nested grid, now if I have few rows of data, the remaining empty rows are displayed like in excel sheet except in the first grid,
I have to display the rows only the data, is it possible to avoid the empty rows??

 $("#jqxFirstgridHistory").jqxGrid('setrowdetails', i, "<div id='jqxSecGrid" + i + "' style='margin: 10px;'></div>", 350, true);
secGrid.jqxGrid(
		{
		   	 width : 1170,
	   		height : '80%', 

Thanks & Regards,
Sandhya S P

[Author]

Posts