SOFA Statistics full changelog

Box plots can be displayed with different outlier and whisker display options. ODS importing can now cope with repeated column names. Better error message when unable to get regression line details because of limited variability.
Bug fixes:
Fix bug when problem with imported data. Fix to title and date concatenation code so doesn't break when title has non-ascii characters e.g. in Spanish (affecting Windows and Mac) Reordered regression line plotting in js so appears on top of dots. Added zero division error trap to spearman's test error output. Fixed bug which prevented ods_reader from importing repeating rows at the end of a spreadsheet. Only repeated empty rows at the end are considered the end of the data. Properly handle all read operations on internal-use text files e.g. proj, css etc. Can cope with a utf-8 BOM (only) to cope with Windows Notepad editing. Breaks if other encodings used which is fair enough.

Fix bug resulting in Pearson's r being displayed instead of Spearman's rho.
Fixed bug on some systems when saving a worksheet with spaces in name.
Prevented numerous bugs related to quoting table names, fully qualified file names etc.

Can import tab-delimited data.
More options for attractive charts and reports. Three new themes available - sky, prestige (screen), and prestige (print).
Better support for automation (i.e. headless, running without GUI) esp in international context.
Exporting to spreadsheet now relies on more robust code library (xlwt)
Easy to select or deselect lots of row stats measures at once.
Faster opening in many cases.
Bug fixes:
Minor tweak to PostgreSQL plug-in to handle timestamps without timezone.
Resolved bug when SQLite numbers are stored in a non-numeric field and processed for Chi Square test.
Importing csvs now copes better when only missing vals in sample of a field. Gives user the choice.
Fixed bug when doing a Row Stats table with a rows variable e.g. by Gender and some of the fields can't be calculated for some of the row categories.
Headless importing now works in the event of inconsistent data types in fields.

Fixed bug introduced in 1.4.1 which stopped SOFA working with MS Access databases.
Fixed misc bugs associated with sort order of value labels when configuring a variable. Default project path for sofa_db connection now copes with paths containing single quotes e.g. Grant's Machine.
Fixed bug which occurs when running scripts directly in a non-English locale. The locale folder stored in the script is now the one the GUI identified as the correct one. So translated config e.g. for Mean, Sum etc will match what it should.

Cleaner interface for viewing, saving, and exporting output. Data export to spreadsheet plug-in now automatically exports as csv as well as xls. Data importing copes with spaces at the end of dates - trailing spaces are removed and the value is treated properly as a date.

Fixed bug in histogram output when limited data spread. Error caused by miscalculation of significant decimal points required for display.
Fixed bug stopping late-added title details appearing when exporting output. The demo output is refreshed first so the source file is forced to be up-to-date. Probably needs a proper tidy-up some day but this works well in the mean time.
Fixed bug in exporting to desktop folder in fix_pdf - need to strip end off folder name when no AM/PM under localisation used.
Fixed various bugs associated with exporting output. When copying output, message about keeping form open now names form it means (to reduce confusion).
Fixed bug when using a project after it has just been deleted (by pressing cancel in select projects dialog after having deleted the currently active project).
Fixed bug which meant quot;Show Resultsquot; and quot;Add to reportquot; options were displayed when setting up a project.
Fixed bug when cancelling a variable details selection in a project.

Bug fixes:
· Fixed bug with calculation of mean with MS SQL Server data (now explicitly cast as float to avoid integer result).
· Fixed bug in ANOVA output for precise (as opposed to speed) - it used to try mixing Decimals and other numeric types unsuccessfully.
· Fixed bugs with chart data gathering queries so works in MS SQL Server properly. Also cleaner for the others in any case.
· Fixed bug in underlying code if unique=False ever applied with scatterplots (currently never but it was still, technically, a bug).
· Fixed bug in scatterplot SQL which affected MS Access and MS SQL Server (can't use aliases in group by etc).
· Adjusted y-title position in dojo scatterplots to avoid it being cropped.
· Fixed bug when Postgresql date date being displayed as a category (couldn't calculate a length of a datetime.datetime object).
· Fixed layout bug when report table resized after Add to Report checkbox hidden. Now freshens layout when checkbox reappears.

· 95% confidence intervals now added to ANOVA and t-tests
· Right justified numbers in associated output
· Can now sort by category labels in clustered bar charts, line charts, area charts and box plots
· Area charts can also be sorted ascending or descending by count/mean/sum
· The series and category are now displayed in tooltips e.g. Italy, 20-29 for clustered bar charts, multi-series line charts, and box plots. This is especially helpful when there are lots of categories and/or series
· Improved statistics output footnotes
· Borders on bar-type charts are now optional
· Chi square clustered bar charts can cope with higher default limits for number of values
· Importing field names with more than 90 characters prohibited at the point of import rather than causing problems later
· The group by max number of values is now controlled by a single my_global setting (making it easier to override)
· The default settings for some remaining max values have been increased

· Minor GUI bugs on start screen fixed.

· Fixed code picking optimal min and max axis values for scatterplots and box plots to cope when value range is much smaller than gap to 0.
· CSV import now copes with new lines inside fields when gathering data for sample display.
· Extra settings for Line Charts now display when they should even if only changing data type.
· Fixed bug which allowed line breaks in field names.