univer icon indicating copy to clipboard operation
univer copied to clipboard

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

Open zhaolixin7 opened this issue 10 months ago • 1 comments

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

  • [X] 这真的是个问题吗?
  • [X] 我已经在 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 avatar Apr 19 '24 07:04 zhaolixin7

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?

  • [X] Is this really a problem?
  • [X] 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

univer-bot[bot] avatar Apr 19 '24 07:04 univer-bot[bot]

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

Gggpound avatar Jun 25 '24 08:06 Gggpound

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

@Dushusir image What about the number format here?

univer-bot[bot] avatar Jun 25 '24 08:06 univer-bot[bot]

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

Dushusir avatar Jun 25 '24 13:06 Dushusir

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

univer-bot[bot] avatar Jun 25 '24 13:06 univer-bot[bot]