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.75k stars 1.07k forks source link

CELL function does not work with localized parameters #1369

Open Prometheus3375 opened 3 years ago

Prometheus3375 commented 3 years ago

This issue is unique.

Operating System

Windows 10 / 8.1 / 7

Version information

6.3.1.56

Expected Behavior

From documentation supplied with desktop app (in Russian):

image

So, ЯЧЕЙКА("имяфайла") must return file name.

Actual Behavior

At first, CELL always require second parameter, although it is marked as optional:

image

OK, let's put second parameter as B1:

image

Value error is generated.

Let's replace имяфайла with filename:

image

Now it works.

Reproduction Steps

  1. In settings select Russian language for formulas.
  2. Create new sheet.
  3. Select A1 and type =ЯЧЕЙКА("имяфайла").
  4. Observe an error that you need to specify second parameter.
  5. Select A1 and type =ЯЧЕЙКА("имяфайла"; B1).
  6. Observe Value Error in A1.
  7. Select A1 and type =ЯЧЕЙКА("filename"; B1).

Additional information

No response

VladimirProkofiev52 commented 3 years ago

Hello. @Prometheus3375, I can confirm - this is bug, issue 51662 and 51666 in our private issue tracker. Thank you for report.

Rita-Bubnova commented 3 years ago

Problem reproduces in Document Server.

ShockwaveNN commented 3 years ago

Moving this issue to DocumentServer repo, since it's our base product and problem actual there too

VladimirProkofiev52 commented 7 months ago

Hello. @Prometheus3375, This issue will be fixed in the next release. Please wait for updates.

VladimirProkofiev52 commented 7 months ago

@Prometheus3375 I want to clarify that we've fixed the problem 51662 concerning the display of cell width using a formula. This issue has been addressed in the commit. However, issue 51666 is still outstanding and needs further attention.