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

Specified Cast is not Valid When Doing Sum Formula #630

Closed
megamorphg opened this issue Sep 27, 2022 · 1 comment · Fixed by #632 or #660
Closed

Specified Cast is not Valid When Doing Sum Formula #630

megamorphg opened this issue Sep 27, 2022 · 1 comment · Fixed by #632 or #660
Assignees
Labels
bug Something isn't working released Available in a released installer

Comments

@megamorphg
Copy link

Describe the bug
There is an issue when I do a simple formula calculation like this and I get "Cast is not valid error" when doing sum(C2:C6)
image
image
image

To Reproduce
Steps to reproduce the behavior:

  1. Create table as above
  2. Create formula on 3rd column as shown.

Expected behavior
Sum formula should work with simple numbers. Would be even better if can do a column formula like sum(C:C) so can keep adding rows without changing the formula

Screenshots
Sum formula does not work with simple numbers

Environment (if applicable):

  • OneNote Version: O365
  • OneMore Version 5.1

Additional context

@megamorphg megamorphg added bug Something isn't working unread I have seen it or had time to refine it yet labels Sep 27, 2022
@stevencohn stevencohn added developing Accepted and development is in progress and removed unread I have seen it or had time to refine it yet labels Sep 27, 2022
@stevencohn stevencohn self-assigned this Sep 27, 2022
@stevencohn stevencohn linked a pull request Sep 27, 2022 that will close this issue
@stevencohn stevencohn added next-release Addressed but not yet released and removed developing Accepted and development is in progress labels Sep 27, 2022
@stevencohn
Copy link
Owner

Temporary workaround until this is released - enter zero in the empty cells. Not great, I know, but will get you going.

@stevencohn stevencohn added released Available in a released installer and removed next-release Addressed but not yet released labels Sep 29, 2022
@stevencohn stevencohn reopened this Oct 11, 2022
@stevencohn stevencohn linked a pull request Oct 11, 2022 that will close this issue
@stevencohn stevencohn added next-release Addressed but not yet released released Available in a released installer and removed released Available in a released installer next-release Addressed but not yet released labels Oct 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working released Available in a released installer
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants