Fpspread如何实现向Excel一样拖拽公式时公式自动变换

Fpspread如何实现向Excel一样拖拽公式时公式自动变换

请参考一下代码：

1.     private void fpSpread1_DragFillBlock(object sender, FarPoint.Win.Spread.DragFillBlockEventArgs e)
   
2.     {
   
3.         e.DataOnly = false;
   
4.     }
   
5. 
   
6.     private void Form1_Load(object sender, EventArgs e)
   
7.     {
   
8.         fpSpread1.AllowDragFill = true;
   
9. 
   
10.         fpSpread1.AllowUserFormulas = true;
    
11.         fpSpread1.Sheets[0].Cells[2, 2].Formula = "C3+D3";
    
12. 
    
13.         fpSpread1.DragFillBlock += new FarPoint.Win.Spread.DragFillBlockEventHandler(fpSpread1_DragFillBlock);
    
14.     }

复制代码