Hi Pat, When there is no 4D command to do something in 4D Write Pro, try javascript.
I suggest using an anomymous javascript function. Build your javascript code using a 4D Object with the “New formula” command. The basic shell — for an anonymous javascript function in 4D code — is the following 4-lines: — $js:=New object("val";"";"add";New formula(This.val:=This.val+$1)) $js.add("(function(){“) // Your javascript code will go between these 2-lines: immediately above and below this comment. $js.add("})();") $t:=WA Evaluate JavaScript(*;$objName_vp_t;$js.val;Is text) — You then add as many “js.add(“”) lines as necessary to write javascript to accomplish the spread sheet behavior you want. Here’s how I set a column width to a specific size. The size is in points. — // local C_OBJECT($js) C_TEXT($t) // parameter C_TEXT($1;$objName_vp_t) // write pro view object name C_LONGINT($2;$column_number_i) // column number C_LONGINT($3;$column_width_i) // column width (in points) $objName_vp_t:=$1 $column_number_i:=$2 $column_width_i:=$3 $js:=New object("val";"";"add";New formula(This.val:=This.val+$1)) $js.add("(function(){") $js.add("var sheet = Utils.currentSheet;") $js.add("sheet.setColumnWidth("+String($column_number_i)+", "+String($column_width_i)+",GC.Spread.Sheets.SheetArea.viewport);") $js.add("})();") $t:=WA Evaluate JavaScript(*;$objName_vp_t;$js.val;Is text) — Details on “setColumnWidth” are at: https://help.grapecity.com/spread/SpreadSheets11/webframe.html#autofit.html <https://help.grapecity.com/spread/SpreadSheets11/webframe.html#autofit.html> Best regards, Jeremy > On May 24, 2019, at 5:04 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > How do you set a column width (via code) in View Pro? ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************