| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
XL.ConditionalFormat.SetFillPattern
Sets the fill pattern.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| XL | 14.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XL.ConditionalFormat.SetFillPattern"; BookRef; ConditionalFormatRef; Value ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| BookRef | The reference to the workbook. Please use XL.LoadBook to load a file. | $ref |
| ConditionalFormatRef | The reference number for the conditional format. | $ConditionalFormat |
| Value | The new pattern. | 3 |
Result
Returns OK or error.
Description
Sets the fill pattern.| None | 0 |
| Solid | 1 |
| 50% Gray | 2 |
| 75% Gray | 3 |
| 25% Gray | 4 |
| Horizontal Stripes | 5 |
| Vertical Stripes | 6 |
| Reverse Diagonal Stripes | 7 |
| Diagonal Stripes | 8 |
| Diagonal Cross Hatch | 9 |
| Thick Diagonal Stripe | 9 |
| Thin Horizontal Stripe | 11 |
| Thin Vertical Stripe | 12 |
| Thin Reverse Diagonal Stripe | 13 |
| Thin Diagonal Stripe | 14 |
| Thin Horizontal Cross Hatch | 15 |
| Thin Diagonal Cross Hatch | 16 |
| Gray 12P5 | 17 |
| Gray 6P25 | 18 |
see table of fill patterns here:
http://www.libxl.com/format.html#borderStyleTable#setFillPattern
See also
- XL.ConditionalFormat.GetFillPattern
- XL.ConditionalFormat.SetBorderLeft
- XL.ConditionalFormating.AddOpNumRule
- XL.ConditionalFormating.AddRule
- XL.LoadBook
- XL.Sheet.AddConditionalFormatting
Example Databases
Blog Entries
Created 30th March 2024, last changed 30th March 2024
XL.ConditionalFormat.SetCustomNumFormat - XL.ConditionalFormat.SetNumFormat
