Bug Report: Custom Function Error (#NAME?) When Exporting to PDF

FORMS
1

Bug Report: Custom Function Error (#NAME?) When Exporting to PDF

Software: ONLYOFFICE version 8.3.1.25 (deb)
OS: Arch Linux lts Kernel

Description of the Issue

I created a custom function in OnlyOffice Spreadsheet that works perfectly within the document. However, when I export the file to PDF, all cells using this function display a #NAME? error instead of the expected output.

:point_right: Custom Function Source Code: Number to Words Conversion for OnlyOffice (=NOMBREENLETTRES)

Possible Causes

  • Custom functions are not recalculated during the export process.
  • The function is missing or not recognized when exporting.

Workaround

Until this issue is resolved, a temporary solution is to convert the function results to values before exporting:

  1. Select the column where the custom function is applied.
  2. Copy the selected cells (Ctrl + C).
  3. Paste as values (Ctrl + Shift + V or use “Paste Special” → “Values Only”).
  4. Proceed with exporting the file to PDF.

Additional Details

I have recorded a demonstration of this issue, which I am attaching to this post for better understanding.

Many thanks for your great work

2

@Yassine :hugs:

Thank you for reporting this issue :heart_hands:
We are already investigating the problem. As soon as we have any updates or further information, I will let you know.

1 Like
4

Hey @Yassine :wave:

We have created a bug report regarding this issue with custom functions displaying #NAME? when exporting to PDF.
Once the issue is fixed, we will update you in this post. Thanks again for your feedback!

1 Like