请教行锁定的问题

收藏

本帖最后由 sxtywp2 于 2017-3-13 22:25 编辑

请教：1、怎么锁定第一到第五行，以及第八行，不允许修改
      2、怎么锁定列？
      3、能设置小数位不能超过3位吗？
      4  FpSpread1.UseClipboard = false;控制IE11不跳出剪贴板怎么不起作用？
谢谢

dexteryao · dexteryao

1 2. 锁定行列，locked 为true则为锁定。
         FpSpread1.ActiveSheetView.Rows[1].Locked = true;
         FpSpread1.ActiveSheetView.Rows[2].Locked = false;
         FpSpread1.ActiveSheetView.Columns[2].Locked = true;
         FpSpread1.ActiveSheetView.Protect = true;
3. Spread 没有限制用户输入的方法，可以在事件中去做处理。

<script lang="javascript" type="text/javascript">
window.onload = function () {
var spread1 = document.getElementById("<%=FpSpread1.ClientID %>");
if (document.all) {
// IE
if (spread1.addEventListener) {
// IE9
spread1.addEventListener("DataChanged", dataChanged, false);
} else {
// Other versions of IE and IE9 quirks mode (no doctype set)
spread1.onDataChanged = dataChanged;
}
}
else {
// Firefox
spread1.addEventListener("DataChanged", dataChanged, false);
}
}
function dataChanged(event) {
alert("The data changed!");
}
</script>

复制代码

4.这个是浏览器行为，需要在浏览器里设置

sxtywp2 · sxtywp2

本帖最后由 sxtywp2 于 2017-3-14 22:03 编辑

请教：

请教：
1、    一般界面锁定可以，但当加载excel文件后全部锁定了
this.FpSpread1.OpenExcel(this.Server.MapPath(@"tempt\kkk.xlsx"));

      FpSpread1.ActiveSheetView.Rows[1].Locked = true;
      FpSpread1.ActiveSheetView.Rows[2].Locked = true;
      FpSpread1.ActiveSheetView.Rows[4].Locked = false;
      FpSpread1.ActiveSheetView.Columns[0].Locked = true;
      FpSpread1.ActiveSheetView.Protect = true;
  出来的界面怎么全部锁定了，都不能输入？

2、后台C#怎么控制页面加载后默认选中第一行。
3、spread.CallBack("DOID&" + objbh);
后，前台能否有个提示等待之类的东西？

谢谢！

dexteryao · dexteryao

1.Excel 单元格默认时Locked的，而且cell的locked优先级高于行列，所以如果Cell设置了Locked true，需要通过代码重新设置为false
2. 用setselection设置
         FpSpread1.ActiveSheetView.SelectionModel.SetSelection(0, 0, 1, FpSpread1.ActiveSheetView.ColumnCount);
或者设置 OperationMode  为row，每次选择一行
         FpSpread1.ActiveSheetView.OperationMode = OperationMode.RowMode;
  FpSpread1.ActiveSheetView.ActiveRow = 0;
  FpSpread1.ActiveSheetView.ActiveColumn = 0;
3. 可以在事件里加

<script lang="javascript" type="text/javascript">
window.onload = function () {
var spread1 = document.getElementById("<%=FpSpread1.ClientID %>");
if (document.all) {
// IE
if (spread1.addEventListener) {
// IE9
spread1.addEventListener("CallBackStart", CallBackStart, false);
spread1.addEventListener("CallBackStopped", CallBackStopped, false);
} else {
// Other versions of IE and IE9 quirks mode (no doctype set)
spread1.onCallBackStart = CallBackStart;
spread1.onCallBackStopped = CallBackStopped;
}
}
else {
// Firefox
spread1.addEventListener("CallBackStart", CallBackStart, false);
spread1.addEventListener("CallBackStopped", CallBackStopped, false);
}
}
function CallBackStart(event) {
if (event==null) event = window.event;
alert("start");
}
function CallBackStopped(event) {
alert("stop");
}
</script>

复制代码

sxtywp2 · sxtywp2

dexteryao 发表于 2017-3-15 09:37
1.Excel 单元格默认时Locked的，而且cell的locked优先级高于行列，所以如果Cell设置了Locked true，需要通 ...

谢谢！
还遇到个问题请教
怎么设置列能显示到日期的同时能够显示出来时间

dexteryao · dexteryao

设置时间单元格的 Format

FarPoint.Web.Spread.DateTimeCellType dt = new FarPoint.Web.Spread.DateTimeCellType();
dt.FormatString = "yyyy/MM/dd hh:mm:ss";
dt.MaximumValue = new DateTime(2020, 12, 31);
dt.MinimumValue = new DateTime(1950, 1, 1);
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = dt;
FpSpread1.ActiveSheetView.Cells[0, 0].Value = DateTime.Now;

复制代码

sxtywp2 · sxtywp2

dexteryao 发表于 2017-3-15 10:32
设置时间单元格的 Format

多谢，试用EXCEL设计的A4纸的表格加载入系统，填入数据后，导出的时候，
用FpSpread1.SaveExcelToResponse(Server.UrlEncode("ab3.xls"));导出EXCEL在一张A4纸上，但用
FpSpread1.SavePdfToResponse(Server.UrlEncode("PdfTest.pdf"));导出PDF的时候，有一行跨到了第二页，请教有解决办法吗？
还有个问题，请教有像EXCEL一样的预览功能没有？谢谢

dexteryao · dexteryao

在导出pdf之前设置下PrintInfo，将Margin设置小。
这个没有预览，直接就下载了。

FarPoint.Web.Spread.PrintInfo prinf = new FarPoint.Web.Spread.PrintInfo();
prinf.BestFitCols = true;
prinf.BestFitRows = true;
prinf.Centering = FarPoint.Web.Spread.Centering.Both;
prinf.ColEnd = 10;
prinf.Colors = new System.Drawing.Color[] {
System.Drawing.Color.Green,
System.Drawing.Color.Yellow,
System.Drawing.Color.Gold,
System.Drawing.Color.Indigo,
System.Drawing.Color.Brown};
prinf.ColStart = 0;
prinf.FirstPageNumber = 1;
prinf.Footer = "/g"1"/cl"4"This is Page /p of /pc Pages";
prinf.FooterHeight = 40;
prinf.Header = "/cl"0"Print Job For FarPoint Inc./n /n ";
prinf.HeaderHeight = 40;
prinf.Images = new System.Drawing.Image[] {
System.Drawing.Image.FromFile("D:\\images\\point.jpg"),
System.Drawing.Image.FromFile("D:\\images\\logo.gif"),
System.Drawing.Image.FromFile("D:\\images\\icon.jpg")};
prinf.Margin = new FarPoint.Web.Spread.PrintMargin(10, 10, 10, 10, 20, 20);
prinf.Opacity = 50;
prinf.Orientation = FarPoint.Web.Spread.PrintOrientation.Landscape;
prinf.PageEnd = 5;
prinf.PageOrder = FarPoint.Web.Spread.PrintPageOrder.OverThenDown;
prinf.PageStart = 1;
prinf.PrintNotes = FarPoint.Web.Spread.PrintNotes.None;
prinf.PrintType = FarPoint.Web.Spread.PrintType.All;
prinf.RepeatColEnd = 10;
prinf.RepeatColStart = 1;
prinf.RepeatRowEnd = 10;
prinf.RepeatRowStart = 1;
prinf.RowEnd = 10;
prinf.RowStart = 1;
prinf.ShowBorder = false;
prinf.ShowColumnFooter = FarPoint.Web.Spread.PrintHeader.Show;
prinf.ShowColumnFooterEachPage = true;
prinf.ShowColumnHeader = FarPoint.Web.Spread.PrintHeader.Show;
prinf.ShowGrid = true;
prinf.ShowRowHeader = FarPoint.Web.Spread.PrintHeader.Show;
prinf.ShowSubtitle = true;
prinf.ShowTitle = true;
prinf.SmartPrintPagesTall = 1;
prinf.SmartPrintPagesWide = 1;
FarPoint.Web.Spread.SmartPrintRulesCollection prules = new FarPoint.Web.Spread.SmartPrintRulesCollection();
prules.Add(new FarPoint.Web.Spread.BestFitColumnRule(FarPoint.Web.Spread.ResetOption.None));
prinf.SmartPrintRules = prules;
prinf.UseMax = true;
prinf.UseSmartPrint = false;
prinf.ZoomFactor = 2;
FpSpread1.ActiveSheetView.PrintInfo = prinf;

复制代码

sxtywp2 · sxtywp2

不好意思，还有个问题，请教
表格中有张浮动的图片，红色的，但是
FpSpread1.SavePdfToResponse(Server.UrlEncode("PdfTest.pdf"));导出的时候有颜色
用
      FarPoint.Web.Spread.PrintInfo pi = new FarPoint.Web.Spread.PrintInfo();
         pi.Orientation = FarPoint.Web.Spread.PrintOrientation.Landscape;
         pi.Centering = FarPoint.Web.Spread.Centering.Both;
      pi.ShowColumnHeader = FarPoint.Web.Spread.PrintHeader.Hide;
      pi.ShowRowHeader = FarPoint.Web.Spread.PrintHeader.Hide;
设定后再导出，都黑色的。加下边后，还是黑色的，请教解决办法
      pi.Colors = new System.Drawing.Color[] {
      System.Drawing.Color.Green,
      System.Drawing.Color.Yellow,
      System.Drawing.Color.Red,
      System.Drawing.Color.Indigo,
      System.Drawing.Color.Brown};

谢谢

dexteryao · dexteryao

显示颜色是设置 printset.ShowColor = true;

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

[已处理] 请教行锁定的问题

13 个回复

讲师达人

悬赏达人

元老葡萄

SpreadJS 认证

SpreadJS 高级认证

微信认证勋章