Thanks for responding Doug.
I looked at the code but did not see anything that jumped out at me
regarding formatting.
I look forward to seeing your sample code when you have a chance! Very
much appreciated!
Ken
On 05/27/20 9:41 PM, Douglas von Roeder via 4D_Tech wrote:
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]
**********************************************************************
**********************************************************************
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]
**********************************************************************
