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

Reply via email to