Ken: I haven’t used that particular format but I suspect that it is used like the other formats. If you haven’t created formats, check the code in the demo. It’s not extensive but, if you hold your head just right, things will make sense.
At the moment, I’m away from a computer but I’ll post some code in the AM. On Wed, May 27, 2020 at 6:03 PM Ken Eyring via 4D_Tech <[email protected]> wrote: > I'm taking a look at buying the Pluggers XL_Plugin and most of my test > went very quickly. Looks like a spectacular plugin. > > It was real easy to open a spreadsheet and insert values into specific > cells. > > I ran into some confusion though, when I tried to set a cell's format, > e.g. to Locked, or change the font name or font size, etc... > > Here are the instructions for xlFormatSetLocked, but I'm not sure what > to pass in: > > xlFormatSetLocked( format ; locked ) > → longint → integer > Sets the locked protection property: 1 - true, 0 - false. > > I expected to define a sheet, row and column to identify the cell I > wanted to set the format for - but I don't see how to define which cell > I want to affect. > > If someone wouldn't mind sending a simple snippet of code that shows how > to set a specific cell's format using this plugin I would really > appreciate it. > > Thanks, > Ken > > ********************************************************************** > 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:[email protected] > ********************************************************************** -- -- Douglas von Roeder 949-910-4084 ********************************************************************** 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:[email protected] **********************************************************************
