search

ONLYOFFICE / DocumentServer

ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.
https://www.onlyoffice.com
GNU Affero General Public License v3.0
4.81k stars 1.08k forks source link

Spreadsheet: Cells containing nbsp (non-breaking space) are missing average, min, and max status bar calculations #2741

Open XP1 opened 4 months ago

XP1 commented 4 months ago

This issue is unique.

Operating System

Linux (RPM package)

Version information

8.0.1.31

Expected Behavior

Selected cells with whitespace should have average, min, and max calculations in status bar.

OnlyOffice Spreadsheet nbsp bug

Actual Behavior

Selected cells are missing average, min, and max calculations in status bar. Only count in status bar.

Reproduction Steps

1) Copy and paste into a spreadsheet:

$1   $2   $3   $4  

Source:

<p>$1 &nbsp;<br>$2 &nbsp;<br>$3 &nbsp;<br>$4 &nbsp;</p>

2) Select the cells. 3) Observe missing calculations in status bar.

Additional information

No response

rsnegirev commented 4 months ago

Hi @XP1

I can confirm, this is the bug number 68178. When some fixes will be done we'll text you here in this issue.

And we're moving this issue to DocumentServer repo, since it's our base product and problem actual there too.

Thank you for the report!

sunhunter777 commented 1 month ago

It seems that this addition also applies here. If a normal space is set between the digits of numbers, the number is perfectly perceived in formulas. However, numbers with a non-breaking space as a separator of digits lead to errors in formulas