ExportToSpreadsheet hangs when using ";" as delimiter

Since my Excel version uses “,” instead of “.” as decimal point I wanted to use “;” as column delimiter in ExportToSpreadsheet, but when I do that CellProfiler continues this operation infinitely. I have tried using just a simple pipeline only containing MeasureImageIntensity and ExportToSpreadsheet. When using “,” as column delimiter it works fine. I am running CP 2.1.0 (rev b4df8ea).


This is indeed a bug, which will be fixed for the upcoming release. As a workaround, you can use the tab as a delimiter if you must use a non-comma character. However, if you do so, you should either give the file the extension “.tsv” so Excel loads it properly or, barring that, follow the instructions here.