spread单元格中字体如何修改颜色

请问某个单元格中部分内容如何修改字体颜色？谢谢

想得到效果如下：

回复 1楼lucklyme的帖子

请参考一下代码：

1. 
   
2. this.fpSpread1.Sheets[0].Cells[0, 0,9,9].ForeColor = System.Drawing.Color.Red;
   

复制代码

回复 2楼iceman的帖子

版主你好，你的代码我试过了，他只能让整个单元格发生改变，不能让一个单元格中的某几个字的发生改变

回复 3楼lucklyme的帖子

lucklyme 你好，

改变部分字体可以使用 RichTextCellType 来实现，代码如下：
C#

1. 
   
2. C# Copy Code
   
3. FarPoint.Win.Spread.CellType.RichTextCellType rtf = new FarPoint.Win.Spread.CellType.RichTextCellType();
   
4. rtf.WordWrap = true;
   
5. rtf.Multiline = true;
   
6. fpSpread1.ActiveSheet.Cells[0, 0].CellType = rtf;
   
7. fpSpread1.ActiveSheet.Columns[0].Width = 300;
   
8. fpSpread1.ActiveSheet.Rows[0].Height = 150;
   
9. fpSpread1.ActiveSheet.Cells[0, 0].Value = @"{\rtf1\ansi\ansicpg1252\deff0\deflang1033
   
10. {\fonttbl{\f0\fscript\fprq2\fcharset0 Comic Sans MS;}
    
11. {\f1\froman\fprq2\fcharset0 Times New Roman;}
    
12. {\f2\fswiss\fcharset0 Arial;}}{\colortbl ;\red128
    
13. \green0\blue128;\red0\green255\blue255;\red255\green0\
    
14. blue0;\red0\green255\blue0;\red0\green0\blue255;}
    
15. \viewkind4\uc1\pard\cf1\b\f0\fs24 Testing\cf2\b0\fs28 \cf3
    
16. \f1\fs40 1... \cf4\i 2... \cf5\ul\i0 3...\cf0\f2\fs20\par}";
    

复制代码

VB：

1. 
   
2. Dim rtf As New FarPoint.Win.Spread.CellType.RichTextCellType()
   
3. rtf.WordWrap = True
   
4. rtf.Multiline = True
   
5. FpSpread1.ActiveSheet.Cells(0, 0).CellType = rtf
   
6. FpSpread1.ActiveSheet.Columns(0).Width = 300
   
7. FpSpread1.ActiveSheet.Rows(0).Height = 150
   
8. FpSpread1.ActiveSheet.Cells(0, 0).Value = "{\rtf1\ansi\ansicpg1252\deff0\deflang1033" + _
   
9. "{\fonttbl{\f0\fscript\fprq2\fcharset0 Comic Sans MS;}" + _
   
10. "{\f1\froman\fprq2\fcharset0 Times New Roman;}" + _
    
11. "{\f2\fswiss\fcharset0 Arial;}}" + _
    
12. "{\colortbl ;\red128\green0\blue128;\red0\green255\blue255;" + _
    
13. "\red255\green0\blue0;" + _
    
14. "\red0\green255\blue0;\red0\green0\blue255;}" + _
    
15. "\viewkind4\uc1\pard\cf1\b\f0\fs24 Testing\cf2\b0\fs28" + _
    
16. " \cf3\f1\fs40 1... \cf4\i 2... \cf5\ul\i0 3...\cf0\f2\fs20\par" + _
    
17. "}"
    
18. 
    
19. 
    

复制代码