单元格内换行

farpoint7如何实现编辑的单元格内文字换行，excel的单元格内换行按键为Alt+Enter

回复 1楼menghuanyunxia的帖子

测试代码如下：

1. 
   
2. private void Form1_Load(object sender, EventArgs e)
   
3. {
   
4.       FarPoint.Win.Spread.CellType.TextCellType t = new FarPoint.Win.Spread.CellType.TextCellType();
   
5.       FarPoint.Win.Spread.InputMap ancestorOfFocusedMap = fpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused);
   
6.       FarPoint.Win.Spread.ActionMap am = fpSpread1.GetActionMap();
   
7.       am.Put("AltEnter", new myAction());
   
8.       ancestorOfFocusedMap.Put(new FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextRow );
   
9.       ancestorOfFocusedMap.Put(new FarPoint.Win.Spread.Keystroke(Keys.Enter, Keys.Alt), "AltEnter");
   
10.       fpSpread1.SetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused, ancestorOfFocusedMap);
    
11.       t.Multiline = true;
    
12.       fpSpread1.Sheets[0].Cells[1, 1].CellType = t;
    
13.       fpSpread1.Sheets[0].Rows[1].Height = 60;
    
14.       fpSpread1.Sheets[0].Columns[1].Width = 140;
    
15.     }
    
16. 
    
17.     private void fpSpread1_EditModeOn(object sender, EventArgs e)
    
18.     {
    
19.       FarPoint.Win.Spread.CellType.GeneralEditor myText = (FarPoint.Win.Spread.CellType.GeneralEditor)fpSpread1.EditingControl;
    
20.       myText.AcceptsReturn = false;
    
21.     }
    
22.   }
    
23.   public class myAction : FarPoint.Win.Spread.Action
    
24.   {
    
25.     public override void PerformAction(object sender)
    
26.     {
    
27.       FarPoint.Win.Spread.SpreadView ss = (FarPoint.Win.Spread.SpreadView)sender;
    
28.       FarPoint.Win.Spread.CellType.GeneralEditor editor = (FarPoint.Win.Spread.CellType.GeneralEditor)ss.EditingControl;
    
29.       string text = editor.Text;
    
30.       text += "\n";
    
31.       ss.Sheets[0].SetValue(ss.Sheets[0].ActiveRowIndex, ss.Sheets[0].ActiveColumnIndex, text);
    
32.       ss.EditMode = true;
    
33.       editor = (FarPoint.Win.Spread.CellType.GeneralEditor)ss.EditingControl;
    
34.       editor.SelectionStart = editor.Text.Length;
    
35.     }
    
36.   }
    
37. }
    
38. 
    

复制代码

为了给你提供更优质的服务，请对本次服务进行评分。我们会认真对待你提出的宝贵意见，谢谢