Topic on Extension talk:JsonConfig/Tabular

"Edit as table" doesn't keep null values

3
Julio974fr (talkcontribs)

The "Edit as table" button replaces the null values for numbers with 0s, which is a problem for some cases where null values actually mean "empty cell". Can anything be done about it?

PerfektesChaos (talkcontribs)

Well, these are only rectangular tables with strict typing.

If strictly typed an element in a numeric column is not permitted to have any other value than numeric, and null is of different type than numeric.

If you want to specify explicitly irregular data you might need -1 or -9999 or -1E99 and check for them.

Julio974fr (talkcontribs)

But then there is a problem, because it is then possible to click "edit as table", exit it after doing nothing, and the null values will be erased. There needs to be an exception for it to read empty cells as "null". And I can't use other values for irregular data either without changing the Graph templates, which themselves need to accept any numeric value.

Reply to ""Edit as table" doesn't keep null values"