| T O P I C R E V I E W |
| blt2si |
Posted - 01/29/2003 : 10:51:52 AM
Hi all,
Is there any method to set the column length in a row(in all rows)automatically according to the columnlabel width .In my worksheets every column label has different width(length) when i imported them from files the column name is not appearing completely.sometimes the label is small and the values are too long.So half of the values are coming.
So I want to set the column width on the bisis of their names and value without any extra extra length per column. If possible, can anyone help me?
Thank you,
Blank
|
| 1 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
Posted - 01/29/2003 : 12:43:11 PM
Hi Blank,
Here's a simple LabTalk solution. It sets the width (in characters) of each column equal to its name or label width (whichever is bigger)...
loop (ii,1,wks.ncols) {
%N=wks.col$(ii).name$;
%L=wks.col$(ii).label$;
nn=%[%N]; // width of column name
if(nn<%[%L]) nn=%[%L];
// if label is wider use it instead
wks.col$(ii).width=nn;
};
Mike Buess
Origin WebRing Member |
|
|
