怎么设置光标落在当前单元格的文字后面

收藏

dexteryao · dexteryao

您好设置 FocusPosition

var ct = new CustomerCellType();
ct.FocusPosition = EditorFocusCursorPosition.End;
fpSpread1.ActiveSheet.Cells[1, 1].CellType = ct;

复制代码

gls6316 · gls6316

dexteryao 发表于 2016-10-20 13:30
您好设置 FocusPosition

      private void spdOrder_EditChange(object sender, EditorNotifyEventArgs e)
      {
         try
         {
            FarPoint.Win.Spread.CellType.TextCellType celltype;
            int rowindex = spdOrder.Sheets[0].ActiveRowIndex;       // 当前行
            int columnindex = spdOrder.Sheets[0].ActiveColumnIndex; // 当前列

            if ((spdOrder.Sheets[0].Columns.Get(columnindex).CellType.NToString() == "TextCellType" &&
                  string.IsNullOrEmpty(spdOrder.Sheets[0].Cells.Get(rowindex, columnindex).CellType.NToString())) ||
                  spdOrder.Sheets[0].Cells.Get(rowindex, columnindex).CellType.NToString() == "TextCellType")
            {
                  if (string.IsNullOrEmpty(spdOrder.Sheets[0].Cells.Get(rowindex, columnindex).CellType.NToString()))
                  {
                     celltype = (FarPoint.Win.Spread.CellType.TextCellType)spdOrder.Sheets[0].Columns.Get(columnindex).CellType;
                  }
                  else
                  {
                     celltype = (FarPoint.Win.Spread.CellType.TextCellType)spdOrder.Sheets[0].Cells.Get(rowindex, columnindex).CellType;
                  }
                  string sValue = spdOrder.GetCeLL(rowindex, columnindex);
                  Encoding sjis = Encoding.GetEncoding("shift-jis");

                  int iMax = celltype.MaxLength;

                  while (iMax < sjis.GetByteCount(sValue))
                  {
                     int curPoint = sValue.Length - 1;
                     if (curPoint < 0)
                     {
                        curPoint = 0;
                     }
                     sValue = sValue.Remove(curPoint, 1);
                  }
                  spdOrder.SetCeLL(rowindex, columnindex).Text = sValue;
            }
         }
         catch (SoapException soapex)
         {
            ExceptionInfo(soapex.ToString(), FaultCode.Server, this.Name);
         }
         catch (Exception ex)
         {
            ExceptionInfo(ex.ToString(), FaultCode.Client, this.Name);
         }
      }

当输入全角，超过最大可入力的字节，光标就会跳到第一个字符前面，怎么解决版主

dexteryao · dexteryao

您 spdOrder.SetCeLL(rowindex, columnindex).Text = sValue; 后加上下面代码试试

                  var editor = fpSpread1.EditingControl as GeneralEditor;

                  if (editor != null)
                  {
                     editor.SelectionStart = sValue.Length;
                     editor.SelectionLength = 0;
                  }

		自动登录	找回密码
密码			立即注册

[已处理] 怎么设置光标落在当前单元格的文字后面

3 个回复

活字格认证

讲师达人

悬赏达人

元老葡萄

SpreadJS 认证

SpreadJS 高级认证

微信认证勋章