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

[Bug] 单元格文本格式或者常规格式输入0开头0都会被省略掉 #3675

Open
2 tasks done
335060087 opened this issue Oct 10, 2024 · 3 comments
Open
2 tasks done

Comments

@335060087
Copy link

在您提交此问题之前,您是否检查了以下内容?

  • 这真的是个问题吗?
  • 我已经在 Github Issues 中搜索过了,但没有找到类似的问题。

受影响的包和版本

0.3.0

复现链接

官网链接即可复现

预期行为

文本:01--->01

实际行为

文本:01--->1

运行环境

Chrome

系统信息

No response

@335060087 335060087 added the bug Something isn't working label Oct 10, 2024
@jikkai
Copy link
Member

jikkai commented Oct 11, 2024

Please confirm that your cell type is set to CellValueType.FORCE_STRING. If you still cannot input a string of numbers starting with 0 when the cell type is set to CellValueType.FORCE_STRING, you should provide the minimal reproduction.

@jikkai jikkai added need reproduction and removed bug Something isn't working labels Oct 11, 2024
@liuniuxs
Copy link

如果设置了强文本类型,但是我的数据中包含字符串,025,011这种数据,会强制弹出提示“以文本形式存储的数字”,实际中数据可能会有abcd,汉字,025等形式;
而且如果单元格初始化时包含公式,即使设置了强文本类型也会失效。
Image_20241012094509
Image_20241012094539

@univer-bot
Copy link

univer-bot bot commented Oct 14, 2024

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

If the strong text type is set, but my data contains strings such as 025,011, the prompt "Numbers stored in text form" will be forced to pop up. In fact, the data may be in the form of abcd, Chinese characters, 025, etc.;
And if the cell initialization contains a formula, even if the strong text type is set, it will fail.
Image_20241012094509
Image_20241012094539

@Dushusir Dushusir assigned Dushusir and unassigned Gggpound Oct 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants