Limitations with Data Streamer

%3CLINGO-SUB%20id%3D%22lingo-sub-3009374%22%20slang%3D%22en-US%22%3ELimitations%20with%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3009374%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20am%20trying%20to%20use%20Data%20Streamer%20to%20do%20simple%20data%20exchange%20with%20an%20MCU%20via%20a%20serial%20port.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20would%20like%20to%20send%20a%20csv%20packet%20to%20the%20MCU%20and%20get%20the%20csv%20it%20will%20reply.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20made%20a%20basic%20Excel%20application%20with%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhat-is-data-streamer-1d52ffce-261c-4d7b-8017-89e8ee2b806f%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhat-is-data-streamer-1d52ffce-261c-4d7b-8017-89e8ee2b806f%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBut%3A%20%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSPAN%3EWhen%20%22Start%20Data%22%20is%20off%2C%20the%20content%20of%20%22Data%20Out%22%20is%20sent%20when%20there%20is%20a%20change%20but%20%22Data%20In%22%20is%20not%20updated%20and%20%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EWhen%20%22Start%20Data%22%20is%20on%2C%20%22Data%20In%22%20is%20updated%20but%20%22Data%20Out%22%20is%20repeated%20on%20every%20update.%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20there%20a%20way%20to%20have%20%22Data%20In%22%20updated%20and%20%22Data%20Out%22%20is%20sent%20only%20when%20there%20is%20a%20change%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3009374%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3022738%22%20slang%3D%22en-US%22%3ERe%3A%20Limitations%20with%20Data%20Streamer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3022738%22%20slang%3D%22en-US%22%3EA%20partial%20solution%20I%20found%20is%20to%20turn%20off%20the%20automatic%20calculation.%3C%2FLINGO-BODY%3E
Occasional Contributor

I am trying to use Data Streamer to do simple data exchange with an MCU via a serial port.

I would like to send a csv packet to the MCU and get the csv it will reply. 

 

I made a basic Excel application with https://support.microsoft.com/en-us/office/what-is-data-streamer-1d52ffce-261c-4d7b-8017-89e8ee2b806....

 

But:

  • When "Start Data" is off, the content of "Data Out" is sent when there is a change but "Data In" is not updated and
  • When "Start Data" is on, "Data In" is updated but "Data Out" is repeated on every update.

 

Is there a way to have "Data In" updated and "Data Out" is sent only when there is a change?

 

Thanks

1 Reply
A partial solution I found is to turn off the automatic calculation.