找回密码
 立即注册

QQ登录

只需一步,快速开始

扫一扫,访问微社区

查看: 1036|回复: 0

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

[复制链接]

已领礼包: 145个

财富等级: 日进斗金

发表于 2021-1-11 23:06:50 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。

您需要 登录 才可以下载或查看,没有账号?立即注册

×
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



论坛插件加载方法
发帖求助前要善用【论坛搜索】功能,那里可能会有你要找的答案;
如果你在论坛求助问题,并且已经从坛友或者管理的回复中解决了问题,请把帖子标题加上【已解决】;
如何回报帮助你解决问题的坛友,一个好办法就是给对方加【D豆】,加分不会扣除自己的积分,做一个热心并受欢迎的人!
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|申请友链|Archiver|手机版|小黑屋|辽公网安备|晓东CAD家园 ( 辽ICP备15016793号 )

GMT+8, 2024-11-4 20:06 , Processed in 0.169518 second(s), 25 queries , Gzip On.

Powered by Discuz! X3.5

© 2001-2024 Discuz! Team.

快速回复 返回顶部 返回列表