dream-num / univer

Univer is an open-source productivity tool dev kit helping you integrate spreadsheets, docs and slides into your applications.
https://univer.ai
Apache License 2.0
6.7k stars 581 forks source link

[Feature] Added sheet api [Copy specified rows] and [Copy multiple rows] #3642

Open 18860852449 opened 2 days ago

18860852449 commented 2 days ago

初始清单

问题

问题:对于一个拥有公式区域,中间或者下方插入的新行没有公式。然后通过插入行的监听自己计算出来的公式会成为【固定值】,后面如果再刚才插入的行上方继续插入新行,那么刚才生成的公式不会变,直接成为了一个【固定属性】,并不会随着上方插入行或者删除行而变化。

需求:希望官方增加【复制指定行】和【复制多行】这样的api,因为手动copy试过了可以满足需求。

univer-bot[bot] commented 2 days ago

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

Origin Title: [Feature] 增加 sheet api 【复制指定行】和【复制多行】

Title: [Feature] Added sheet api [Copy specified rows] and [Copy multiple rows]


Initial list

question

Problem: For a range that has formulas, new rows inserted in the middle or below do not have formulas. Then the formula calculated by monitoring the inserted row will become a [fixed value]. If you continue to insert a new row above the row just inserted, the formula just generated will not change and will directly become a [fixed attribute], and It will not change when rows are inserted or deleted above.

Demand: I hope that the official will add APIs such as [Copy specified rows] and [Copy multiple rows], because manual copying can meet the needs.