Output of a table's name

Docs
1

I want to generate a table’s name as an output within a table-sheet.

In Excel it works like: =TEIL(FORMELTEXT(A1);2;FINDEN(“[”;FORMELTEXT(A1))-2)

So if the sheet is called “sheet1” the output within this cell will be “sheet1”

Is there a formula for oo to generate to generate the same output?

3

Hi @hoc :wave:

Can you try this formula:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

4

Hi Nikolas, using your formula creates an error message “The formula contains an error. Wrong arguments count used”.

5

@hoc
What version of the editor do you have and what formula language is being used?

image
image875×833 29.9 KB

7

Hallo Nikolas, thank you, Problem solved. I changed language to english, used your formula and it worked. Changing back the language showed me the right german solution: =TEIL(ZELLE(“filename”;A1);FINDEN(“]”;ZELLE(“filename”;A1))+1;255)

8

:eyes:

Hey @hoc
I need to clarify one point:

When updating the table (F9), does the formula work correctly?

=TEIL(ZELLE(“filename”;A1);FINDEN(“]”;ZELLE(“filename”;A1))+1;255)

10

Hey @hoc

We have reproduced the issue and created a bug report regarding the behavior of this formula in languages other than English.

12

Perfect, thank you!

1 Like
13

Hey @hoc :wave:

I wanted to inform you that ONLYOFFICE Docs v8.1.0 has been released, and the bug has been fixed.

For more details and the full list of new features in version 8.1.0, please refer to the changelog: Version 8.1.0 Changelog.