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] The formula is equal to the selection, and the expected formula result displays the number format #1999

Closed
2 tasks done
zhaolixin7 opened this issue Apr 19, 2024 · 5 comments · Fixed by #2598
Closed
2 tasks done
Assignees
Labels
bug Something isn't working scope:numfmt

Comments

@zhaolixin7
Copy link

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

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

受影响的包和版本

dev

复现链接

1、选区内容有数字格式(如百分比),公式等于该选区

预期行为

公式结果显示数字格式

实际行为

2024_4_19 15_26_51 commands.json
2024_4_19 15_26_51 video.webm

image

运行环境

No response

系统信息

No response

@zhaolixin7 zhaolixin7 added bug Something isn't working scope:numfmt labels Apr 19, 2024
@univer-bot univer-bot bot changed the title [Bug] 公式等于选区,预期公式结果显示数字格式 [Bug] The formula is equal to the selection, and the expected formula result displays the number format Apr 19, 2024
@univer-bot
Copy link

univer-bot bot commented Apr 19, 2024

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

Origin Title: [Bug] 公式等于选区,预期公式结果显示数字格式

Title: [Bug] The formula is equal to the selection, and the expected formula result displays the number format


Before you submitted this question, did you check the following?

  • Is this really a problem?
  • I've searched Github Issues but haven't found any similar issues.

Affected packages and versions

dev

Recurrence link

  1. The selection content has a numerical format (such as percentage), and the formula is equal to the selection

Expected behavior

Formula result display number format

Actual behavior

2024_4_19 15_26_51 commands.json
2024_4_19 15_26_51 video.webm

image

Running environment

No response

system message

No response

@Gggpound
Copy link
Contributor

@Dushusir
image
这里的数字格式呢?

@univer-bot
Copy link

univer-bot bot commented Jun 25, 2024

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

@Dushusir
image
What about the number format here?

@Gggpound Gggpound assigned Dushusir and unassigned Dushusir Jun 25, 2024
@Dushusir Dushusir assigned Dushusir and unassigned Gggpound Jun 25, 2024
@Dushusir
Copy link
Member

相同的格式问题
=TODAY() + 1
=NOW() + 1
都应该得到日期/时间格式

@univer-bot
Copy link

univer-bot bot commented Jun 25, 2024

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

Same formatting issue
=TODAY() + 1
=NOW() + 1
Both should get the date/time format

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working scope:numfmt
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants