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