-
-
Notifications
You must be signed in to change notification settings - Fork 1.7k
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
Labels
confirmed
This issue can be reproduced
Comments
xuri
added
confirmed
This issue can be reproduced
in progress
Working in progress
labels
Aug 16, 2022
Thanks for your feedback, this issue was caused by commit |
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
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:
=-COS(0)
Describe the results you received:
0
Describe the results you expected:
-1
Output of
go version
:Excelize version or commit ID:
Environment details (OS, Microsoft Excel™ version, physical, etc.):
Running Excelize on Linux.
Excel v. 2108 on Windows.
The text was updated successfully, but these errors were encountered: