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

#ERROR! when using a non-breaking space character inside formula #898

Closed
sequba opened this issue Feb 9, 2022 · 0 comments · Fixed by #935
Closed

#ERROR! when using a non-breaking space character inside formula #898

sequba opened this issue Feb 9, 2022 · 0 comments · Fixed by #935
Assignees
Labels
Bug Something isn't working Released

Comments

@sequba
Copy link
Contributor

sequba commented Feb 9, 2022

As described in #877 by MartinDawson:

In our spreadsheet we use a contentEditable div. We parse the text using chevrotain's lexer to find the cells to highlight. Like so:

image

When we access the content using .textContent it seems to replace all spaces with non-breaking spaces.

This should be fine because hyperformula should replace ANY space. However it's missing non-breaking spaces from the regex:

pattern: /[ \t\n\r]+/

Hyperformula's lexer was returning #ERROR! due to this.

So it should be /s+ instead.

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
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants