Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

如何设置单元格格式而非数据格式 #2516

Closed
JackMa1046 opened this issue Apr 1, 2024 · 4 comments
Closed

如何设置单元格格式而非数据格式 #2516

JackMa1046 opened this issue Apr 1, 2024 · 4 comments

Comments

@JackMa1046
Copy link

版本号:1.7.2
问题描述:如何像excel那样,设置单元格格式,比如设置为货币格式,常规格式;另外设置了数据格式为百分比,但是导出到表格里面却是字符类型的百分比,如0.987654321,设置了百分比,导出来就是98.77%,内容和展示的时候都是98.77%了,内容应该为98.7654321%,并且导出来的百分比不能参与计算
错误日志&截图:
重现步骤:

友情提示(为了提高issue处理效率):

  • 积木报表是一款免费报表产品,功能免费源码不开放;
  • 未按格式要求发帖,会被直接删掉;
  • 请针对问题提供[报表设计配置或SQL脚本]或在官网制作报表示例并提供ID;
  • 针对不好重现的问题,请录制操作视频或详细的重现步骤;
@jeecgos
Copy link
Collaborator

jeecgos commented Apr 7, 2024

ws

@JackMa1046
Copy link
Author

ws是啥意思?

@1298191366
Copy link

1298191366 commented Apr 9, 2024

经测试百分比导出无问题,除非你设置了小数位数,目前除了数值类型的导出是数值类型,其余全是文本,你可以设置成为数值类型,导出后在设置单元格格式
image

@jeecgos
Copy link
Collaborator

jeecgos commented Apr 19, 2024

因长时间未回复,暂时关闭此问题

@jeecgos jeecgos closed this as completed Apr 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants