Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
12.2
12.3
12.4
12.5
13.0
13.1
13.2
13.3
13.4
13.5
Statistic
FMM
Blog
Sets the fill pattern.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
XL | 3.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example |
---|---|---|
Book | The reference to the workbook. Please use XL.LoadBook to load a file. | $ref |
Format | The index of the format in the book to target. | 0 |
Value | The new setting. | $value |
Returns OK or error.
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 |
Sets the foreground color of the fill pattern to red to fill cell red:
If [ MBS( "XL.Book.GetRGBMode"; $book) = 0 ]
Set Variable [ $r; Value: MBS( "XL.Format.SetPatternForegroundColor"; $book; $format; 10) ]
Else
Set Variable [ $c; Value: MBS( "XL.Color.Pack"; $book; 255; 0; 0) ]
Set Variable [ $r; Value: MBS( "XL.Format.SetPatternForegroundColor"; $book; $format; $c) ]
End If
Set Variable [ $r; Value: MBS( "XL.Format.SetFillPattern"; $book; $format; 1 ) ]
This function checks for a license.
Created 18th August 2014, last changed 2nd November 2021