Ken: Lahav’s example should get you on the right track and Kirk’s advice is well taken. Rob has been very helpful answering my questions on the plugin.
"I'm taking a look at buying the Pluggers XL_Plugin and most of my test went very quickly. Looks like a spectacular plugin." I agree. The XL Plugin is an excellent product. -- Douglas von Roeder 949-910-4084 On Thu, May 28, 2020 at 3:57 AM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> wrote: > Awesome, thank you! > > > > On 05/28/20 1:46 AM, lists via 4D_Tech wrote: > > Ken, > > > > You build the format and assign the different attributes to it (one of > which can be the locked flag, a font etc). > > > > $ YourDefinedFormat:=xlBookAddFormat ($xlBook) > > $font:=xlBookAddFont ($xlBook) > > xlFormatSetFont ($YourDefinedFormat;$font) > > xlFontSetName ($font;"Arial") > > xlFontSetSize ($font;10) > > xlFormatSetLocked( $YourDefinedFormat; 1 ) > > > > Then, when you assign a cell value, you also assign the format as in: > > > > xlSheetSetCellNumber ($sheet;$row;$col;$cellData;$YourDefinedFormat) > > > > HTH > > > > Lahav > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > New Forum: https://discuss.4D.com > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************