设置流程文档表格单元格中文本的格式
我有一个程序可以创建一个表格，将其与填充文本的表格单元格一起添加到流程文档中。除了一个例外，一切都运转良好。表中的一列单元格显示成本，其格式如下：
cellValue = "$" + string.Format("{0:##,#.00}", int.Parse(cellValue)).PadLeft(22 -
cellValue.Length);
事实证明，采用这种格式，像 $ 11,111 这样的数字与 $ 10,000< 这样的数字占据不同的宽度。 /代码>。我猜是因为每个字符的字体宽度不相等。
我想要做的是能够显示成本，就像在 Excel 电子表格中格式为会计时一样（即美元符号左手对齐，数字右手对齐，并且数字从单元格排列）到细胞）。
例子：
10,000.00 美元
11,111.11 美元
如果有人知道要应用什么格式来实现此目标，请告诉我。
I have a program that creates a table, adds it to a flow document along with table cells that are populated with text. Everything works great with one exception. One column of cells in the table displays costs and they have been formated as follows:
cellValue = "$" + string.Format("{0:##,#.00}", int.Parse(cellValue)).PadLeft(22 -
cellValue.Length);
As it turns out, with this formatting numbers like $ 11,111 take up a different width then numbers like $ 10,000. I would guess because the font is not equal width for each character.
What I would like to do is be able to display the costs just like the are when in an Excel spreadsheet when formatted as Accounting (ie the dollar sign is left hand justified, the numbers are right hand justified and the numbers are lined up from cell to cell).
Example:
$ 10,000.00
$ 11,111.11
If someone knows what formatting to apply to reach this goal please let me know.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这可能太简单了，但猜测我会为单元格使用固定字体，例如“Courier New”，以便所有字符具有相同的宽度并对齐。这样做的缺点是“Courier New”并不是最优雅的字体。
我确信 Excel 使用更复杂的机制来对齐数值。
也许您应该使用比流程文档中的表格更好地模仿电子表格的东西。
This is probably too simple but at a guess I would use fixed font for the cell like "Courier New" so that all the characters are the same width and would align up. The downside of this is that "Courier New" is not the most elegant font to use.
I am sure Excel uses a much more sophisticated mechanism for aligning numeric values.
Maybe you should use something that better mimics a spreadsheet than a table in a flowdocument.