Blank space in a excel export

[FRAN1972]

Hie,
I have done a list of numbers and a export of that numbers to excel. The problem is that in excel in the place of one value appears a blank space and i don´t understand why. In the the second column appear 105.27, in the fith appear 108.64 but in the eighth not appear 111.11 and appear a blank space. Somebody knows what happen? Somedody knows how i can check in which list star the value null? I try with the way that i show but it not function.
Thanks a lot.

[_Vijay]

Round the values before export.

[Mark.Ackerley]

Hey,

Maybe this is useful?

Cheers,

Mark

[Jean-Marc]

Hey hey,
replacing nulls by a 0 value should do the trick

[Jean-Marc]

Trying to change a NULL parameter value

Try this [image]

[FRAN1972]

Thanks a lot. I try it but appear the blank space also.
Regards

[FRAN1972]

Thanks. The problem is that in Dynamo the value exist but in one moment it dissapear. Do yo know how i can locate the item with null value in a list?
Regards

[FRAN1972]

Thanks. The problem is that in Dynamo the value exist but in one moment it dissapear.
Regards

[Jean-Marc]

I can see from the table that the data is offset because of null values. try following the steps in the post links I gave earlier to identify and replace nulls.

[Mark.Ackerley]

Hey,

I would try and make a simple example to test… One you could post here?

Sometimes the null is because of transpose nodes… If there are different amounts of values you get nulls to make the list lengths the same…

Hope that helps,

Mark

[FRAN1972]

Thanks. I think so but i couldn´t find the problem.
Regards.

[FRAN1972]

Hie,
I think that i found the origin of the problem. I have three list with 4920 elements but the combine list only have 14758 instead of 14760 but i don´t understand why

Regards

[Mark.Ackerley]

What happens if you look at the values which are giving the nulls? 2800 or whatever?

[FRAN1972]

HIe,
The problem appears in the 2890 item.
Regards

[Mark.Ackerley]

Sure, but the value which is generating the null… the 3 values coming from the Math.Round nodes? Are they also null? If so, work back again…

[FRAN1972]

Hie,
The origin is the List.flatten node on the left but there there isn´t null value and for that ithink that the problem is in the combine node.
Regards

[Mark.Ackerley]

Hey,

So this makes a null? Is it possible you have the same?

I think making the problem simple is going to help…

Cheers,

Mark

Edit: If you use Create and Transpose it helps identify the problem…