Kexi/Releases/Kexi 2.9: Difference between revisions

Latest revision as of 13:00, 26 February 2015

The main Calligra announcement: https://www.calligra.org/news/calligra-2-9-released

List of changes

Visit bugs.kde.org query for list of formally registered and fixed bugs.

For Kexi, the visual database app builder, 2.9 release is focused on improving quality of existing features. Thanks to close collaboration with users of Kexi, about 150 changes have been performed.

Detailed changes for beta releases are listed on the Calligra announcement pages:

Changes in 2.9.0

(since 2.9.0 Beta 3)

General

Fix size of "undo changes" icon of the Property Editor. Bug #337424

Table Views

Properly resize editor when other column is resized (before the editor tend to jump to the other column)
Improve table view used in combo box popups and spreadsheet mode. This mostly fixes Table Designer. Query designer needs some more work.
Update vertical header sections and fix cursor movement issues:
- On row inserting and deleting, update the vertical header's model (instead of manually adding header sections).
- "Select last row" action works on when there are zero records.
- On new row edit accepting do not jump to first row (fix regression of 2.9 betas).
- Usability: when editing is started, scroll a bit up to show next row if present.
- Usability: when editing is started, ensure the very bottom of empty scroll area is displayed to help the user see what's there.
- Set internal margin of half of the horizontal scroll bar's height only when not in spreadsheet mode.
- Internal logic change for the vertical header: when new row editing starts, the new row data is added to the list of records, on Cancel it's removed.
- Scroll bar should be "always on" when record navigator is visible.
- When the navigator is hidden use "as needed" mode. This lets the scrollbar hide.

Queries

Improve default columns width in the visual view, stretch the last (criteria) column.
Fix support for LIKE and NOT LIKE SQL operators. Now works well with strings and query parameters [...] and properly interacts with the SQL view.

Reports

Added Longitude, Latitude and Zoom properties for map elements.
Fix support for multiple maps on a single report. Due to issues in Marble that is used for maps, that is a partial improvement, user still has to close and reopen the report to have the maps displayed properly. Bug #336986

Import/Export

Table import assistant: optimize data fetching using explicit database transaction.
Table import assistant: "Primary key" button now also turns "autoincrement" on.
Fix import of from the OpenDocument Spreadsheet file (*.ods) format. Bug #336815.
Fix data exporting for parametrized queries to .csv files. Bug #151504

Screenshots

See http://kexi-project.org/pics/2.9

Known bugs

None so far.

Missing or discontinued features

--skip-startup-dialog command line option has been removed; it was used to skip displaying the modal startup dialog window but this makes no sense since the window does not exist already. (Bug #338247)

@@ Line 1: / Line 1: @@
 __TOC__
+The main Calligra announcement: https://www.calligra.org/news/calligra-2-9-released
 ==List of changes==
@@ Line 8: / Line 10: @@
 '''For Kexi, the visual database app builder, 2.9 release is focused on improving quality of existing features. Thanks to close collaboration with users of Kexi, about 150 changes have been performed.'''
-Detailed changes for betas are listed on the Calligra announcement pages:
+Detailed changes for beta releases are listed on the Calligra announcement pages:
 *[https://www.calligra.org/news/calligra-2-9-beta-released/#kexi Changes in 2.9 Beta 1]
 *[https://www.calligra.org/news/calligra-2-9-beta-2-released/#kexi Changes in 2.9 Beta 2]
@@ Line 17: / Line 19: @@
 General
-*Windows version
+*Fix size of "undo changes" icon of the Property Editor. {{Bug|337424}}
-Main Window
-*Welcome view: hide placeholder for templates by default so users won't be confused.
-*Fix some untranslated strings. {{bug|320168}}.
-*Use KDE4's "new" emblem for "create" icons, improve query and report icon.
 Table Views
-*Fix misplaced combo box editor and unnecessary scroll bars:
+*Properly resize editor when other column is resized (before the editor tend to jump to the other column)
-**Misplaced editor in table view's combo box for right alignment. {{bug|330885}}.
+*Improve table view used in combo box popups and spreadsheet mode. This mostly fixes Table Designer. Query designer needs some more work.
-**Scroll bars sometimes appear in combo box popup even when they are not needed. {{bug|330886}}.
+*Update vertical header sections and fix cursor movement issues:
-*Re-add missing "Clear Table Contents" action (regression in Kexi 2.x). {{bug|331039}}.
+**On row inserting and deleting, update the vertical header's model (instead of manually adding header sections).
+** "Select last row" action works on when there are zero records.
+** On new row edit accepting do not jump to first row (fix regression of 2.9 betas).
+** Usability: when editing is started, scroll a bit up to show next row if present.
+** Usability: when editing is started, ensure the very bottom of empty scroll area is displayed to help the user see what's there.
+** Set internal margin of half of the horizontal scroll bar's height only when not in spreadsheet mode.
+** Internal logic change for the vertical header: when new row editing starts, the new row data is added to the list of records, on Cancel it's removed.
+** Scroll bar should be "always on" when record navigator is visible.
+** When the navigator is hidden use "as needed" mode. This lets the scrollbar hide.
 Queries
-*Track changes better when switching from visual to SQL view. Query statement is now updated when needed in the SQL view.
+*Improve default columns width in the visual view, stretch the last (criteria) column.
-*Make queries with lookup field and table alias work. {{bug|330910}}.
+*Fix support for LIKE and NOT LIKE SQL operators. Now works well with strings and query parameters [...] and properly interacts with the SQL view.
-*Do not add table name in a generated SQL when not needed. {{bug|331259}}.
-Forms
-*New: Add support for opening hyperlink via a form button. {{wish|308832}}.
-*Make text in form combo box not trimmed. {{bug|329716}}.
-*Fix bug: data is not saved in form combo boxes. {{bug|329141}}.
-*Make Shift+Return (save record edit) and Escape (cancel field/record edit) shortcuts work in table and form data views (regression in Kexi 2.x). {{bug|330138}}.
-*Improve focus, keyboard interaction and painting in table and form views. {{bug|304989}}, {{bug|329892}:
-**Focus combo box after accepting or cancelling selection in combo popup
-**Show focus in combo box after accepting or cancelling row changes
-**Remove focus from combo box after clicking outside of its popup
-**Improve appearance of combo box' button in table view
-**Fix missing re-display of table view combo box popup
-**Fix focus in table view combo box popup
-**Make clipboard shortcuts work again in table view cells
-**Properly set focus inside table view after activation
+Reports
+*Added Longitude, Latitude and Zoom properties for map elements.
+*Fix support for multiple maps on a single report. Due to issues in Marble that is used for maps, that is a partial improvement, user still has to close and reopen the report to have the maps displayed properly. {{Bug|336986}}
-Reports
-*Fix tool tips of the page navigator of Kexi's report view.
+Import/Export
-*Make certain warning messages translatable. {{bug|320168}}.
+*Table import assistant: optimize data fetching using explicit database transaction.
-*Disable custom page sizes for reports to avoid crashing. Will be fully re-enabled after 2.8.0.
+*Table import assistant: "Primary key" button now also turns "autoincrement" on.
+*Fix import of from the OpenDocument Spreadsheet file (*.ods) format. {{Bug|336815}}.
+*Fix data exporting for parametrized queries to .csv files. {{Bug|151504}}
-Database drivers
-*PostgreSQL: enable use of a pqxx 4.x library. This makes the driver more available in some Linux distributions. {{bug|328380}}.
 </div>