FiveTech Software tech support forums

I don't want to wrap the text. What I was think to do is: 1 Fill all the text that will me merged 2 Do a autofit 3 Than I can check the width of the columns, and save it into an array 4 Then merge the cells 5 Fill the rest of the rows. 6 Do the autofit again, and check that ...

anserkk wrote:Di you try

Code: Select all  Expand view

oSheet:Cells:EntireColumn:AutoFit

The above code should AutoFit All Columns on the Worksheet

Hi,

Yes, I did this. This is working very nice, but if you have merged cells, it doen't work on that cell. It works well or the cells below and above that cell

Di you try

Code: Select all  Expand view

oSheet:Cells:EntireColumn:AutoFit

The above code should AutoFit All Columns on the Worksheet

... in cell of excel in pixels? My program is creating an excel file and ith that file, some fields are merged. The problem is that excel don't do an autofit of merged cells. I don't know the width of the text, cinse I get this information of a database This is the result: http://www.vms.be/downloads/merge1.JPG ...

Ok, I found a solution for it with the range() object. Thanks Jimmy, Thank you for your answer. Indeed, I can use oSheet:EntireColumn:AutoFit() for the complete excel, but what If I want to do it for column 1 to 30? Another example is if I want to set the cell-format for only column 1 to ...

Jimmy, Thank you for your answer. Indeed, I can use oSheet:EntireColumn:AutoFit() for the complete excel, but what If I want to do it for column 1 to 30? Another example is if I want to set the cell-format for only column 1 to 30 oSheet:Columns(  "A:ZZ" ...

Hi, Now I'm using [code]oSheet:Columns( "A:ZZ" ):AutoFit()[/code] to set the autofit. Is it possible to give instead of "A:ZZ" the range with numbers? Now I have to calculate the range to convert it to characters. ...

Hi,

Now I'm using

Code: Select all  Expand view

[code]oSheet:Columns( "A:ZZ" ):AutoFit()[/code]

to set the autofit.

Is it possible to give instead of "A:ZZ" the range with numbers?
Now I have to calculate the range to convert it to characters.

Dear Mr.Rao

The screen resolution is vary on my desktop and laptops.

How can I autofit column (stretch or srink) according to the resolution ?

I have sent screenshot of my application to you.

Regards

Yunus.

... had been previously shown: http://forums.fivetechsupport.com/viewtopic.php?p=190987 * Enhancement: XBROWSER now has new clauses NOMODAL and AUTOFIT. * Enhancement: When buttonbar is created in a Dialog, it is not any more necessary to call oDlg:Resize() in ON INIT clause. * Enhancement: ...

... )   hHash := &cStr   aHash := HGetValueAt( hHash, 1 )   xbrowser aHash setup ( obrw:autofit(), oBrw:bRClicked := { |r,c,f,o| o:ToDbf( "download.dbf", nil, nil, .t. ) } )return nil  In case you ...

Buen dia, guiandome por las opciones de Visual B. intenta asi, saludos... :shock: oHoja:Columns(n):AutoFit() // asi ajusta la celda al texto, n es el numero de la columna oHoja:Columns(n):ColumnWidth := n // ancho oHoja:Columns(n):ColumnHeight := n // alto http://forums.fivetechsupport.com/viewtopic.php?f=6&t=6924&p=31324&hilit=ColumnWidth#p31324 ...

nageswaragunupudi wrote:It may be easier to do something like this:

oCol:nWidth := oBrw:GetWidth( "這是一個句子". oFont )

You may also try
oCol:AutoFit()
or
oBrw:AutoFit()

I see.

It may be easier to do something like this:

oCol:nWidth := oBrw:GetWidth( "這是一個句子". oFont )

You may also try
oCol:AutoFit()
or
oBrw:AutoFit()

... is called during execution of CreateFromCode(). In case of dialogs, Adjust() method is executed during Init of the Dialog. (c) Enhancement: AutoFit() can be called at anytime now: AutoFit( [aColsToFit], [lVisibleOrNumRows], [lDataOnly], [nMaxWidth] ) aColsToFit: Optional array of columns ...