hello :
can anyone please tell me how to fixed the column like excel .. ?
sorry.
i want to the first 1-n columns to be fixed while scrolling horizontally.
Okay... this is easy....
var cm = new Ext.grid.ColumnModel([
{ header : 'Fixed column #1', width : 200, locked : true },
{ header : 'Fixed column #2', width : 200, locked : true },
{ header : 'Non-fixed column #1', width : 200 },
:
{ header : 'Non-fixed column #n', width : 200 }
]);
sorry .
the first columns can not be fixed while scrolling horizontally.
Gaspode's Brain Dump: Fixed-width Text File Editor - Excel.::
Fixed-width Text File Editor - Excel. Recently I needed to work with NAV to produce The formula looked like this: MID('Text File'!$A1,Columns!B$1,1)
http://gaspodethewonderdog.blogspot.com/2007/10/fixed-width-text-file-editor-excel.htmlHOME |
code :
var schema = {
root: 'result',
id: 'nothing',
name: 'nothing',
sex: 'nothing',
birthday: 'nothing',
interest: 'nothing',
salary: 'nothing',
fields: ['ID','name','sex','birthday','interest','salary']
}
var colModel = new YAHOO.ext.grid.DefaultColumnModel([
{header: "id", width: 100, sortable: true},
{header: "name", width: 100, sortable: true , locked : true ,editor: new yg.TextEditor({allowBlank: false}) },
Convert XLSX to Fixed Width Text Files Easily with 'Convert XLS ::
The first example shows how to convert from an Excel file(s) to a fixed width text file. In this example each column width can be specified since it uses
http://www.softinterface.com/Convert-XLS/Features/Convert-XLSX-To-Fixed-Width-Text-File.htmHOME |
Tell Bill Gates to fix Excel bug, urges 'Pivot King' - 25 Dec 2005::
Tell Bill Gates to fix Excel bug, urges 'Pivot King'. AccountingWEB's Excel Topic Expert David .. I like the way it only sorts the column I select.
http://www.accountingweb.co.uk/cgi-bin/item.cgi?id=14466&d=1032&h=1033&f=1026HOME |
{header: "sex", width: 100, sortable: true},
{header: "birthday", width: 100, sortable: true},
{header: "interest", width: 100, sortable: true},
{header: "salary", width: 100, sortable: true ,
renderer: formatMoney,
editor: new yg.NumberEditor({allowBlank: false, allowNegative: false, maxValue: 100})
}
]);
var grid = new YAHOO.ext.grid.EditorGrid('example-grid', dataModel,colModel);
grid.render();
i want the columns [ name ] can be fixed.
Locked columns is not supported in the .33 codebase. You'll have to upgrade to the 1.0 beta code.
What exactly do you need? A fixed column width, a column that can't be moved, or the first 1-n columns to be fixed while scrolling horizontally... or ?
 Red Hat's Rough Recovery From CFO Exit
 Windows Live Finds a New, Pre-installed Home
|
PRINT
Add to favorites