The initialization formula does not trigger a detailed description

Tags: #<Tag:0x00007efc625d3cb0>
#1

handsontable initializes data as empty, the table automatically generates the minimum row of data, and uses setDataAtCell to add the calculation formula. However, the table does not trigger the formula but directly displays characters, which needs to be triggered manually.
image
The code is as follows

image
image.png516×1197 144 KB

#2

Hi @gg2306436660
I am not sure if I set everything the same way, but it seems to work well (formulas are calculated on init). Here’s a demo https://jsfiddle.net/t7684qjz/. I tested it on Chrome 125.

#3

after the formula is displayed in character mode, please help to see

image
image.png1492×647 41.7 KB

#4

Could you send the demo from the screenshot? Maybe we define the setting a bit differently.

#5

You can set the data in the example to empty and then add minRows:1 to the setting to reproduce it

#6

The changed code is as follows：

image
image.png1329×496 20.9 KB

#7

Then it also works https://jsfiddle.net/h7r8cnk0/

Before edit
05

after edit
59

Maybe that is a browser/system difference. I am on macOS venture Chrome 125.

#8

You try to change the code here in hotSettings, see what happens

image
image.png761×397 14.2 KB

#9

The use case you gave did not use the minRows: attribute

#10

The use case you gave did not use the minRows: attribute

Yes minRows are in line 26

#11

But the component uses hotSettings instead of settings

#12

Please try it according to my screenshot

#13

Just now I set the data to [[]], which can be solved, but I expect the data to be a []

#14

Handsontable is either an array of arrays or objects. A simple array is not a valid value.

Would you like to start with no data, only headers?

#15

I want to display no data, just the title, if I set minRows, the formula can be displayed normally

#16

There is no way to solve this problem

#17

Hi @gg2306436660

I asked my colleague for help and it seems that we agree on the fact that

  • we did not get the full specification
  • we should get a demo from you with your settings (can be sandbox or .zip)

to help with this case.

#18

You don’t need me cases presented here and the environment, https://jsfiddle.net/h7r8cnk0/ can reappear the problem to the case, just need to set up according to what I said, can be recurring problems.

#19

Could you please set it up as you have it? This way we will avoid any misunderstandings. Once you alter the demo just use FORK and you will be given a new URL.

#20

I copied a, trouble you can look at: https://jsfiddle.net/enkang/uqazbj3k/26/