Data Streamer - Option for the data orientation from the settings sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-738328%22%20slang%3D%22en-US%22%3EData%20Streamer%20-%20Option%20for%20the%20data%20orientation%20from%20the%20settings%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738328%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%0A%3CP%3Ethe%20Data%20Streamer%20Add-In%20%3CSTRONG%3Ecreates%3C%2FSTRONG%3E%20some%20worksheets%20as%20soon%20as%20I%20connect%20e.g.%20a%20CSV%20file%20for%20streaming.%20The%20last%20sheet%20of%20these%20created%20sheets%20contains%20some%20settings.%20There%20is%20one%20setting%20%3CEM%3EData%20orientation%3C%2FEM%3E%2C%20in%20German%20%3CEM%3EDatenrichtung%3C%2FEM%3E%2C%20which%20refers%20to%20an%20Excel%20data%20validation%20and%20which%20is%20statically%20set%20to%20two%20strings%2C%20separated%20by%20a%20comma%20-%20the%20English%20default%20list%20separator.%20This%20will%20not%20work%20in%20a%20German%20version%20of%20Excel%2C%20as%20the%20default%20list%20separator%20is%20a%20semi-colon%20instead%20of%20a%20comma.%20For%20a%20German%20Excel%20version%2C%20it%20looks%20like%20the%20following%20screenshot.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122208i53CB4026D41C642E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20two%20options%20are%20concatenated.%20If%20you%20edit%20the%20data%20validation%20and%20replace%20the%20comma%20by%20a%20semi-colon%2C%20it%20works%20again.%20My%20suggestion%20would%20be%20to%20place%20the%20strings%20in%20a%20range%20and%20then%20referenciate%20the%20range%20from%20the%20data%20validation%20and%20therefore%20make%20it%20language%20independent.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAdditionally%2C%20for%20German%2C%20there%20is%20an%20error%20in%20the%20translation%20for%20the%20options%2C%20which%20should%20be%20%3CEM%3ENeueste%20zuerst%3C%2FEM%3E%20and%20%3CEM%3ENeueste%20zuletzt%3C%2FEM%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBest%2C%3C%2FP%3E%0A%3CP%3EMourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-738328%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EData%20streamer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
MVP

Hi there,

the Data Streamer Add-In creates some worksheets as soon as I connect e.g. a CSV file for streaming. The last sheet of these created sheets contains some settings. There is one setting Data orientation, in German Datenrichtung, which refers to an Excel data validation and which is statically set to two strings, separated by a comma - the English default list separator. This will not work in a German version of Excel, as the default list separator is a semi-colon instead of a comma. For a German Excel version, it looks like the following screenshot.

 

image.png

 

The two options are concatenated. If you edit the data validation and replace the comma by a semi-colon, it works again. My suggestion would be to place the strings in a range and then referenciate the range from the data validation and therefore make it language independent.

 

Additionally, for German, there is an error in the translation for the options, which should be Neueste zuerst and Neueste zuletzt.

 

Best,

Mourad

0 Replies