Leading and Trailing zeroes truncated and Long Numbers display in scientific notation in excel
来源:互联网 发布:ubuntu wine 配置 编辑:程序博客网 时间:2024/05/17 21:54
Microsoft Excel is too smart and it identifies whether the value in the cell is a Text or number and applies formatting accordingly.
This sometimes becomes an issue for us when we are trying to generate an excel report.
For example Customer number 006358 has all the numbers and starts with zero, this when printed in excel report displays it as 6358.
Hence all the leading zeroes are truncated. Same issue happens when we have decimal and trailing zeroes.
What was more, for those Long numbers such as Invoice number 102000514789 is printed as 1.02001E+11.
To handle this problem, you can specify the formatting type as "Regular Text" and choose "Force LTR"
FO formatting options will be used to get away with this problem. Below is the syntax for same.
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?CUSTOMER_NUMBER?>
</fo:bidi-override>
This sometimes becomes an issue for us when we are trying to generate an excel report.
For example Customer number 006358 has all the numbers and starts with zero, this when printed in excel report displays it as 6358.
Hence all the leading zeroes are truncated. Same issue happens when we have decimal and trailing zeroes.
What was more, for those Long numbers such as Invoice number 102000514789 is printed as 1.02001E+11.
To handle this problem, you can specify the formatting type as "Regular Text" and choose "Force LTR"
FO formatting options will be used to get away with this problem. Below is the syntax for same.
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?CUSTOMER_NUMBER?>
</fo:bidi-override>
0 0
- Leading and Trailing zeroes truncated and Long Numbers display in scientific notation in excel
- 11029 - Leading and Trailing
- Leading and Trailing
- Leading and Trailing
- uva11029 - Leading and Trailing
- lightoj1282 - Leading and Trailing
- 1282 - Leading and Trailing
- lightoj Leading and Trailing
- Leading and Trailing [数学]
- Leading and Trailing LightOJ
- Leading and Trailing
- Leading and Trailing LightOJ1282
- Leading and Trailing LightOJ
- Leading and Trailing LightOJ
- Leading and Trailing LightOJ
- UVA 11029 Leading and Trailing
- UVA 11029 - Leading and Trailing
- uva 11029 - Leading and Trailing
- jqueryMobile 动态添加元素,展示刷新视图方法
- 我们需要的产品经理
- Spring AOP execution 突破点表达式
- 规范的合格
- 茶叶蛋---土豪身份的新象征
- Leading and Trailing zeroes truncated and Long Numbers display in scientific notation in excel
- 常见突破点表达式的例子(aop execution 表达式 )
- 高薪需要什么?
- SQL中EXCEPT和Not in的区别?
- 19 gcc的gdb调试选项参数
- spring AspectJ的Execution表达式-备忘札记
- 规定非合同
- 5种你未必知道的JavaScript和CSS交互的方法
- Matlab画图