[GNC-dev] GnuCash 3.3 Released
jralls at ceridwen.us
Sun Sep 30 16:42:38 EDT 2018
The GnuCash development team announces GnuCash 3.3, the fourth release of the 3.x stable release series.
Between 3.2 and 3.3, the following bugfixes were accomplished:
• Bug 771667 - Different warnings when changing reconciled splits vs. splits linked to reconciled splits.
• Bug 784420 - "Save changes on closing" window waits 2^32 seconds when "Time to wait for answer" is set 0.
• Bug 786708 - GnuCash won't load currency fractions larger than 1000000. Also create larger fractions for the account dialog.
• Bug 787439 - Segmentation Fault in Transfer dialog after clearing Date field and pressing escape.
• Bug 789594 - Unable to overwrite sqlite3 database file.
• Bug 792446 - Mixed languages in error dialog.
• Bug 794526 - Python bindings can't find loadable modules.
• Bug 794755 - Commodity Register displays fractional prices.
Prices will now be displayed in decimal, rounded to two more places than the currency's smallest unit.
• Bug 794870 - If no book is opened, gnucash still asks if the user wants to save changes when opening a file.
• Bug 795821 - GnuCash could not obtain the lock for file://C:\Users\username\Documents\GnuCash\2.6.21\xxxx\xxxx.gnucash
• Bug 796054 - Unposting and reposting invoice doubles amounts.
• Bug 796137 - query.search_for outputs critical qof.object errors and prevents queries being run.
• Bug 796248 - Editing Scheduled Transaction.
In addition to not begining to edit already-loaded transactions, don't try to load splits that are already loaded. It shouldn't be possible to load a transaction without also loading its splits.
• Bug 796474 - Segmentation fault while setting up online banking.
Allow only a single instance of the assistant.
• Bug 796509 - Saved reports don't respect *some* 'Edit report options'.
• Bug 796579 - Cannot go forward with empty duplicates screen.
• Bug 796665 - Backspace Key Inoperable After Ctrl+V.
• Bug 796669 - Dark Theme Text Colors Hard to Read.
Only add the register-foreground class when using Gnucash built in colours. When this setting not used, the foreground colour by default will be what ever the theme has set and will be down to the user to over ride along with the other register colours.
• Bug 796724 - Can't overwrite gnucash DB on MariaDB.
• Bug 796725 - 4 of 6 Date Posted options fail to return matching transactions.
• Bug 796734 - Auto-complete entry not highlighting to allow for incremental entry.
• Bug 796737 - Patch to restore gncmod-python.c.
• Bug 796739 - Toolbar buttons have no labels.
• Bug 796751 - reconcile window usability - R column should be next to Amount.
• Bug 796755 - buggy window handling at startup.
• Bug 796756 - OFX import fails to recognize associated income accounts.
• Bug 796759 - --add-price-quotes leaves a lock on the file.
• Bug 796762 - Scrollbar partially hides the delete button in the Saved Report Configurations window.
The vertical scrollbar obscures the delete button in the tree view so add a dummy blank column to the end and set it to the width of the vertical scrollbar.
• Bug 796766 - Credit note creating 'imbalance' with wrong entries.
• Bug 796777 - CVE-2008-1391: Integer overflow in included strfmon function.
• Bug 796788 - Strange behaviour in options of multicolumn report.
• Bug 796792 - SaveAs Overwrite dialogue in background and not visible.
• Bug 796812 - gnc_date_cell_get_date and gnc_date_cell_get_date_gdate have different date validation behaviour.
• Bug 796813 - Date validation inconsistent.
• Bug 796814 - Changing a book's read-only threshold doesn't immediately affect open registers.
• Bug 796816 - Notes field in Duplicate Invoice dialogue is 'read-only'.
• Bug 796819 - Bad icon with Spanish localization.
Drop translations of the 'gnucash-icon' string from our po files and add a note for translators to not translate this string or use the literal 'gnucash-icon' as translation.
• Bug 796820 - References to 'Gnome Bugzilla' should be changed to 'GnuCash Bugzilla'.
• Bug 796833 - Excel csv Format misprocessed.
Convert all line ending styles to the one expected by the C++ standard library before starting to parse a csv file.
• Bug 796839 - Find transaction won't filter on Date Posted.
• Bug 796858 - TypeError: in method 'qof_query_int32_predicate', argument 2 of type 'gint32' on gnucash.gnucash_core.QueryInt32Predicate.
The Following fixes and improvemts were not associated with bug reports:
• Set toolbar buttons to show both icon and text.
And make the icon small to recover some vertical screen estate. The motivation for this is that Gtk has dropped the ability for users to change a toolbar's appearance. And as our icons are often less than descriptive many users benefit from having textual descriptions as well. This is the best compromise we can make until the gui gets an in-depth redesign.
• Add preference for forcing prices to decimal display.
Anticipating that some users might prefer to see exact prices, add a preference to General>Numbers to configure whether prices are rounded to decimals or are displayed as exact fractions.
• Revert the "Average Cost" pricing changes made in 2.6.17.
These changes broke trial balances in many books.
• Allow saving to xml over an existing sqlite3 file and the other way around.
• Add customer/vendor ID in client section of invoices.
Partly fixes bugs 430259 and 742086; full fixes would require not-backward-compatible data model changes.
• Change the default filter for General Ledger.
The General Ledger default for the number of days shown is 30 but for the Register it is 0, meaning show all. So change the default filter based on ledger type and use this when determining if the setting should be saved or removed.
• Fix gtk accelerator mixups by explicitly disabling actions that are not relevant.
For example, File->Print and its variants for various page types all use the same '<primar>p' as global accelerator. It was possible to have gnucash invoke the 'Print Report...' action instead of the 'Print Invoice...' action when hitting <primary>p on an invoice page. If no report page was open at this point, gnucash would crash. If a report was open, gnucash would invoke the print action on that report instead of opening an invoice report for the invoice.
• [job-report] Prevent Crash if there is no AR account
• Add the ability to cascade account colours in account tree.
The colour on an account that has sub-accounts can be applied to its sub-accounts; by default only those sub-accounts that don't have a colour set are affected, but there's a preference to override that.
• Speed up loading the preference dialog by blocking register updates until the dialog is fully loaded.
• Update change_tax_code.py, add basic test for python query.
• Simplify GNCQueryView's data model: It was managing a number of redudant parameters which were leaking memory all over the place. The information that was tracked could easily be extracted from the underlying GtkTreeView, GtkTreeModel or GtkTreeSelection when needed.
• Open customer/vendor/employee report when double-clicking an the respective owner the cust/vend/empl overview page.
• Update Overview of README based on https://lists.gnucash.org/pipermail/gnucash-devel/2018-September/042748.html
• Many new tests for reports.
• Some substantial speedups when loading large amounts of business transactions from a SQL backend.
• Clean up a lot of memory leaks.
• Remove all use of Timespec in the program. Provide deprecated wrapper functions supporting timespecs for custom reports; users should update the reports as soonas possible.
The following translations are updated: Farsi, Ukrainian
The following are open bug reports new to the 3.x series considered significant by the development team:
• Bug 788332 - Last Reconcile Date column sorts by day of month not date.
• Bug 791825 - Accounting Period dates (among others) stored with a TZ-sensitive time.
• Bug 793156 - Incorrect sort order in Generic import transaction matcher window.
• Bug 793306 - Price is not imported from CSV.
• Bug 793556 - CSV export/import creates unbalanced transaction for fractional price.
• Bug 794584 - Register not updated when scheduled transactions created.
• Bug 794644 - Remove Old Prices is very slow.
• Bug 794807 - Calendar widget current month shown as (null).
• Bug 795071 - new account entry screen keeps on disappearing and coming back.
• Bug 795253 - Have problems input Chinese.
• Bug 795294 - Can't navigate between tabs using the scroll wheel.
• Bug 795362 - Special variable "i" not parsed in function calls.
• Bug 795383 - Gnucash crashes on import of a 1400-transaction (or more) CSV file.
• Bug 795384 - GnuCash 3 is tremendously memory hungry on macOs.
• Bug 795729 - Advanced Portfolio Report - Percentage rates not displaying leading zeroes.
• Bug 795753 - Initial save into MySQL should use bulk inserts.
• Bug 795804 - Extremely slow save.
• Bug 795961 - CSV importer doesn't match any rows.
• Bug 796100 - Autosave Doesn't Always Work.
• Bug 796122 - Poor Performance Scanning Old Files During Autosave.
• Bug 796492 - Wrong calculation of the first occurrence.
• Bug 796496 - CSV Importer: Column Selectors invisible on Windows
• Bug 796500 - Scalability issue - importing large CSV to large book won't finish.
• Bug 796520 - Layout overlapping in Income & Expense Chart.
• Bug 796656 - GnuCash frequently crashes, usually involving unsaved transactions.
• Bug 796687 - Tax Entity name and type for an account won't work under "Tax Reporting Options" in Gnucash 3.2
• Bug 796688 - "Next" Button Moves Repeatedly During New File Wizard.
• Bug 796698 - Transaction can't be updated on MariaDB 10.2.
• Bug 796728 - GnuCash 3.0-3.2 crashes when starting up under Windows.
• Bug 796736 - Column Widths calculator need to allow more padding.
• Bug 796740 - Selecting register value with mouse fails.
• Bug 796746 - Cannot copy and paste anything into the amount field (both credit and debit)
• Bug 796750 - qof_query_search_for stores pointer of type string argument.
• Bug 796754 - Guile encoding certain strings not as UTF-8.
• Bug 796758 - Improve error messages, why one can not remove a tax table.
• Bug 796761 - Newline (char(10) is inserted into the end of the string if copy & paste text from excel into the description field of transaction.
• Bug 796767 - The importer shows read-only and placeholder accounts.
• Bug 796772 - Receivable Ageing Report invalid URL for Totals column.
• Bug 796773 - Display of Negative numbers.
• Bug 796774 - Investment account QIF Import does not import transaction.
• Bug 796775 - Auto fill not working correctly (only match the first char you type ...)
• Bug 796779 - Window size in SEPA transaction.
• Bug 796782 - Cannot import OFX file in new 3.2.
• Bug 796789 - Unable to access mounted USB sticks and/or network locations from File Open/File Save As dialogs Ubuntu/Linux Mint.
• Bug 796790 - Crash on MacOS on brand new installation without any transactions entered yet.
• Bug 796799 - After Deleting Transaction Price, Enter Required 2x.
• Bug 796804 - Nonenglish characters problem in Book Options.
• Bug 796806 - Crash after OFX import if line item dragged.
• Bug 796810 - Account creation and editing dialogs do not allow entering umlaut-u.
• Bug 796824 - took more than 2 hours to import 220 transactions.
• Bug 796842 - Add new employee window may not fit on screen.
• Bug 796844 - Amount column of Customer Report should net Credits and Debits.
• Bug 796847 - Error trying to do CSV import doesn't recognize account specification.
• Bug 796849 - Load another QIF file causes "that file already loaded" dialog.
• Bug 796850 - Auto-decimal-point causes incorrect price to display when amount is edited.
• Bug 796857 - Import of QIF duplicates transfer transactions.
• Bug 796867 - GNUCash crashes on startup with Mac Mojave 10.14 Dark mode.
• Bug 796869 - Find Transaction Description pulldown does not work.
• Bug 796870 - Cannot (occasionally) undo invoice billing.
• Bug 796871 - Some file chooser buttons don't understand UNC paths on Windows.
Concurrent with the release of Gnucash 3.3 we're pleased to also release a new version 3.3 of the companion Help and Tutorial and Concepts Guide.
• Bug 777893 - Add information to Guide about file formats, esp. SQL.
• Bug 791169 - Add Reconciliation definition to glossary.
• Bug 796800 - None of the "GnuCash Tutorial and Concepts Guide" graphics (.png files) display.
• Bug 796820 - References to "Gnome Bugzilla" should be changed to "GnuCash Bugzilla".
• Add travis continuous integration to docs.
• Add tax tables to documentation.
• Document Filter/Closing transactions feature.
Getting GnuCash for Windows and MacOS
GnuCash is provided for both Microsoft Windows XP® and later and MacOS X 10.9 (Mavericks)® and later in pre-built, all-in-one packages. An installer is provided for Microsoft Windows® while the MacOS X® package is a disk image containing a drag-and-drop application bundle.
Download GnuCash for Win32: https://downloads.sourceforge.net/sourceforge/gnucash/gnucash-3.3.setup.exe
Download GnuCash for Mac-Intel: https://downloads.sourceforge.net/sourceforge/gnucash/Gnucash-Intel-3.3-1.dmg
Download GnuCash for Win32: https://github.com/Gnucash/gnucash/releases/download/3.3/gnucash-3.3.setup.exe
Download GnuCash for Mac-Intel: https://github.com/Gnucash/gnucash/releases/download/3.3/Gnucash-Intel-3.3-1.dmg
Getting GnuCash as source code
If you want to compile GnuCash 3.3 for yourself, the source code can be downloaded from:
WARNING Do not try to use the github-generated files labelled "Source Code". They have not been processed with swig and will not build.
You can also checkout the sources: git clone https://github.com/Gnucash/gnucash.
Please consult the README.dependencies file in the sources for the required dependencies and versions needed to build GnuCash from source. Additional information on building GnuCash may be found at https://wiki.gnucash.org/wiki/Building.
Getting the documentation
The documentation is available at Documentation page of the GnuCash website. The 3.3 documentation can be found under "GnuCash v3 (current stable release)" in multiple languages both for reading online and for download in pdf, epub, and mobi formats.
If you want to compile the GnuCash Documentation 3.3 for yourself, the source code can be downloaded from:
You can also checkout the sources directly from the git repository as described at https://wiki.gnucash.org/wiki/Git.
Detailed instructions for building GnuCash may be found at https://wiki.gnucash.org/wiki/Building and for the Documentation at https://wiki.gnucash.org/wiki/Initializing_Documentation_Build_Environment.
About the Program
GnuCash is a free, open source accounting program released under the GNU General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, Mac OSX and Microsoft Windows. Programming on GnuCash began in 1997, and its first stable release was in 1998.
More information about the gnucash-devel