yCode Home   Spread Sheet Simple Example

yCode Spread Sheet v1.5 control allows user to enter any kind of data in an html table. When the user clicks inside a cell, it becomes editable; when the user leaves this cell, its value is updated.
The spread sheet is easily customizable on the fly:

Please select a property you would like to control:
Set Number Of Clicks
Set # of Rows and Columns
Column Width
Spread Sheet Resize
Set Function
Retrieve Data
Set Data
A cell becomes editable after you click inside the spread sheet.
Please choose between a single and double click for your spread sheet:
Single Click Double Click
Please enter the number of rows and columns you'd like to have in the spread sheet:
Rows:      Columns: 
Columns can resize when data is entered in the cells or have a fixed width in pixels.
Please check the checkbox and specify the column width:
Column width is set to:
The Spread Sheet Conrol can resize when the window resizes or stay the same size.
Please check the checkbox and try to resize the window:
Spread Sheet resizes with the browser window. Set width to: %
For this demo we defined column sum and average functions for the spread sheet: you can sum or average all the values in a column (except the last one) and the result is stored in the last cell.
Please select the function you'd like to apply:
Retrieve current number of rows:
Retrieve current number of columns:

Select Row:      Column: 
Retrieve Row Values:
Retrieve Column Values:
Retrieve Cell Value:
Select Row:      Column: 

Enter value:  

Note: if an arithmetic function is applied on columns of the spead sheet, the last row will reflect the result of this function.


1 02 003    
2        
         

Note: the source code for this page is copyrighted.

Please follow the link to BUY the source code for $25 (USD)
(Purchase securely through
ibill, our authorized sales agent).

Any other functionality can be added upon request. Please contact sales@yCode.com for more information.

yCode Home   Spread Sheet Simple Example