The Wayback Machine - http://web.archive.org/web/20210822022750/https://github.com/mengshukeji/Luckysheet/issues/534
Skip to content

/ Luckysheet

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

计算字段排序失败 #534

Open

wusongping opened this issue Feb 24, 2021 · 2 comments
Open

计算字段排序失败 #534

wusongping opened this issue Feb 24, 2021 · 2 comments
Labels
good first issue

Comments

@wusongping
Copy link

@wusongping wusongping commented Feb 24, 2021

Describe the bug
报表产生计算字段后, 执行排序, 发现非计算字段数据可以按照规则排序, 但计算字段数据只按原样子显示, 排序失效.

To Reproduce
Steps to reproduce the behavior:

  1. The first step
  2. The second step
  3. The third step
  4. See error

What is expected?
计算字段可以与非计算字段一样实现排序功能

Screenshots or demo

Environment
luckysheet v2.1.13

Additional context
Add any other context about the problem here.
@oy-paddy
Copy link

@oy-paddy oy-paddy commented Mar 5, 2021

我也遇到了这个问题。排序后。公式会跑偏，不会自动更新。比如是第一行，C1=sum(A1+B1); 利用luckysheet.setRangeSortMulti排序后，变为其他行例如C2，但是C2的公式还是=sum(A1+B1)
@oy-paddy
Copy link

@oy-paddy oy-paddy commented Mar 5, 2021

我也遇到了这个问题。排序后。公式会跑偏，不会自动更新。比如是第一行，C1=sum(A1+B1); 利用luckysheet.setRangeSortMulti排序后，变为其他行例如C2，但是C2的公式还是=sum(A1+B1)

排序之后，公式应该也要更新，C2=sum(A2+B2) 才对
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
good first issue
Projects
None yet
Milestone
No milestone
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants
@oy-paddy @Dushusir @wusongping