保留格式的情况下修改表格单元格的内容

XDSoft

Changing the value of a Table cell without losing the formatting
问题：

I'm trying to change the value of a Table cell which has some formatting that keeps the value in fractional format.

When I change the value the following way then the ["] sign will be missing from the end of the value and also when the user edits the value it will not be formatted to fractional anymore, i.e. the cell loses its formatting. What is the solution?

table.SetValue(row, col, "6 1/2", ParseOption.SetDefaultFormat);

解答：

The cell's Value type is double, but when you use SetValue() and pass in a string the Value type will be converted to string, which is no good.

Another thing is that no matter what ParseOption you pass in, the DataFormat of that cell will be erased.

So you need to store the Format and pass in a double value, then restore the Format. This way the value will be formatted as it should be.
下面是源代码：

游客，本帖隐藏的内容需要积分高于 30 才可浏览，您当前积分为 0