And when a data type mismatch is encountered during an import, SOFA now reports on the first faulty cell (row, cell value, and expected type) to make it easier for to clean your data.
In addition, here are the other features added in this release:
- Now able to run multiple single line charts. And multiple line charts have a consistent y-axis for role as trellis charts.
- SOFA now guesses whether an xls or ods spreadsheet has a header row or not when importing and sets the default buttons accordingly.
- Tighter and more flexible spacing of x-axis title according to number of lines in x labels. Now show legend title before legend and only show legend if multiple series.
- Smarter column resizing.
- CSV importing correctly identifies if file has a header more accurately if only one column (and thus no delimiter identified initially).
- Adjusted chart sizings to be more rational and less magic.
- Better width settings for dojo histogram output when lots of bins (prevents x-axis labels bunching up).
- Row stats tables show “Not calc” instead of nan (not a number) when appropriate.
And there are some important bug fixes as well:
- Fixed bug encountered when importing spaces in fields.
- Fixed bug when missing values in some fields in a boxplot with multiple series.
- Table design changes now cope with pre-existing sofa id index and demo values no longer updated on exit (inadvertently via on_show event).
- Fixed bug in tooltip display of averages in general charts – no longer rounds to lower integer.
- Charts of averages don’t show percentages in tooltips.
- All matplotlib histograms, including those in stats display such as for one-way ANOVAs, now cope with sigma of 0.
- Fixed bug calculating percentages where all values in a chart (of a series) are 0.
- Fixed bug in showing rotate when changing to clustered bar charts.
- Fixed bug in ods importing where display of sample values didn’t include repeated cells (only showing the first value).
- SQLite now correctly identifies more types as numeric.
I hope you like it.