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.
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:
- Select the column where the custom function is applied.
- Copy the selected cells (
Ctrl + C
). - Paste as values (
Ctrl + Shift + V
or use “Paste Special” → “Values Only”). - 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