KOffice 1.6 Changelog

The following summarizes the major changes to the KOffice Suite since the release of KOffice 1.5.2 (latest stable version).

• KOffice Libraries
• KWord
• KSpread
• KPresenter
• Kexi
• Krita
• KPlato
• KChart
• KFormula
• Kugar

KOffice Libraries

• KoProperty Library
  • Possible fix for crash, maybe a definitive fix for bug #124917
  • Group items now have rather pretty appearance styled with KDE style; fixed groups order, API changed: now it's possible to get order of groups; sorting disabled when groups are present; icons can be defined and displayed within the group items
  • Added a container widget that can be used to split information into hideable sections
  • Clear all properties and group names when using operator =; delayed deleting of editors on setting a new property
  • Properties are not changed when new and old value are both null
  • Spin boxes for integer and double values: deleting the contents now sets null value
  • added a method for clearing "modified" class
• Kross Scripting Library
  • Improvements in performance
  • Possible crash fixed
  • Support for python 2.5
  • Using krossrunner+krosskspreadmodule with kspread works.
• various fixed to the handling of opendocument files in KoText

KWord

• crash in style manager (bug #127555)
• KWord can still crash on loading MS Word documents (bug #67216)
• MS Word document crashes kword (bug #84547)
• KWord crashes while updating the table of contents (bug #131122)
• merging 2 cells already merged with others 2 cells already merged crashes kword (bug #132642)
• KWord crashes when I use "save as open office document" or "select all" and "copy" (bug #126007)
• crash deleting second empty page (bug #125998)
• crash after editing/selecting table rows (bug #129315)
• deleting page from rmb menu deletes wrong page (parts of bug #132338)
• Lookup function only returns last value (parts of bug #127411)
• Update zoom when doc struct size changes and fit width is used (bug #134311)

KSpread

Features

• KSpread supports scripting with python and ruby now.
• Make the default column width and row height configurable via Style Manager -> "Default" -> Position. (wish #125749)
• Allow whitespaces in named areas.
• KSpread can import databases created in Kexi
• Speed improvement in loading and saving files
• Improvements in styles saving/loading in opendocument

Bugfixes

• Formula engine / functions:
  • Two-array functions now correctly use both arrays, instead of only one. (bug #130681)
  • Function EVEN rounds up to the next nearest even integer.
  • Function ODD rounds up to the next nearest odd integer.
  • Fix the formula tokenizer. LOG2 and LOG10 are cell references and function identifiers. We have to interpret it depending on the context.
  • Fix references to sheets with names beginning with a number (bug #124549)
  • Fixes for various database functions
  • Fix "LOOKUP function only returns last value". (bug #127411)
• OpenDocument
  • Fix "Table borders are gone after saving a document as ods file" (bug #128123)
  • Fix error in saving of custom cell styles.
  • Fix loading of column width.
  • Load/save the default column/row style.
  • Don't create non-default col/row formats on loading, if it's not necessary.
  • Fix loading of column and row formats.
  • Saving speedup
  • Fix the loading after first save of text properties (bold, ...)
  • Fix "Zeros all over after opening an OpenDocument file" (bug #131508)
  • Fix loading of system date formatting. (bug #118331)
  • Fix saving of prefix/suffix (not for dates, times and strings). (bug #131052)
  • Removed invalid attributes/elements to produce fully valid documents.
  • Fix loading of named ranges.
  • Fix loading of cell values. Don't overwrite loaded formulas!
  • Don't create non-default row and column formats for the visited area. This led to big files.
• UI:
  • Don't jump to chosen cell (range) on entering the formula (bug #134276)

Other

• Fix "Border is not drawn properly" (bug #128477)
• Fix crash in the series operation.
• Fix "some operations ignore arbitrary cells of a selection" (bug #130559)
• Fix crash on copying embedded documents. (bug #120395)

KPresenter

• kpresenter can be built stand-alone
• add a dcop call to end a presentation
• Disable DPMS during presentations. Not via dcop to kdesktop, since kdesktop might not be running.
• Links are not saved in OpenDocument (bug #134481)

Kexi

Main new features

• Object data type and data-aware image form widget (details)
• Support for macros (this is technology preview only, read details)
• Table design altering without removing the existing data (this is technology preview only disabled by default, read details); Undo and Redo commands are available.
• Improvements in Auto Field form widget
• Improvements in Table View, including support for default values and tool-tips for content that is too large for its cell size
• Improvements in Query Designer: defining sort order for column in both visual and SQL view

Table Designer

• Alpha 1:
• Undo/redo actions introduced; deleting and redoing actions improved in the table-altering machinery of KexiDB
• Clear primary key when selecting non-integer type
• Added title to the context menu
• Changing field's description is supported by undo/redo commands and by alter table actions
• Internal Debugger added with "Real alter table" button, for convenience, "save" action now uses the old alter table code (screenshot)
• Renaming table fields works, table schema is recreated when needed, and just altered in-place when it's enough to do so
• Beta 1:
• Fixed setting types and subtypes
• Fixed a crash when there are more than 50 actions performed in the Table Designer's undo/redo stack
• Fixed saving "indexed" and "type" field properties of a table design
• Support for default values
• Fields of type yes/no have default value set to false (by default)
• RC 1:
• Set "false" as default value for columns with Yes/No types
• When column type changes, default value is updated to match the new type (e.g. casted from integer to text; incompatible values are removed)
• Fixed inserting fields of type "Object"

Query Designer

• Alpha 1:
• Possible crash fixed when new design is saved in the data view: rebuild schema only when needed
• RC 1:
• Invalid input (e.g. criteria or sorting) now displays a message box with "Correct" and "Discard Changes" buttons
• Aadded support for setting order of columns in Design and SQL views (ORDER BY)
• Fields were sometimes added twice
• Fixed displaying visible flag (without ? mark)

Forms

• Alpha 1:
• Fixed saving data changes for db-aware check-boxes (by setting StrongFocus policy as default)
• Set the data source readonly if it comes from query
• "Read only" property is now supported by all data-aware widgets, and form itself
• Background color of the line edit in read-only mode is blended with white to get lighter gray
• Accessibility+usability: read only line edit widget now shows the caret
• Display field caption as title for editor's context menu
• Data source pane split vertically into two sections for clarity
• AutoField widget: added support for Image (Object) type, fixed handling color properties, internal editor's properties are automatically inherited by the AutoField widget as so-called sub-properties. Changing value of "Widget Type" property reloads the entire property set, so new properties can appear and unused properties can be hidden in the Property Editor.
• Image Box widget: now supports saving data in the database. Fixed filling duplicated data widgets; fixed editing; "Drop-Down Button Visible" property added. Drop-down button moved to bottom-right, usability improved (e.g. keyboard handling for pop-up), db-awareness added, frame-related properties added, tab/backtab handling fixed, fixed updating position of image when the frame changes
• Removed flickering of the Property Pane after dropping a new field onto the form
• Beta 1:
• Display default values in the new row; default text is displayed with a special style (italic blue) as in table view; cancelling changes in a widget reverts its contents to default value (if available); the special style is removed as soon as the editing starts
• "redo" action removed from the data-aware widgets' context menu (to avoid problems with data handling)
• RC 1:
• Hide unused radio button widget
• Fixed tab/backtab key handling
• Fixed displaying custom label text when "Auto Label" property is off
• Handling of global shortcuts like CTRL+PgDown is now shared with Table View (accesibility: it is now possible to move to next/previous record using keyboard)
• Moving to new row sets the focus in the first data-aware widget (in tab order)
• Fixed leaving from "editing" state on "accept row changes" or moving to other record
• Custom widget factories can be now loaded properly
• Yes/No field default value does not work properly (for required field: if you add a check-box that points to a Yes/No field that has a default value the default value is not accepted) (bug #134976 )
• Fixed updating property values of enum type
• Hide "Editor type" property for auto fields (bug #134773)
• The first widget of a given kind should be named "widget" by default, the second - "widget2" and so on.

Startup

• Beta 1:
• --skip-startup-dialog startup option added: skips displaying Kexi startup dialog window

Data and Project Migration Wizard

• Alpha 1:
• Improved usability for selecting type of destination database (no mention of SQLite for now)

CSV Data Import and Export

• Alpha 1:
• Fixed recursion when importing clipboard data
• Allow to change the delimiter when importing clipboard data
• Parsing data improved: values without leading zeros, like 1/2/2006 work; Since apps like MS Access in the USA creates csv files with date format month/day/year, (and without leading zeros), text with "/" inside is assumed to be in this format.
• Beta 1:
• Time and Object values: fixed exporting to file or copying to clipboard
• Fixed crash on exporting to clipboard
• Delimiter detection is now even more clever, allowing to import more complex data: characters outside quotes have higher priority; number of candidates for delimiters is counted too.

Data Table View

• Alpha 1:
• Spreadsheet mode: fixed inserting empty rows and deleting rows
• Cell editor: the contents are marked as changed only when the original value differs from the current
• Beta 1:
• Current row and column are marked as selection on the vertical and horizontal header sections
• Display tooltip with row number when the vertical scroll-bar is dragged
• RC 1:
• More shortcuts added, shortcuts are now usable and a bit MSAcces-like
• CTRL+End now moves to the last field in the last record (previously: the last record)
• CTRL+Home now moves to the first field in the first record (previously: the first record)
• CTRL+PgDown now moves to the next record
• CTRL+PgUp now moves to the previous record
• CTRL+Plus or CTRL+= now moves to the new record
• Fixed repainting after "Edit->Clear Table Contents" action
• Fixed problem with editing floating-point values when there's default value set to 0.0
• Fixed displaying values for combobox fields
• It is now possible to have empty combobox item: selecting it clears the value of combobox

Database Support Library (KexiDB)

• Alpha 1:
• Improved operations related to table design altering
• Fixed setting database filename when relative path has been provided
• Optimization: "rename table" action now uses "ALTER TABLE RENAME TO" SQL statement, O(1).
• X-Kexi-DoNotAllowProjectImportingTo KexiDB driver property added, false by defaut
• Beta 1:
• Server version information is retrieved (usable for future extensions)
• Added unicode->latin1 mappings for Czech characters
• RC 1:
• Do not try to insert default values into a column with unique flag declared (or even primary key)
• Fixed constructing ORDER BY part of SQL statements (ambiguous fields)
• When creating "columns by name" cache, also remember "table.alias" identifiers
• Use COUNT(*), not COUNT()
• Added support for ORDER BY clause

Database Drivers

• Alpha 1:
• SQLite library upgraded from 3.0.7 to 3.2.8 (backward compatible), to get "table renaming" function.
• Table altering improved for SQLite: changing data types will be possible soon
• Beta 1:
• PostgreSQL: use TIMESTAMP, not DATETIME for date/time data type

Main window

• "Data actions do not appear on first open" workaround used before Kexi 2.0: the Data toolbar is always visible (bug #134975)
• enabling/disabling of actions in query editor (bug #134977)

Documentation

• Added chapter about forms translated to english.

Krita

Core library

• perspective grid: this is a grid that is defined by two vanishing points
• improvements of the memory management, krita can handle more than 4Gb of cache on hard drive on 32bits system and doesn't crash anymore if the system run out of memory before krita reach it's maximum amount of allowed memory
• a lot of fixes in the adjustment layers
• support for layer mask
• improved indirect painting

File filters

• you can import and convert to bitmap PDF files
• improvement in the png filter to allow the opening of big files

Effects/filters plugins

• adjustable blur: a blur effect with control over the height, width and orientation of the effect
• colors filters: some simple transformations on the colors channels (minimum, maximum, transformation to alpha)
• fast color transfer: this effect allows you to give to your image the same tones and colors as the reference image
• lens correction: this filter correct the distortion of the lens of a camera, this filter will also adjust the brightness on the corner of the image
• noise filter: add noise to your image
• random pick filter: this filter will randomly change the value of a pixel by taking the pixel value in the neighborhood
• unsharp mask: this filter is a digital adaptation of an old silver film technique to enhance the quality of a picture

Tools

• a bezier curve: you can create and edit a curve, and affect it a brush and a paint operation
• two new selection tools: magnetic outline selection and bezier curve
• a tool to manipulate the perspective grid
• a tool for correcting the perspective
• the duplicate tool get to new options: healing and perspective correction

Bugfixes

• Fix some specific rendering artifacts
• Fix some non-artifact rendering errors
• Fix changing the adjustment of brightness-contrast adjustment layers
• Fix resizing images
• Fix undo of rotate 180 (bug #135165)
• autoclose/add the screenshot after taking it, remove the print and save buttons (bug #134527)
• UI:
  • Simplify acquiring screen shots (bug #134527)
  • Remember opacity setting in Drop Shadow (bug #134563)
  • Fix so that the rightly marked filters got displayed in the filters gallery dialog
  • New icons set for the toolbox
  • Fix display of masks (bug #134770)
  • remember configuration of drop shadow (bug #134563)
  • Fix a crash where the histogram docker would try to fetch selectedness outside of the consecutive area of the selection
• Selections:
  • Fix problems with selection extent with some selection tools
  • Krita crashes in select contiguous area (bug #134497)
  • Remove the configwidget for selection brush and selection eraser tools
  • Display the mask layer's selection when the mask has one
• Drawing:
  • Grey8 color-space also works anti-aliased when opacity<100% on adjustment layers
  • Add alpha darken to all color-spaces that still didn't have it (fixes painting indirectly on them)
  • Honor the selection with paint indirectly
• Adjustment layers:
  • Fix crash on loading adjustment layers
  • Some changes in selection actions concerning adjustment layers
  • Fix loading of brightness-contrast adjustment layers
  • Fix execution of adjustment layer changes undo information in general
  • Remove lots of non-working filters as adjustment layer
• Tools:
  • Better interaction with the perspective transform tool
  • Bezier tools don't work in OpenGL mode (bug #134477)
  • Optimization of the duplicate tool, and fix healing and perspective
  • Fix the tool crop behaviour
  • fix perspective transformation and non square selection
  • Bezier curves tool works in OpenGL mode (bug #134477)

KPlato

• Added PERT calculation for estimated value based on optimistic, expected and pessimistic value.
• The distribution used is dependent on the setting of Risk.
• List overbooked resources in the task tooltip.
• Fix the calendar table dialog when the first day of the week is not Monday. (bug #129889)

KChart

• Improve data editor. bug #129553.
• Fix: Pie charts use only the Y axis, not only the X axis.
• ODF: Create support for data in rows or columns (bug #134195)

KFormula

New Features

• OpenDocument and MathML supported natively.
• OpenDocument as default file format.
• New font management, Unicode fonts fully supported.
• Arev Sans font included.
• Improved UI for better OpenDocument capabilities support.
• Added a new kcommand to allow insertion of a token element inside another token element of another kind. Now we just need undo working properly.

OpenDocument / MathML

• Supported elements:
• mi
• mn
• mo (partial)
• mtext
• mspace
• ms
• mglyph
• mrow
• mfrac
• msqrt
• mroot
• mstyle
• merror
• mpadded
• mphantom
• mfenced
• menclose (partial)
• msub
• msup
• msubsup
• munder (partial)
• mover (partial)
• munderover (partial)
• mtable (partial)
• mtr (partial)
• mtd (partial)
• maction (partial)
• Supported style attributes:
• mathcolor
• mathbackground
• mathsize
• mathvariant
• fontsize
• fontweight
• fontstyle
• fontstyle
• fontfamily
• color
• background
• scriptlevel
• scriptsizemultiplier
• scriptminsize
• veryverythinmathspace
• verythinmathspace
• thinmathspace
• mediummathspace
• thickmathspace
• verythickmathspace
• veryverythickmathspace
• Other:
• Full support of MathML entities.
• Support for Operator Dictionary.

Bugfixes

• UI:
  • Fix character insertion that requires new token elements
  • Re-enable cut, copy and paste
  • Fix a crash when moving to left in selection mode.
  • Fix a crash when changing token element in selection mode
  • Fix KFCRemoveEnclosing undo code, check that there's really an element to reinsert.
  • Fix unexecution of KFCSplitCommand so that it really does what is supposed to do
  • Remove autodeleting that caused a crash when destructor was called.
  • Fix undo in AddToken commmand. Now token element itself is also removed and cursor positioned in last position of previous element, as it should be.
  • Add only one token for all the text elements, instead of just one token for each.
• MathML / OpenDocument:
  • Insert <mrow> element after <semantics> element, since it does not infer mrows. Fixes bug #134044
  • Fix loading, messed up mn and mtext elements
  • Fix saving of upper index that caused invalid output
  • Support for token splitting added to identifier, operator and insertion elements
  • Add support for TextCharRequest in number elements too

Kugar

• kugar display a list of templates when started