How to control data streaming? [closed]

asked 2014-06-19 08:37:28 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi all, Greetings of the day. I have a task to complete using LO calc in which I have to use data streaming. But, the application requires to do some work every time data is streamed in. Say, DataSet-1, DataSet-2, ..., DataSet-N is getting streamed in to a range of cells, say A1:Z100. Now, when the DataSet-1 is streamed in completely to the sheet to range A1:Z100, I have to block DataSet-2 to stream in till I complete the work. Once the work is done, DataSet-2 should be streamed in to the range A1:Z100. Once Data Stream-2 is streamed in completely, again block DataSet-3 to stream in and do the work. This goes till all N DataSets are streamed in. I searched a lot to know how to control data streaming and ended up in helplessness. Can anyone help me how to control data streaming? Even doing it through macro is fine.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-25 22:14:03.788608