ONLYOFFICE
CELL function does not work with localized parameters
This issue is unique.
- [X] I have used the search tool and did not find an issue describing my bug.
Operating System
Windows 10 / 8.1 / 7
Version information
6.3.1.56
Expected Behavior
From documentation supplied with desktop app (in Russian):
So, ЯЧЕЙКА("имяфайла") must return file name.
Actual Behavior
At first, CELL always require second parameter, although it is marked as optional:
OK, let's put second parameter as B1:
Value error is generated.
Let's replace имяфайла with filename:
Now it works.
Reproduction Steps
- In settings select Russian language for formulas.
- Create new sheet.
- Select A1 and type
=ЯЧЕЙКА("имяфайла"). - Observe an error that you need to specify second parameter.
- Select A1 and type
=ЯЧЕЙКА("имяфайла"; B1). - Observe Value Error in A1.
- Select A1 and type
=ЯЧЕЙКА("filename"; B1).
Additional information
No response
Hello. @Prometheus3375, I can confirm - this is bug, issue 51662 and 51666 in our private issue tracker. Thank you for report.
Moving this issue to DocumentServer repo, since it's our base product and problem actual there too
Hello. @Prometheus3375, This issue will be fixed in the next release. Please wait for updates.
@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.