如何合并行头

收藏

我现在有一个表格，每两行代表数据库中的一行，spread是否可以做到像下面这个图片里的表格一样的两行合并为一行！
主要是红色圈起来的那部分应该怎么实现？
如果是将rowheader设置未不可视，使用cell来实现合并，则无法完美的去掉边框，请教了！
谢谢！

gw0506 · gw0506

上面图片所示的用例，比较适用于MultiRow产品。
MultiRow专注于票据类数据展示，排布方式自由。可以通过下面的链接了解详细介绍以及产品示例和视频演示。
http://www.gcpowertools.com.cn/products/mr_overview.htm

下面是MultiRow的效果图：

Layout_big[1].jpg (55.93 KB, 下载次数: 796)

manabout · manabout

非常感谢您的回复，我看到的是MultiRow for forms。
请问有MultiRow for asp.net版本吗？

ZenosZeng · ZenosZeng

抱歉，没有MultiRow for asp.net版本

manabout · manabout

那spread for asp.net有推荐的解决方案吗？

ZenosZeng · ZenosZeng

Spread中提供了一种RowTemplate的布局方式，你可以试一试这种方法是否满足你的需求，Spread帮助文档中有RowTemplate的详细使用方法。

manabout · manabout

曾经尝试过这种做法，但是没有任何合并的效果出现，下面的我的测试代码
FpSpread1.ActiveSheetView.ColumnHeader.Columns.Count = 16;
         FpSpread1.ActiveSheetView.LayoutMode = FarPoint.Web.Spread.SheetView.LayoutModeType.RowTemplateLayoutMode;
         FpSpread1.ActiveSheetView.RowTemplate.ColumnCount = FpSpread1.ActiveSheetView.ColumnCount;
         FpSpread1.ActiveSheetView.RowTemplate.RowCount = 2;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 0].ColumnSpan = 2;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 0].LayoutColumn.Width = 15;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 0].LayoutRow.Height = 15;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 0].DataIndex = 0;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 0].RowSpan = 2;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 1].DataIndex = 1;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 1].RowSpan = 2;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 2].DataIndex = 2;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 2].RowSpan = 2;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 3].DataIndex = 2;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 3].RowSpan = 2;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 4].DataIndex = 14;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 5].DataIndex = 3;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 4].DataIndex = 4;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 4].ColumnSpan = 2;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 6].DataIndex = 14;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 7].DataIndex = 5;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 6].DataIndex = 4;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 6].ColumnSpan = 6;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 8].DataIndex = 7;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 8].RowSpan = 2;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 9].DataIndex = 14;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 9].DataIndex = 8;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 10].DataIndex = 9;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 10].RowSpan = 2;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 11].DataIndex = 14;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 11].RowSpan = 2;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 12].DataIndex = 10;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 12].RowSpan = 2;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 13].DataIndex = 11;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 13].RowSpan = 2;

         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 14].DataIndex = 14;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 15].DataIndex = 12;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 14].DataIndex = 13;
         FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 14].ColumnSpan = 2;

         FpSpread1.ActiveSheetView.DataSource = ds.Tables[0];

ZenosZeng · ZenosZeng

你好，用你的代码加上测试数据得到下图的结果，不知道你是否得到了同样的结果：

17.png (57.1 KB, 下载次数: 865)

2012-1-30 17:05 上传

点击文件名下载附件
png

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FpSpread1.ActiveSheetView.ColumnHeader.Columns.Count = 16;
FpSpread1.ActiveSheetView.LayoutMode = FarPoint.Web.Spread.SheetView.LayoutModeType.RowTemplateLayoutMode;
FpSpread1.ActiveSheetView.RowTemplate.ColumnCount = FpSpread1.ActiveSheetView.ColumnCount;
FpSpread1.ActiveSheetView.RowTemplate.RowCount = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 0].ColumnSpan = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 0].LayoutColumn.Width = 15;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 0].LayoutRow.Height = 15;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 0].DataIndex = 0;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 0].RowSpan = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 1].DataIndex = 1;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 1].RowSpan = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 2].DataIndex = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 2].RowSpan = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 3].DataIndex = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 3].RowSpan = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 4].DataIndex = 14;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 5].DataIndex = 3;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 4].DataIndex = 4;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 4].ColumnSpan = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 6].DataIndex = 14;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 7].DataIndex = 5;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 6].DataIndex = 4;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 6].ColumnSpan = 6;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 8].DataIndex = 7;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 8].RowSpan = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 9].DataIndex = 14;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 9].DataIndex = 8;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 10].DataIndex = 9;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 10].RowSpan = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 11].DataIndex = 14;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 11].RowSpan = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 12].DataIndex = 10;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 12].RowSpan = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 13].DataIndex = 11;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 13].RowSpan = 2;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 14].DataIndex = 14;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[0, 15].DataIndex = 12;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 14].DataIndex = 13;
FpSpread1.ActiveSheetView.RowTemplate.LayoutCells[1, 14].ColumnSpan = 2;
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("/App_Data/data.xml"));
FpSpread1.ActiveSheetView.DataSource = ds.Tables[0];
}
}

复制代码

测试数据data.xml:

<Items>
<Item>
<Col1>1</Col1>
<Col2>2</Col2>
<Col3>3</Col3>
<Col4>4</Col4>
<Col5>5</Col5>
<Col6>6</Col6>
<Col7>7</Col7>
<Col8>8</Col8>
<Col9>9</Col9>
<Col10>10</Col10>
<Col11>11</Col11>
<Col12>12</Col12>
<Col13>13</Col13>
<Col14>14</Col14>
<Col15>15</Col15>
<Col16>16</Col16>
</Item>
</Items>

复制代码

manabout · manabout

谢谢！
我没有看到这样的结果，我明天再看看怎么回事！

manabout · manabout

终于知道是怎么回事了，在IE中是好用的，但是在CHROME中就不好用了，这个问题怎么解决啊。
还有一个问题就是设置滚动条的时候
this.FpSpread1.HorizontalScrollBarPolicy = ScrollBarPolicy.Never;
//this.FpSpread1.VerticalScrollBarPolicy = ScrollBarPolicy.Never;
设置滚动条的时候CHROME也有问题，要么同时显示，要么同时隐藏

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

[已处理] 如何合并行头

24 个回复

活字格认证

圣诞拼拼乐

微信认证勋章

讲师达人

元老葡萄

悬赏达人