你好,按照你的思路,下面是我的代码,没有出现空隙:
- protected void Button1_Click(object sender, EventArgs e)
- {
- int spreadHeight = Convert.ToInt32(this.FpSpread1.Height.Value);
- //27 为 CommandBar 高度
- int sheetHeight = spreadHeight - this.FpSpread1.Sheets[0].ColumnHeader.Height-27;
- int average = sheetHeight / (this.FpSpread1.Sheets[0].RowCount + this.FpSpread1.Sheets[0].ColumnFooter.RowCount);
- for (int i = 0; i < this.FpSpread1.Sheets[0].Rows.Count; i++)
- {
- this.FpSpread1.Sheets[0].Rows[i].Height = average;
- }
- for (int i = 0; i < this.FpSpread1.Sheets[0].ColumnFooter.RowCount; i++)
- {
- this.FpSpread1.Sheets[0].ColumnFooter.Rows[i].Height = average;
- }
- }
复制代码 所指的 页脚和数据部分衔接上好像还有一个空隙 可以发截图上来查看吗? |