COUNTBLANK not working with createEmptySpreadsheetData

Getting help Issues
,
1

Looks like COUNTBLANK function only works when cells are null, but not when they are empty strings.

If I use data: Handsontable.helper.createEmptySpreadsheetData(20, 8) to create a table and insert this:

=COUNTBLANK(A1:A10)

It returns 0.

Here an example:

2

Hi @nicola

We don’t recommend using the internal helpers as their main purpose is to speed up our development process and they are not included in the official API, so they can be changed or removed without any notice.

If you want to create a table with empty data we recommend using startRows and startCols options. I modified your example here, and the formula works correct then: https://codesandbox.io/s/festive-hooks-t01i0p