Set up formula (hyperformula) in columns settings

Tags: #<Tag:0x00007efc6525bad0> #<Tag:0x00007efc6525b940>
#1

I’m trying to add a simple formula to a column like this:

{type: “numeric”, formula: ‘=A1+B1’}

I’m not sure if this is even the correct way of doing this. my goal is that every cell in this column contains this formula after table creation. the cells are always empty though. Hyperformula seems to be setup correctly, at least it works if I type in the formula by hand or put it in the table as a value in data. I really don’t want to do that though.
What might I be doing wrong here?

#2

Hi @notaflyin

Formulas are a part of data, they cannot be defined in the columns settings. You’d need to modify the data array to contain those values. Here’s an example https://jsfiddle.net/m4twhb3x/

Would that meet your project requirements?

#3

Hi Aleksandra,

Thank you for the quick reply.
I really was hoping to be able to get around Putting the Formulars in the data but if thats the only Option ibwill make it work for my project.
Thanks again for clearing that up.

1 Like
#4

You’re welcome.

I’ll close this topic as solved. However, feel free to open a new one when needed.

#5