I'll second that, money well spent.... Lahav
-----Original Message----- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Douglas von Roeder via 4D_Tech Sent: Thursday, May 28, 2020 9:12 AM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Douglas von Roeder <dvonroe...@gmail.com> Subject: Re: Pluggers XL_Plugin Format Question 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 ********************************************************************** ********************************************************************** 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 **********************************************************************