BUG: Copy and paste of formulas does not work (not enhancement, change label to BUG)

dream-num / obsidian-univer

Create, edit, and view spreadsheets and documents in various formats like Excel and Word directly within your knowledge base.

https://univer.ai

Apache License 2.0

80 stars 4 forks source link

BUG: Copy and paste of formulas does not work (not enhancement, change label to BUG) #70

Closed gregheth closed 6 months ago

gregheth commented 6 months ago

Problem

Coping formulas ignores

$ as absolute references and always pastes relative column and row
whole column references X:X and pastes #REF

Solution

fix the formula copy and paste utility

karlsbeard commented 6 months ago

I have tested this function in the obsidian-univer plugin and found that its behavior is consistent with Excel. If you believe this is a problem, please provide more detailed information, such as screenshots or GIFs.