I’m playing around with streaming data from Bumblebee into an excel spreadsheet. The live update is great and it all works great, but I am noticing a problem when data is removed from the spreadsheet. For example, Here is my first output in excel:
now I add some more levels, so this is what I get, still good:
But now, if I want to remove levels from the building, the spreadsheet updates, but it doesn’t remove the lines of data that no longer apply:
Is there a way to get it clear unused data as it updates?