Issue with formulas converting using Convert to File

When converting json data to an Excel (xlsx), formulas are not applied, they are simply shown as Text
image

Example workflow:

Information on your n8n setup

  • n8n version: 1.34.2
  • n8n EXECUTIONS_PROCESS setting (default: own, main): DEFAULT
  • Running n8n via (Docker, npm, n8n cloud, desktop app):DOCKER
  • Operating system: Linux

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

Hi @AlbertoGrifols

Thanks for posting here and welcome to the community! :tada:

Can you check your excel’s formatting for the cells? You might actually have to change the format to ‘Automatic’ for excel to recognize them as formulas.

Also, maybe you have a different regional setting than me, but doesn’t the syntax use : colon instead of ; semi-colon? So, =SUM(B2:C2) instead of =SUM(B2;C2) ?

:thinking:

Hey, no, I already checked a lot of ways through Excel and LibreOffice Calc. Both do not work. Formulas are inserted as Text instead of as a Formula, so for Excel to recognize them you need to go inside the cell and press Enter so it recalculates the cell value and detects it as a Formula.

On SUM afaik you can use both semicolon and colon, and they do mean different things. Semicolon is like a separator, maybe you use simple commas because on some languages the decimal point separator is a comma and not a dot.

If you replace it with a colon it will have the same problem, shows as Text, n8n must be escaping it as text and not inserting as a formula or something similar.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.