Multiple Text Colors as Excel allows

Multiple Text Colors as Excel allows

Posted by: craigreilly on 11 January 2018, 10:34 am EST

• 

  craigreilly

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 January 2018, 10:34 am EST

  Can I do multiple text colors in a cell as I can in Excel?
  
  

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 11 January 2018, 7:43 pm EST

  Hello,

  You can set the celltype as RichTextCellType to have multi color text. Please go through the documentation given here:
  
  http://help.grapecity.com/spread/SpreadNet11/WF/webframe.html#spwin-setrichtextcell.html

  Thanks,
  
  Deepak Sharma

• 

  craigreilly

  • Post Options:
  • Link
    Copy

  Posted 17 January 2018, 7:27 am EST

  Thank you,

  Somehow I missed that cell type in my research.

  Can I disable font use or limit font size?
  
  In my first test - 3 out of 5 people set a font to 144 size… so was asked if we can limit to 20.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 18 January 2018, 1:32 am EST

  Hello,

  You can set the Font size using the code as follows:

  
  
    FarPoint.Win.Spread.Cell acell;
              acell = fpSpread1.ActiveSheet.Cells[0, 0];
              acell.Font = new Font("MS Sans Serif",20, FontStyle.Bold);
              acell.Text = "Font";
  
  

  Thanks,
  
  Deepak Sharma

• 

  craigreilly

  • Post Options:
  • Link
    Copy

  Posted 30 January 2018, 4:52 am EST

  My question was about limiting the font sizes available to the end user:

  Can I disable font use or limit font size?
  
  In my first test - 3 out of 5 people set a font to 144 size… so was asked if we can limit to 20.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 31 January 2018, 10:09 pm EST

  Hello,

  There is no direct way to limit the font size if the user changes the font size at machine level.

  Thanks,
  
  Deepak Sharma