Files with .txt suffix won't open as spreadsheet in Symphony or Open Office
Ok, Granted this isn't a fault of either JazzMon or either of the mentioned products. But my experience is that
.txt files are opened as "write" documents. However, one can avoid that by creating a work sheet from a file.
Create > Sheets...
Choose From File in the lower part of the dialog. Both Symphony and Open Office provide this.
A bit more work for us, but easier than renaming all those .txt files....
Just a tip. Maybe the JazzMon will provide means of creating the files with .csv which import directly.
.txt files are opened as "write" documents. However, one can avoid that by creating a work sheet from a file.
Create > Sheets...
Choose From File in the lower part of the dialog. Both Symphony and Open Office provide this.
A bit more work for us, but easier than renaming all those .txt files....
Just a tip. Maybe the JazzMon will provide means of creating the files with .csv which import directly.
Accepted answer
JazzMon 1.3.0 was just released and now generates comma separated CSV files that are more easily imported into both Symphony and Excel.
The release also includes standard formulas on each line that can be used to sort and filter data; these compute totals, max values, averages and the ratio of the average to the baseline. Since there is some difference in formulas between Symphony and Excel, a new property is provided that identifies the target spreadsheet program to address this difference so the new features will work in both spreadsheet applications.
The release also includes standard formulas on each line that can be used to sort and filter data; these compute totals, max values, averages and the ratio of the average to the baseline. Since there is some difference in formulas between Symphony and Excel, a new property is provided that identifies the target spreadsheet program to address this difference so the new features will work in both spreadsheet applications.
One other answer
Unforunately Excel only interprets .csv files as comma separated and will misread tab-separated data like what JazzMon produces. It will ask what the separator is when reading in .txt files.
Symphony on the other hand will ask what separator to use when reading .csv files but not .txt files.
We'll review how we could improve the situation for Symphony users in the future.
Symphony on the other hand will ask what separator to use when reading .csv files but not .txt files.
We'll review how we could improve the situation for Symphony users in the future.