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
**********************************************************************

Reply via email to