Question regarding features of RevoGrid Pro

[local-interloper]

Hello, I am currently working on a project for a company. I need to implement an excel like datasheet onto a webapp and I was looking into RevoGrid. The task requires formula support and I've noticed that RevoGrid uses formulajs for interpreting those. I have 2 questions tho.

1. Does it have support for drag and select to enter cell blocks into the formula?
2. Does the Excel export calculate the values produced by the formulas and export the values themselves instead of formulas?

[m2a2x]

Hi @local-interloper

1. No, it doesn't support it, formula plugin at the moment is working as linker between cells based on formula. You can enter data in the cell and link it with data in other cells across the grid and formulajs is used on top to provide you with a lot of different formula options. We have a plan to make it as excel when you have a cell opened and select a range for your formula but this would require some work. Our priority at the moment is Pivot Grid. Later we'll focus on it too. There is so much features we can do but we limited with resour
2. Yes, we provide basic formula parsing during excel export

If you have any questions or suggestions around our pro version don't hesitate to ask, I'll try respond asap.

Thanks