Calligra 2.9.8 Released

The Calligra team announce availability of the Calligra Suite, and Calligra Active 2.9.8. It is recommended update that improves the 2.9 series of the applications and underlying development frameworks.

Bugfixes in This Release

Here is an overview of the most important fixes. There are several others that may be not mentioned here.


  • Make the maximum default toolbox button size 22px (bug 352110)
  • Fix display of toolbox icons on CentOS
  • Fix crash when typing a bogus color-set name in the color set dialog


  • General:
    • Avoid repeated opening of the same object, possible for large data

  • Tables:
    • Table view’s combo box list: ensure that highlighted row is visible
    • Table view: update the highlighted row while scrolling the viewport

  • Queries:
    • New feature: Add support for 22 typical scalar SQL functions (wish 352631):
      abs(X), ceiling(X), char(X1,X2,…,XN), coalesce(X,Y,…), floor(X), greatest(X,Y,…) and its alias max(X,Y,…), hex(X), ifnull(X,Y), instr(X,Y), least(X,Y,…) and its alias min(X,Y,…), length(X), lower(X), ltrim(X), ltrim(X,Y), nullif(X,Y), random(), random(X,Y), replace(X,Y,Z), round(X), round(X,Y), rtrim(X), rtrim(X,Y), soundex(X), trim(X), trim(X,Y), unicode(X), upper(X).
      • With minor exceptions these functions now work with SQLite, MySQL, PostgreSQL
      • This make Kexi unique environment supporting unified SQL
      • In many cases substitute functions are used to make the result work in a portable way
      • No extra i18n added; will be added in a KDb port
      • Implementation of the function parser supports:
        • checking number of arguments
        • checking types of arguments, sometimes “any number” or “any text or BLOB”
        • checking compatibility of arguments in function
        • checking relation of value of arguments in function, e.g. value of the first argument smaller than second’s
        • checking NULL arguments in function; then most often the result is NULL
        • argument overloading or optional arguments, e.g. round(X) and round(X,Y)
        • displaying of human-readable error messages when the above constraints are not met, for example “Three arguments required” or “Function does not accept any arguments”
        • easy extensibility using just a few lines of code.
    • New feature: Add support for hex literals, useful for opearting on BLOBs in queries: X’ABCD’ (SQL) and 0xABCD (ODBC) formats
    • Optimize evaluating type of expressions (also for database migration)
    • Fix broken floating-point constants in Kexi SQL queries, e.g. “1.002” was interpreted as “1.2” (bug 352363)
    • After parsing numbers are now kept losslessly as byte arrays, what enables unlimited precision
    • Improve parsing/sending BLOB literals
    • Improve performance of the SQL scanner
    • Make parsing of argument lists in scalar SQL functions more efficient by reversing direction

  • MySQL databases:
    • Set client_library_version property for newer versions of MySQL

  • PostgreSQL databases:
    • Return NULL value for columns of NULL type
    • Switch to “BYTEA HEX” escaping while generating native statements


(we’re sorry, details on

Calligra Flow

  • Fix lack of update of Flow’s canvas and page count when deleting the current page

Calligra Stage

  • Let Ctrl+Home/Ctrl+End go to top/bottom of text shape in stage. Much more expected than exiting edit-mode and going to the first or last page.
  • Fix crash when loading a presentation created with LO Impress
  • Don’t leave temporary files around

Try It Out

Download small

The source code of the release is available for download here: calligra-2.9.8.tar.xz.
Also translations to many languages and MD5 sums.
Alternatively, you can download binaries for many Linux distributions and for Windows (users: feel free to update that page).

What’s Next and How to Help?

The next step after the 2.9 series is Calligra 3.0 which will be based on new technologies. We expect it later in 2015.

You can meet us to share your thoughts or offer your support on general Calligra forums or dedicated to Kexi or Krita. Many improvements are only possible thanks to the fact that we’re working together within the awesome community.

(Some Calligra apps need new maintainers, you can become one, it’s fun!)

How and Why to Support Calligra?

Calligra apps may be totally free, but their development is costly. Power, hardware, office space, internet access, travelling for meetings – everything costs. Direct donation is the easiest and fastest way to efficiently support your favourite applications. Everyone, regardless of any degree of involvement can do so. You can choose to:

Support entire Calligra indirectly by donating to KDE, the parent organization and community of Calligra:


Support Krita directly by donating to the Krita Foundation, to support Krita development in general or development of a specific feature:


Support Kexi directly by donating to its current BountySource fundraiser, supporting development of a specific feature, or the team in general:

About the Calligra Suite

Calligra Suite is a graphic art and office suite developed by the KDE community. It is available for desktop PCs, tablet computers and smartphones. It contains applications for word processing, spreadsheets, presentation, databases, vector graphics and digital painting. For more information visit

About KDE

KDE is an international technology team that creates free and open source software for desktop and portable computing. Among KDE’s products are a modern desktop system for Linux and UNIX platforms, comprehensive office productivity and groupware suites and hundreds of software titles in many categories including Internet, multimedia, entertainment, education, graphics and software development. KDE’s software available in more than 60 languages on Linux, BSD, Solaris, Windows and Mac OS X.
This entry was posted in Announcements, Calligra Stable, News. Bookmark the permalink.

5 Responses to Calligra 2.9.8 Released

  1. Pedro Lino says:

    Again, in case nobody noticed there are no Windows binaries for release 2.9.8
    The latest version available for the Windows platform is 2.9.6

  2. Coll says:

    Finally a link for donations! 😀
    Just a question: if I want contribute monetarily to, say, Words’ development because is the program I use most, or just feel it needs more attention than Calligra’s “flagship”, Krita, and others, is there a way I can say that I want my donation may go to the Word’s development team?

  3. ShalokShalom says:

    I guess the reason for the external changelog for Krita is, that this app goes a seperate way now ?

    • Jarosław Staniek says:

      It does not. If you look closer, it just uses another git repository like a lot of Kexi 3 code did earlier this year (3 repositories were created). It’s a backstage thing from user’s POV.

      The reason for the external changelog is that the maitnainer was busy at Qt World Summit 2015. As always more hands helping out would be a good thing.