[Feature] 单元格附加数据字段 about univer

[Issues-translate-bot]

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

---

Initial list

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

question

There is no place in the cell to store some data related to the cell. Although a two-dimensional array can be implemented externally to store the relevant data, when the form of the table changes, such as adding rows and columns or moving cells, a lot of data needs to be processed. Events are monitored and processed, so it is hoped that a field can be provided inside the cell to store additional data.

solution

It is hoped that a field can be provided to store additional data of the cell, such as meta field

[guowb1997]

是关于表格下拉选项的问题吗?表格怎么设置下拉选项呀

[Issues-translate-bot]

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

---

Is it a question about the drop-down options in the table? How to set the drop-down options in the table?

[fmwww]

是关于表格下拉选项的问题吗?表格怎么设置下拉选项呀

不是，下拉选项是条件格式，官方说一季度会推出，这个是单元格存储自定义数据，比如可以给单元格设置id等等

[Issues-translate-bot]

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

---

Is it a question about the drop-down options in the table? How to set the drop-down options in the table?

No, the drop-down option is conditional formatting. The official said it will be launched in the first quarter. This is for cells to store custom data. For example, you can set ids for cells, etc.

[ChuanfengZhang]

need it too.

[Superman-wc]

现在的单元格就只有value与style两个属性， 楼主是想要附加自定义的属性上去， 并且这些属性一样支持下拉填充、复制粘贴等操作，只是可能不直接做为value显示在单元格上， 可以在选中单元格的时候，显示属性时才显示出来！

不知道楼主我这样理解是否符合你想要的

[Issues-translate-bot]

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

---

The current cell only has two attributes: value and style. The author wants to add custom attributes, and these attributes also support drop-down filling, copy and paste, etc., but they may not be directly displayed on the cell as value. It can be displayed only when the properties are displayed when the cell is selected!

I don’t know if my understanding of the original poster is in line with what you want.

[fmwww]

现在的单元格就只有value与style两个属性， 楼主是想要附加自定义的属性上去， 并且这些属性一样支持下拉填充、复制粘贴等操作，只是可能不直接做为value显示在单元格上， 可以在选中单元格的时候，显示属性时才显示出来！

不知道楼主我这样理解是否符合你想要的

是的，其实只需要能够给cell指定一个id之类的属性就行，其他额外的信息可以自己通过这个id在univer外部去处理

[Issues-translate-bot]

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

---

The current cell only has two attributes: value and style. The author wants to add custom attributes, and these attributes also support drop-down filling, copy and paste, etc., but they may not be directly displayed on the cell as value. , it can be displayed only when the properties are displayed when the cell is selected!

I don’t know if my understanding of the original poster is in line with what you want.

Yes, in fact, you only need to be able to specify an attribute such as an id for the cell. Other additional information can be processed outside Univer through this id.

[Superman-wc]

luckysheet的时候，cell 对象可以添加自定义属性的，而且可以被复制到其他单元格， 不知道这边行不行得通，

[Issues-translate-bot]

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

---

In luckysheet, the cell object can add custom attributes and can be copied to other cells. I don’t know if this works.

[fmwww]

luckysheet的时候，cell 对象可以添加自定义属性的，而且可以被复制到其他单元格， 不知道这边行不行得通，

目前不行，不过官方说未来会添加这个功能

[Issues-translate-bot]

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

---

In luckysheet, the cell object can add custom attributes and can be copied to other cells. I don’t know if this works.

Not currently, but officials say this feature will be added in the future

[JackieCheung]

目前有其他方法吗

[univer-bot]

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

Are there any other methods currently?

[chenkeguo1]

就像spreadjs 的tag属性，点击了单元格也不会显示，导入excel会丢失。我主要用它把数据记录的id值、代码值（v属性显示的是代码内容）放入到这个属性中，在crud时很方便

[univer-bot]

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

Just like the tag attribute of spreadjs, it will not be displayed even if you click on the cell, and it will be lost when imported into excel. I mainly use it to put the id value and code value of the data record (the v attribute displays the code content) into this attribute, which is very convenient when using CRUD.