是否可以使 DataGridView、DataGridColumn、DataGridCell 模仿 Excel 中的特定行为？

发布于 2024-12-01 02:42:27 字数 396 浏览 0 评论 0原文

技术： Visual Studio .NET 2008

我想知道是否有人知道强制 datagridview 中的列的行为与 Excel 类似的方法。

目前，这就是数据的样子：

A) 123456789.02211

我想看到的是

B) 123,456,789.02

但是，问题是，我希望数据在不使用时看起来像“B”（没有焦点，鼠标不在单元格中）并且我希望数据在使用时看起来像“A”。（单元格具有焦点，而不是整个列。）

如果我不能执行特定单元格，那也没关系。如果它像“当 dataGridview 具有焦点时，所有数据看起来都像 A 一样广泛，我可以处理这个问题。

有什么想法吗？

原文

Technologies: Visual Studio .NET 2008

I'm wondering if anyone is aware of a way to force a column in a datagridview to behave similarily to Excel.

Currently, this is what the data looks like:

A) 123456789.02211

what I would like to see is

B) 123,456,789.02

However, the catch is, I want the data to look like "B" when not in use (no focus, mouse isn't in cell) and I want the data to look like "A" when in use. (Cell has focus, not the whole column.)

If I can't do the specific cell, that's fine. If it's as broad as "When the dataGridview has focus, all data looks like A, I can deal with that.

Any ideas?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

阳光下的泡沫是彩色的 2024-12-08 02:42:27

您需要查看 DataGridView 的 CellBeginEdit 和 CellEndEdit 事件。 CellBeginEdit 事件将允许您设置要编辑的单元格的格式，而 CellEndEdit 事件将允许您在编辑完成后重置单元格的格式。

像这样：

private void dataGridView1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) {
    if (e.ColumnIndex != indexOfMyDateColumn) {    // Don't custom format all columns.
        dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Style = new DataGridViewCellStyle() { Format = "F5" };
    }
}

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) {
    if (e.ColumnIndex != indexOfMyDateColumn) {    // Don't custom format all columns.
       dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Style = new DataGridViewCellStyle { Format = "N2" };
    }
}

CellBeginEdit 和 CellEndEdit 事件都有 EventArg 属性，您可以使用它们来确定是否（和/或如何）设置单元格格式。我的示例使用 e.ColumnIndex 属性来确保我的日期列未格式化。

您可能需要不同的格式字符串，但这是您正在寻找的通用方法。

You'll want to take a look at the DataGridView's CellBeginEdit and CellEndEdit events. The CellBeginEdit event will allow you to format the cell you're about to edit and the CellEndEdit event will allow you to reset the cell's format back after editing is complete.

Like this:

private void dataGridView1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) {
    if (e.ColumnIndex != indexOfMyDateColumn) {    // Don't custom format all columns.
        dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Style = new DataGridViewCellStyle() { Format = "F5" };
    }
}

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) {
    if (e.ColumnIndex != indexOfMyDateColumn) {    // Don't custom format all columns.
       dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Style = new DataGridViewCellStyle { Format = "N2" };
    }
}

Both the CellBeginEdit and the CellEndEdit events have EventArg properties that you can use to determine if (and/or how) you want to format your cells. My example uses the e.ColumnIndex property to ensure that my date column is not formatted.

You might need different formatting strings but this is the general approach you're looking for.

回复收藏 0 原文

~没有更多了~