Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # 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.

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
Bug Something isn't working Released
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants