[Feature] We have date and time, but no date and time format. We currently need such a function, and I think this is a very useful function.

[feige-2011]

初始清单

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

问题

增加日期时间格式的单元格类型

解决方案

增加日期时间格式的单元格类型

[univer-bot[bot]]

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

Origin Title: [Feature] 我们有日期和时间，却没有日期时间格式，我们目前需要这样的功能，并且我觉的这是相当有用的功能

Title: [Feature] We have date and time, but no date and time format. We currently need such a function, and I think this is a very useful function.

---

Initial list

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

question

Add date and time format cell type

solution

Add date and time format cell type

[Gggpound]

目前是支持的，可以试试设置 cell.s.n 属性，n是一段数字格式的规则，如果使用日期 可以设置为 yyyy/MM/dd ,其中 v 是一段日期数字

[univer-bot[bot]]

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

It is currently supported. You can try setting the cell.s.n attribute. n is a number format rule. If you use dates, you can set it to yyyy/MM/dd, where v is a date number.