[njaParticipant]

Okay, upgraded jQWidgets, no difference.

Upgraded jQuery, no difference.

Thanks again,
NJA

[njaParticipant]

Hi,
Thanks for trying to help, I appreciate it. Struck out though.

There are no errors in the console.

I can’t download the latest version, your site doesn’t recognize my key even though we have maintenance agreement. I sent an email to sales. If they get back to me I will try that.

Tried the updatebounddata method, didn’t help.

Later,
Nancy

[njaParticipant]

Hi there,
Here is the version info.
/*
jQWidgets v8.3.2 (2019-Oct)
Copyright (c) 2011-2019 jQWidgets.
License: https://jqwidgets.com/license/
*/

The grid is being used inside a C# MVC app, I have it in other web applications and it seems to be working fine there.

When the page first loads the is a call back to the app to get the data using a default year.

The data loads and the loading gif displays.

Then on the page there is a drop down and the user picks a different year, clicks the “go” button and a call is sent to the app with the date.

I manually clear the grid and show the loading, but no loading gif shows.

Thanks for your help,
NJA

[njaParticipant]

Hi,
Thanks for the reply. Theme is set earlier in the code, var theme = ‘classic’;

Regardless, I set it manually and tried different themes; it it did not make a difference. No alt rows.

I tried exporting to html and still no alt rows in the excel.

Any other idea?

thanks,
nja

[njaParticipant]

Thank you.

Quick followup question, if I wanted to capture the users input and validate it or adjust it would you suggest the cellvaluechanged or the cellendedit event?

The end-users make too many mistakes because they forget to press 0 first when editing the discount, so I thought I might just check their entry and if it is already in decimal format less than 1 I will let it go, but if it is say 5.0 then I will multiply it and divide it and set it to .50 for them.

thanks,
nja

[njaParticipant]

Hi there,

You have recreated the problem exactly!!!!

Clearly I am not explaining myself well. Turns out the problem happens with the string fields too. It might be easier if I show that. Be sure not to “select” the cell, just highlight it.

click on the last name field and type a letter or a number => the grid instantly responses and the letter shows up in the edit box

but if click on the last name field and type a the period form the keyboard or the decimal on a number pad => the grid does not respond and the period or dot does not show up in the edit box.

So users are having to type “0.55” to put in the discount rather than just typing “.55”

BUT, if you type a period or a decimal into a jqxNumberInput field directly – for example – on the jqxNumberInput demo page it goes right in.
http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxnumberinput/index.htm

I hope that is more clear,
nja

[njaParticipant]

Thanks! That got me started. I did it a little different, but it is working now and I used your work around to get it going.

thanks,
nja

{
	text: 'Notes', datafield: 'Notes', width: 60, hidden: false, cellclassname: cellclass,
	filterable: false, editable: false, groupable: false, draggable: false, resizable: false,
	rendered: function (element) {
		$(element).jqxTooltip({
			position: 'left', opacity: 1, theme: 'darkblue',
			content: "Internal Notes for QCAP Record"
		});
	},
	cellsrenderer: function (row, column, value) {
		if (value) {
			//return "<div style='width: 100%; height: 100%;'><span class='glyphicon glyphicon-list-alt'></span></div>";
			return '<div style="margin-top: 2px; width: 100%; height: 100%; font-size: large; text-align: center; overflow: hidden; text-overflow: ellipsis;" onclick="notesDivClick(' + row + ')"><span class="glyphicon glyphicon-list-alt text-info"></span></div>';
		}
		else {
			return '<div style="margin-top: 2px; width: 100%; height: 100%; font-size: large; text-align: center; overflow: hidden; text-overflow: ellipsis;" onclick="notesDivClick(' + row + ')"><span class="glyphicon glyphicon-unchecked text-muted"></span></div>';
			
		}
	},
},

<script type="text/javascript">
	function notesDivClick(row) {
		// open the popup window when the user clicks a button.
		editrow = row;
		var offset = $("#jqxgrid").offset();
		$("#popupWindow").jqxWindow({ position: { x: parseInt(offset.left) + 600, y: parseInt(offset.top) + 30} });
		// get the clicked row's data and initialize the input fields.
		var dataRecord = $("#jqxgrid").jqxGrid('getrowdata', editrow);
		$("#Notes").val(dataRecord.Notes);

		// show the popup window.
		$("#popupWindow").jqxWindow('open');

		$("#Notes").focus();
	}
</script>

[njaParticipant]

Well, that makes sense. I will give that a try.

Thanks,
nja

[njaParticipant]

Hi,
Thanks. That is good to know, points to something else on the page causing it to act different from the first grid.

I am traveling and will try to get you sample code later in the week.

Thanks,
nja

[njaParticipant]

Hi Peter,
So this is a formal request for this feature.

I will also take a moment to point out that you have received multiple questions about this feature in the grid forum.

Most Respectfully,
nja

[njaParticipant]

I will assume from your silence that you have not plans on supporting multiple column sorting ever.

Thank you again for your assistance,
nja

[njaParticipant]

Thanks I will check it out.

nja

[njaParticipant]

Hi Dimitar,
Circling back to this project, thanks for your reply.

Do you know if there is an example using the tooltip widget with validation as a work around?

Thanks,
nja

[njaParticipant]

Hi,
Thanks. I have had some luck with the setting the columntype to number and tweaking a custom editor. It is very neat the way the different widgets work together.

Not having as much luck with the custom sorting routine, but I am sure I will get it.

Thanks for your help,
nja

[njaParticipant]

Hi Peter,
I am happy to pull out the commit() since you say it is wrong.

Functionally, what happens is when a cell is changed I run an ajax call to update the database and show a success or failure message to the user. That has been working fine. Can you explain why I should not do it in the cell changed event?

Even if I switch my grid to the select mode and edit mode that you use in the example the (selectionmode: ‘singlecell’, editmode: ‘click’,) if the user types a number they start editing in the first grid cell (after adding a new row).

If it was possible to select the cell and make the editor open/active that should address the users problem.

thanks,
nja

[Author]

Posts