Skip to content
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

[Bug] The index formula will have problems in column N, but there will be no problems in other columns. You can test it on the official website #4009

Open
2 tasks done
Sang-98 opened this issue Nov 8, 2024 · 3 comments
Assignees
Labels
bug Something isn't working

Comments

@Sang-98
Copy link

Sang-98 commented Nov 8, 2024

Before you submit this issue, have you checked the following

  • Is this really a problem?
  • I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

最新版本

Reproduction link

不是代码问题,将INDEX(E:E,3)放到E列第三行,会是0,其他列也是同样的效果,将INDEX(N:N,3)放到N列就会报错

Expected behavior

不是代码问题,将INDEX(E:E,3)放到E列第三行,会是0,其他列也是同样的效果,将INDEX(N:N,3)放到N列就会报错

Actual behavior

不是代码问题,将INDEX(E:E,3)放到E列第三行,会是0,其他列也是同样的效果,将INDEX(N:N,3)放到N列就会报错

System information

No response

@Sang-98 Sang-98 added the bug Something isn't working label Nov 8, 2024
@univer-bot univer-bot bot changed the title [Bug] index公式在N列会有问题,其他列没有问题,官网上就可以测试 [Bug] The index formula will have problems in column N, but there will be no problems in other columns. You can test it on the official website Nov 8, 2024
@univer-bot
Copy link

univer-bot bot commented Nov 8, 2024

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

Origin Title: [Bug] index公式在N列会有问题,其他列没有问题,官网上就可以测试

Title: [Bug] The index formula will have problems in column N, but there will be no problems in other columns. You can test it on the official website


Before you submit this issue, have you checked the following

  • Is this really a problem?
  • I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

latest version

Reproduction link

It is not a code problem. If you put INDEX(E:E,3) in the third row of column E, it will be 0. The same effect will be in other columns. If you put INDEX(N:N,3) in column N, an error will be reported.

Expected behavior

It's not a code problem. If you put INDEX(E:E,3) in the third row of column E, it will be 0. The same effect will be in other columns. If you put INDEX(N:N,3) in column N, an error will be reported.

Actual behavior

It's not a code problem. If you put INDEX(E:E,3) in the third row of column E, it will be 0. The same effect will be in other columns. If you put INDEX(N:N,3) in column N, an error will be reported.

System information

No response

@wpxp123456
Copy link
Contributor

@DR-Univer N:N N被解析成公式了

@univer-bot
Copy link

univer-bot bot commented Nov 14, 2024

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

@DR-Univer N:N N is parsed into a formula

@wpxp123456 wpxp123456 assigned DR-Univer and unassigned wpxp123456 Nov 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants