Spread Windows Forms 9.0 Product Documentation
SortDescendingImage Field
Example 


Specifies the index, 6, for the image for the descending sort indicator.
Syntax
'Declaration
 
Public Const SortDescendingImage As Integer
'Usage
 
Dim value As Integer
 
value = SpreadView.SortDescendingImage
public const int SortDescendingImage

Field Value

Integer index corresponding to this part of the user interface
Example
This example sets the image for the specified field.
FarPoint.Win.Spread.SpreadView wrkbk = fpSpread1.GetRootWorkbook(); 
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortAscendingImage, Image.FromFile("D:\\up.bmp")); 
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortAscendingImageDisabled, Image.FromFile("D:\\up-dis.bmp")); 
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortDescendingImage, Image.FromFile("D:\\down.bmp")); 
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortDescendingImageDisabled, Image.FromFile("D:\\down-dis.bmp")); 
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortUnsortedImage, Image.FromFile("D:\\unsort.bmp")); 
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortUnsortedImageDisabled, Image.FromFile("D:\\unsort-dis.bmp")); 

Random r = new Random();
int i, j = 0;
for (i = 0; i <;= 7; i++)
    for (j = 0; j<= 7; j++)
    {
        fpSpread1.ActiveSheet.SetValue(i, j, r.Next().ToString());
    }

fpSpread1.ActiveSheet.Columns[0].AllowAutoSort = true;

Image indicator;
indicator = wrkbk.GetImage(4);
pictureBox1.Image = indicator;
Dim wrkbk As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook()
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortAscendingImage, Image.FromFile("D:\up.bmp"))
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortAscendingImageDisabled, Image.FromFile("D:\up-dis.bmp"))
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortDescendingImage, Image.FromFile("D:\down.bmp"))
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortDescendingImageDisabled, Image.FromFile("D:\down-dis.bmp"))
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortUnsortedImage, Image.FromFile("D:\unsort.bmp"))
wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.SortUnsortedImageDisabled, Image.FromFile("D:\unsort-dis.bmp"))

Dim r As New Random
Dim i, j As Integer
For i = 0 To 7
    For j = 0 To 7
        FpSpread1.ActiveSheet.SetValue(i, j, r.Next.ToString())
    Next j
Next i

FpSpread1.ActiveSheet.Columns(0).AllowAutoSort = True

Dim indicator As Image
indicator = wrkbk.GetImage(4)
PictureBox1.Image = indicator
Remarks
The index for the enabled descending sort indicator is 6.
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SpreadView Class
SpreadView Members
Customizing the User Interface Images

 

 


Copyright © GrapeCity, inc. All rights reserved.