Locking Cells causes lost images on cellType checkBox

Locking Cells causes lost images on cellType checkBox

Posted by: miguel.marques on 5 November 2017, 6:04 pm EST

• 

  miguel.marques

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 November 2017, 6:04 pm EST

  I have this simple block of code, when I execute the .Lock the images previously set on CheckBox is lost.

  fpSpread1.Row = 1;
  
  fpSpread1.Col = 1;
  
  fpSpread1.CellType = UpgradeHelpers.Spread.FpCellType.CellTypeCheckBox;// UpgradeHelpers.Spread.
  
  fpSpread1.TypeCheckCenter = true;
  
  fpSpread1.TypeCheckText = “”;
  
  fpSpread1.TypeCheckPicture[0] = this.ImagensControlos.Images[“CHK”];
  
  fpSpread1.TypeCheckPicture[1] = this.ImagensControlos.Images[“UNCHK”];
  
  fpSpread1.TypeCheckPicture[2] = fpSpread1.TypeCheckPicture[1];
  
  fpSpread1.TypeCheckPicture[3] = fpSpread1.TypeCheckPicture[0];
  
  fpSpread1.EditMode = true;

          fpSpread1.BlockMode = true;
          fpSpread1.Col = 1;
          fpSpread1.Col2 = 1;
          fpSpread1.Row = 1;
          fpSpread1.Row2 = 1;
          fpSpread1.Lock = true;
          fpSpread1.BlockMode = false;
  

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 6 November 2017, 6:51 am EST

  Hello,

  The code you are using is incorrect for setting a picture for CheckBox cell with Spread COM. Please use the code as follows:

  
  fpSpread1.Row = 1;
              fpSpread1.Col = 1;
              fpSpread1.CellType = FPSpreadADO.CellTypeConstants.CellTypeCheckBox;
              fpSpread1.TypeCheckCenter = true;
              fpSpread1.TypeCheckText = "";
              Bitmap myimage = (Bitmap)Image.FromFile(@"C:\Program Files\FarPoint Technologies\Spread 8\Samples\Files\BELL.BMP", true);
              fpSpread1.set_TypeCheckPicture(0, myimage);
              Bitmap myimage2 = (Bitmap)Image.FromFile(@"C:\Program Files\FarPoint Technologies\Spread 8\Samples\Files\CAMCORD.BMP", true);
              fpSpread1.set_TypeCheckPicture(1, myimage2);
  
  
              fpSpread1.BlockMode = true;
              fpSpread1.Col = 1;
              fpSpread1.Col2 = 1;
              fpSpread1.Row = 1;
              fpSpread1.Row2 = 1;
              fpSpread1.Lock = true;
              fpSpread1.BlockMode = false;
  
  

  The output of the above is attached image.

  Thanks,
  
  Deepak Sharma