Intersoft Community - grid

Enable Editing in excel export

aiyer@intuition.com — Tue, 11 Jul 2017 13:41:45 GMT

We use 2009 and 2013 grid. when grid data is exported to excel and 'Enable Editing' option in excel is clicked in IE, converts the result to an unsuable html data.works fine in chrome.

Delete Grid rows from server side 2

dafna.a@mtsint.com — Wed, 28 May 2014 08:26:12 GMT

Hi,

I can't find a way to delete rows (or hide them) on server side , I attached my code.

The ' OnPreRender' event removes 2 rows , but it seems strange because the following line: grid.RootTable.GetRow(2); returns null on the client side 'Button2_onclick' event.

Your assistance will be highly appreciated.

Thanks,

Delete Grid rows from server side

dafna.a@mtsint.com — Wed, 28 May 2014 08:25:21 GMT

Hi,

I can't find a way to delete rows (or hide them) on server side , I attached my code.

The ' OnPreRender' event removes 2 rows , but it seems strange because the following line: grid.RootTable.GetRow(2); returns null on the client side 'Button2_onclick' event.

Your assistance will be highly appreciated.

Thanks,

WebUI Studio 2010 r2 and WebUI Studio 2010 r1

qq397472251 — Sun, 13 Feb 2011 23:22:30 GMT

I have installed 'WebUI Studio 2010 r1' before .
Now I have uninstalled 'WebUI Studio 2010 r1' and instal 'WebUI Studio 2010 r2'.
But I do not know that what the difference is between them.
Anyone can tell me?

Truncate grid from clientside

hermancordes@gmail.com — Thu, 11 Mar 2010 10:31:21 GMT

Currently I'm using the WebGrid in a modalbox as lookup. The Grid doesn't have a datasource assigned, because it's filled from clientside. The user can't interact with the grid in any way; only to select a row.

Each search action will fill the grid from clientside. However, before each search action, I'd like to empty the grid. I tried this:

var grid = ISGetObject("SearchResultsWebGrid");
for(var i = 0; i < grid.RootTable.GetRowsCount(); i++)
{
    grid.RootTable.GetRow(i).Delete();
}
grid.RootTable.UpdateUI()

However, it's not giving me javascript warnings or other errors. And, it doesn't remove any rows... I searched this website for a solution, but couldn't find it so far.

Anyone got a solution or an idea how to truncate (delete all rows) from a webgrid at clientside?

Thanks!

Multiple Row Paste Validation

danjransom@gmail.com — Thu, 28 Jan 2010 23:00:50 GMT

The "Paste Multiple Rows from Clipboard" feature sounds great in theory, but in practice we are finding it impossible to implement in a real-world scenario. As far as we can tell, there is no way to highlight bad data inserted into the grid when using this feature.

For example: we have a grid with a mix of numeric, date, text, and valuelist (dropdown) columns. Some of the fields are set to require input. When users enter data in the new row at the top of the grid all of the cells are validated ensuring good values. However, using the "Paste Multiple Rows from Clipboard" feature, users can put in values that are in no way valid, i.e. text in a date field, dates in a numeric field, value list items that are not in the list, and even NULL values in a required field.

Despite the extremely limited amount of documentation on this feature, we have been able to apply some of our own validation using the OnAddPendingChanges client event. However, even though we can blank out celss or apply default values to the added fields, we can find no way to highlight these bad cells to inform the user of the invalid data.

It would be great if we could just run row.Vaidate() or row.GetElement() but we can't access the rows inserted by the multiple row paste feature using GetRow(#) or any other meathod.

How can we highlight (with color) specific inserted cells to denote bad pasted values?