Feature requested :: Formulas like Excel Spreadsheet

[garora]

Hi Tony, We are using jqGrid and just upgraded to newer version 4.6.0 its really awesome :+1: Our client is having some kind of requirement where they want to a column on grid for apply formulas just we can do any Excel sheet, for reference I attached snapshot. eg. formula can be something like: R1C1+R1C2 or any kind of other mathematical.accounting things. We can use external plugins in jqGrid for this operation. Its fully depend upon you to consider this as a new feature or just mark it as rejected, but it will be a great add-on value to jqGrid functionality.

[garora]

@tonytomov - just would like to know if you have any plan for this feature?

[garora]

@tonytomov - any plan in near future for this?

[OlegKi]

You can use custom formatter and sorttype defined as function to implement your current requirements in old version jqGrid (like 4.6). If you load the data for the grid from the server you can use beforeProcessing alternatively to generate the values for C and G columns based on the formulas. See the answer, the answer, the answer, the answer and so on.

[garora]

Thanks - I will give it a try. On 20 Feb 2015 11:41, "Oleg Kiriljuk" [email protected] wrote:

You can use custom formatter http://www.trirand.com/jqgridwiki/doku.php?id=wiki:custom_formatter and sorttype defined as function to implement your current requirements in old version jqGrid (like 4.6). If you load the data for the grid from the server you can use beforeProcessing alternatively to generate the values for C and G columns based on the formulas. See the answer http://stackoverflow.com/a/6690875/315935, the answer http://stackoverflow.com/a/8001822/315935, the answer http://stackoverflow.com/a/5296935/315935, the answer http://stackoverflow.com/a/9855764/315935 and so on.

— Reply to this email directly or view it on GitHub https://github.com/tonytomov/jqGrid/issues/575#issuecomment-75194324.

[tonytomov]

Hello,

I think that @garora want to make this formula online - i.e like excel one. With a little custom javascript code this can be implemented very elegant, but of course will not be so easy to implement. Instead I will add this in our todo.

Using a custom formatter as mentioted above will solve the problem for now

[tonytomov]

You can use custom formatter and sorttype defined as function to implement your current requirements in old version jqGrid (like 4.6).

Also this is available in 4.7 and in last development version

[garora]

Thanks @tonytomov - I am going to make a try it, until it;ll available in coming releases.

On Fri, Feb 20, 2015 at 1:54 PM, Tony Tomov [email protected] wrote:

You can use custom formatter and sorttype defined as function to implement your current requirements in old version jqGrid (like 4.6).

Also this is available in 4.7 and in last development version

— Reply to this email directly or view it on GitHub https://github.com/tonytomov/jqGrid/issues/575#issuecomment-75204261.

Thanks & Regards, Gaurav Arora

[garora]

@tonytomov @OlegKi - I have solved it using custom formatters. But, my suggestion was to introduce simple spreadsheet (excel) flavor to jQgrid. I hope, I'll see this new feature very soon.

[OlegKi]

@garora: It would be helpful if you share your current solution. Your original suggestion was formulated in very common case. Probably some subset of features could have common case and could be interesting for other users.

[garora]

I will create an example and share I just use something like this: C = A+B On 6 Mar 2015 18:06, "Oleg Kiriljuk" [email protected] wrote:

@garora https://github.com/garora: It would be helpful if you share your current solution. Your original suggestion was formulated in very common case. Probably some subset of features could have common case and could be interesting for other users.

— Reply to this email directly or view it on GitHub https://github.com/tonytomov/jqGrid/issues/575#issuecomment-77552514.

[garora]

@tonytomov Just wondering if this feature is released.

[JPPivot]

looking forward for this feature.. Thank you!