dream-num / univer

Univer is an open-source alternative to Google Sheets, Slides, and Docs
https://univer.ai
Apache License 2.0
5.92k stars 490 forks source link

[Feature] Please tell me, are there any examples of cells in the time format in the official examples? I set the cell type to time, but I didn’t see any effect? #2535

Closed feige-2011 closed 3 weeks ago

feige-2011 commented 1 month ago

Initial checklist

Problem

更改单元格数据为time格式的时候,没有看到单元格有任何变化,官网的例子里没有时间单元格的例子。

Solution

设置单元格为time ,formula1和formula2,都没有设置

univer-bot[bot] commented 1 month ago

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

Origin Title: [Feature] 请教一下,官方的例子里有time格式的单元格示例么,我设置了type为time的单元格,没有看到任何效果?

Title: [Feature] Please tell me, are there any examples of cells in the time format in the official examples? I set the cell type to time, but I didn’t see any effect?


Initial checklist

Problem

When changing the cell data to time format, I did not see any changes in the cells. There are no examples of time cells in the examples on the official website.

Solution

Set the cell to time, formula1 and formula2, none of them are set

Gggpound commented 3 weeks ago

你是把什么样的数值改为 time格式? 【45638.883472222224】 这种数值在改为time格式的时候,会被序列化为 【下午 9:12:12】

univer-bot[bot] commented 3 weeks ago

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

What kind of values ​​did you change to time format? [45638.883472222224] When this value is changed to time format, it will be serialized as [9:12:12 PM]

feige-2011 commented 3 weeks ago

我的意思是我在设置time格式时没有,输入框是不是应该弹出一个选择时间的弹窗,像日期组件那样方便输入?

univer-bot[bot] commented 3 weeks ago

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

What I mean is that I didn't set the time format when I set it. Shouldn't the input box pop up a pop-up window for selecting time, making it as convenient for input as the date component?