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

Formula: -<function> format yields 0 instead of expected value #1319

Closed
thomascharbonnel opened this issue Aug 16, 2022 · 2 comments
Closed
Labels
confirmed This issue can be reproduced

Comments

@thomascharbonnel
Copy link
Contributor

Description

When creating formulas such as -<function>, the result always becomes 0 rather than -1 * <function>.
-1 * <function> works but Excel properly supports -<function> too.

Steps to reproduce the issue:

  1. Create a formula in Excel such as =-COS(0)
  2. Calculate the cell using Excelize

Describe the results you received:

0

Describe the results you expected:

-1

Output of go version:

go version go1.18.3 linux/amd64

Excelize version or commit ID:

master

Environment details (OS, Microsoft Excel™ version, physical, etc.):

Running Excelize on Linux.
Excel v. 2108 on Windows.

@xuri xuri added confirmed This issue can be reproduced in progress Working in progress labels Aug 16, 2022
@xuri xuri closed this as completed in d1e76fc Aug 17, 2022
@xuri
Copy link
Member

xuri commented Aug 17, 2022

Thanks for your feedback, this issue was caused by commit 0f7a0c8, and I have fixed it, please upgrade to the master branch code.

@xuri xuri removed the in progress Working in progress label Aug 17, 2022
@thomascharbonnel
Copy link
Contributor Author

Thank you for your help!

rodoard pushed a commit to sheetrocks/excelize that referenced this issue Aug 26, 2022
…e symbol

- Update unit test and comment for the functions
xuri added a commit to carbin-gun/excelize that referenced this issue Oct 9, 2022
…e symbol

- Update unit test and comment for the functions
xuri added a commit to JDavidVR/excelize that referenced this issue Jul 11, 2023
…e symbol

- Update unit test and comment for the functions
jenbonzhang pushed a commit to jenbonzhang/excelize that referenced this issue Oct 22, 2023
…e symbol

- Update unit test and comment for the functions
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
confirmed This issue can be reproduced
Projects
None yet
Development

No branches or pull requests

2 participants