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