Questions tagged [sigma-grid-control]

Sigma grid is a pure JavaScript widget with Ajax support for displaying and inline editing data in a scrollable and sortable table.

Sigma grid is a pure JavaScript widget with Ajax support for displaying and inline editing data in a scrollable and sortable table. It is very powerful, yet easy-to-use and integration with PHP, ASP.NET, JSP and RoR (Ruby on Rails).

Features:

  • IE 6.0+ | FireFox 2.0+ | Safari 3.0+ | Opera9.0+ | Chrome supported.
  • Online printing, to make it easy to print tabular data in WYSIWYG way.
  • Built in button, no coding. Bar diagram, line diagram and pie diagram built in.
  • Translation tabular data into diagram without any server-side coding.
  • Extensibility enable you to replace built-in cell editor with custom external component, present cell data as your customers' wish.
  • Data filter enables grid to present the data users are interested in only.
  • Ability to enable developer to work out as complex header as they wish.
  • Nested header, image header, dropdown list control embedded header are all supported.
  • LGPL license and commercial license both available.

The product home page: http://www.sigmawidgets.com/products/sigma_grid2/
The project home page: https://code.google.com/archive/p/ajaxdatagridview/

13 questions
3
votes
4 answers

Has anyone used Sigma Grid (Javascript-based editable data grid)?

Has anyone here used Sigma Grid for JavaScript-based data grids? It was the only grid I could find that would allow fast data entry and use of the keypad, but before we spend a lot of development time I wanted to learn about the community's…
Beep beep
  • 18,873
  • 12
  • 63
  • 78
2
votes
1 answer

how to get number of records for Sigma grid in asp.net

I am using Sigma grid in an asp.net project. I want to display that no record is found if the DB returns null. I have tried a few things like: var grid = Sigma.$grid(grid_demo_id); var test1 = grid.dataset.getSize(); But it always return -1…
1
vote
1 answer

How to disable auto sort on sigma grid?

i want to disable the autosort feature of sigmagrid, because the order was set from database. in my case, the order when the grid loaded is by alphabet ascending. in my database con for load grid, i've set the order by on select query, why do the…
Xinez
  • 331
  • 3
  • 6
  • 17
1
vote
1 answer

How to set return message on save success using sigma grid?

does anyone know, how to set return message when using sigma grid?? i've read the documentation on http://www.sigmawidgets.com/products/sigma_grid2/docs/ however still no luck, i don't really understand how to use it maybe anyone can solve this…
Xinez
  • 331
  • 3
  • 6
  • 17
1
vote
1 answer

Javascript Error,Escaping Problem,Grid not working,Error on Firebug

we are just started with Sigma Grid ,and it is awesome in its functionality when we compared to other Grids. But i encountered some problem with Sigma Grid ,or may be with javascript. I dont know whether the problem is with Grid or with my code. I…
Red
  • 6,230
  • 12
  • 65
  • 112
0
votes
1 answer

How to use sigma grid editor type checkbox?

is there any ways to set the value of checkbox on sigma grid?? i don't see any configuration that could change it maybe anyone ever try it? i need the checkbox value to change, so that the rows checked will be send to be updated. that is the only…
Xinez
  • 331
  • 3
  • 6
  • 17
0
votes
2 answers

How to simulate a spreadsheet

I am working with Sigma grid, populating it from PHP. Sigma is supposed to have a formula handling function, but it only seems to work with JS loaded datasets. So I was wondering if it was possible to modify some of the cells after load of page, do…
Onyx
  • 876
  • 1
  • 10
  • 18
0
votes
1 answer

Update only the checked rows using sigmagrid

How to make sigma grid update only the checked rows?? so that when the users click the save button, only checked rows will be updated. maybe anyone ever use this method?? o.O in the cols option i've added this line to show checkbox, but when i click…
Xinez
  • 331
  • 3
  • 6
  • 17
0
votes
1 answer

empty results displaying count as -1 instead of 0

We are displaying count of results displayed based on "from & to date" search, we are facing issue that when there is empty results, than its displaying "-1" as result, but we want to display as "0" html code is
rqwerty
  • 13
  • 4
0
votes
1 answer

Count the Rows in Sigma Grid

I am new here using the Sigma Grid. How can I count the rows in Sigma Grid? I just want the number of rows that are appear in my screen. thanks for advance.
0
votes
1 answer

How do we dynamically populate a Sigma Grid?

This should be so easy and yet... The following code works just fine (I've trimmed away the info not needed here): $(function() { . .. ... // Defining the data options. var datasetOptions = { fields: fieldArray, …
Michael
  • 9
  • 4
0
votes
2 answers

Not able to fix x and y position in sigma js

I tried to draw a graph in circle layout.I have given the x and y position for the nodes as follows X=Math.cos(Math.PI*(u)/l)*R Y=Math.sin(Math.PI*(u)/l)*R where u is an incrementor and l is number of nodes and R is radius. the equation seems to be…
0
votes
0 answers

How to use Sigma grid built-in capabilities to calculate aggregates where Sortable property set to TRUE

How to use Sigma grid built-in capabilities to calculate aggregates where Sortable property set to TRUE, So that We can also sort the columns but It must not affect Aggregate Row(Or Totals row, That row should not be sorted as it provides the Total…