Spread Windows Forms 10.0 Product Documentation
SortAscendingImage Field
Example 


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

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 ascending sort indicator is 4.
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.