Kexi/TODOs/Archive

Warning

Mar 2023 [jstaniek]: Relevant TODOs moved to https://invent.kde.org/office/kexi/-/issues, https://invent.kde.org/office/kreport/-/issues, links added here. Continue working with the tasks there.

See Also: Calligra Feature Plan.

General

Status	Description	Assigned To
DONE	Use KPluginInfo for any kind of plugins, what would allow for creating main window (esp. the project navigator) without loading any plugins in advance	jstaniek [2.6]
DONE	Re-add all the missing actions to the toolbars; look at the .rc files of Kexi 1.x for reference.	jstaniek [2.5]
DONE	Refresh icons: copy view-form as form copy view-form-table as table create query icon from view-form-table reports from view-pim-journal use view-multiple-objects use emblem-new instead of "*" everywhere replace * in object_new with emblem-new use the thunder from view-form-action for 'assign action' and display it in designer over buttons and in the widget tree refresh script icon (and maybe add name "js", "py"" to the script icon) show data-source-pkey-tag icon for widgets with pkey field assigned Done by moving to the breeze icons in the meantime and designing them	jstaniek [2.5]
WISH	Set the script language project-wide, and use a single Kross::Action to retain state between scripts https://invent.kde.org/office/kexi/-/issues/82
WISH	Add translation module for any user-visible text in database. Perform research on reusing core parts of Lokalize or Qt Linguist. Refactoring Lokalize may be needed (better) or just forking some code (worse). Contact the Lokalize team to be sure. GNU gettext .po files format is preffered. Storage: database as everything in Kexi. Strict integration means there should be no external programs executed in the foreground and the workflow should resemble other workflows in Kexi, so the translating interface would be displayed within a tab. https://invent.kde.org/office/kexi/-/issues/83

Main Window

Status	Description	Assigned To
DONE	Create lightweight nonmodal web-like startup screen	jstaniek [2.4]
WISH	Create XML-based tabbed toolbar framework https://invent.kde.org/office/kexi/-/issues/84
WISH	Create XML-based sidebar toolbox framework https://invent.kde.org/office/kexi/-/issues/85

Table View

Status	Description	Assigned To
DONE	Fix rendering problems when the number of columns exceeds the view width. Issuess when scrolling (after porting to Qt 4)	jstaniek
DONE	Port to Qt 4	jstaniek [2.9]
DONE	Port to QScrollArea	jstaniek [2.9]
WISH	Zooming. After porting to QScrollArea https://invent.kde.org/office/kexi/-/issues/86

KoProperty

Status	Description	Assigned To
DONE	Transition to KoProperty2	jstaniek
DONE	Create QSizeF and QPointF properties	piggz
DONE	Improve rendering	jstaniek
DONE	Add missing properties: QColor, KoUnit, LineStyle	jstaniek
DONE	IGNORED Mising border below the last item when its editor is visible	jstaniek
DONE	IGNORED When started to change the editor's value: "revert" button should appear, if the property has parent, the item for the parent should be repainted	jstaniek
DONE	IGNORED Fix or reimplement spin box widgets: look bad with oxygen and probably other styles	jstaniek
DONE	Create QRectF property	piggz
WISH	Add multiselection combo, i.e. for QFlags, e.g. [1] QListWidget has a Qt::ItemIsUserCheckable flaf for items that adds a check box. For more advanced use cases kdeui offers a mini-framework called Goya that makes it easier to insert widgets into model views than plain Qt use. Optionally use subproperties, like it is done with x, y for QPoint type.	jstaniek
DONE	IGNORED Add Maps Theme manager as a QMap<string, variant>	Radek Wicik 2.6

Tables

(Table Designer, for Table View see above)

Status	Description	Assigned To
TO DO	Fix setting primary key using toolbar button https://invent.kde.org/office/kexi/-/issues/87	jstaniek

Queries

Includes query data view, Query Designer and SQL Editor.

Status	Description	Assigned To
TO DO	Use the real KEXISQL parser for criteria column in the design view. Currently simple regexp is used there. Especially support LIKE operator. https://invent.kde.org/office/kexi/-/issues/88	jstaniek 2.6
TO DO	Reimplement relationship editor using GraphicsView https://invent.kde.org/office/kexi/-/issues/89	jstaniek 2.?
WISH	Add support for grouping/totaling; Bug #195360 https://invent.kde.org/office/kexi/-/issues/90	jstaniek 2.?

Forms

Includes form data view and Form Designer.

Forms - general

Status	Description	Assigned To
DONE	Port the plugin	jstaniek
DONE	Fix the rectangle and repainting when inserting widgets with specified size	jstaniek
DONE	Port Widgets Tree tab (it's hidden in 2.2)	jstaniek [2.3]
DONE	FormManager::FormManager: register factory (port to koproperty2)	jstaniek
DONE	Add support for paletteForegroundColor and paletteBackgroundColor properties of Kexi 1.x	jstaniek
TO DO	Add translation and simplify "textInteractionFlags" for QTextEdit and QLabel https://invent.kde.org/office/kexi/-/issues/91	jstaniek [2.?]	<{{{3}}}>
DONE	Fix setting "enabled" property to false	jstaniek
TO DO	(Windows-only?) when right-clicking again after context menu has been displayed, update selection, otherwise the context menu items won't be adequate to the selection	jstaniek	<{{{3}}}>
DONE	Make sorting work in forms - Bug #150372 https://invent.kde.org/office/kexi/-/issues/92	jstaniek [2.?]
TO DO	Port Tab Order dialog (it's hidden in 2.2) https://invent.kde.org/office/kexi/-/issues/93	jstaniek [2.?]	<{{{3}}}>
WISH	Implement tabular layout https://invent.kde.org/office/kexi/-/issues/94	jstaniek [2.?]
WISH	Implement editing mode in data view https://invent.kde.org/office/kexi/-/issues/95	jstaniek [2.?]
WISH	Implement scripting ability for forms similar to reports	? [2.?]
WISH	Implement/renew the simplified form layouts: Stretch top/bottom/left/right/top&down/etc. Inserting/pulling out widgets out of the layout Moving/resizing entire layout Support 'Size to shortest'/'To fit'/etc. in layouts https://invent.kde.org/office/kexi/-/issues/96	jstaniek [2.?]

Form widgets

Form widgets implementation.

Status	Description	Assigned To
DONE	Fix/port text box widget support	jstaniek
DONE	Fix/port image box widget support	jstaniek
DONE	Fix/port text editor widget support	jstaniek
DONE	Fix/port tab widget support	jstaniek
DONE	Fix/port combo box widget support	jstaniek
TO DO	Fix/port/reimplement auto field widget support https://invent.kde.org/office/kexi/-/issues/97	jstaniek [2.6]	<{{{3}}}>
TO DO	Use KRichTextWidget or KRichTextEdit instead of KTextEdit https://invent.kde.org/office/kexi/-/issues/98	jstaniek [2.6]	<{{{3}}}>
DONE	Fix setting alignment property (e.g. for text box) - does not work because it is numeric now	jstaniek
TO DO	Fix/port the Spring element https://invent.kde.org/office/kexi/-/issues/99	jstaniek [2.?]	<{{{3}}}>
TO DO	Display "data" icon and data source name in combo boxes and labels https://invent.kde.org/office/kexi/-/issues/100	jstaniek [2.6]	<{{{3}}}>
DONE	Implement web browser widget	Junior Job, Shreya Pandit [2.4]
DONE	Implement map browser widget	Junior Job, Radek Wicik [2.4]
DONE	Switch to the new New Date/Time Widgets from kdeui [2]	jstaniek [2.6]
TO DO	INVALID (wait until reintroduction of Marble) Add Maps Theme manager for MapBrowserWidget	Radek Wicik[2.6]	<{{{3}}}>

Reports

Relates to the new Reports Plugin (data view and the designer)

Status	Description	Assigned To
DONE	Rename reportspgz to reports everywhere	piggz [2.2]
DONE	Fix javascript kross plugin, or disable as it seems buggy, qtscript is ok	piggz [2.2]
DONE	Export to KWord (OpenDocument Text Format, ODT)	piggz [2.3]
DONE	Make report entities (label/field etc) plugins, so its easier to add new ones	piggz [2.3]
WISH	Add subreport item Wish #330219 https://invent.kde.org/libraries/kreport/-/issues/20	piggz [2.5]
TO DO	Improve Section Editor: Makine the dialog use ok/cancel buttons instead of Close. https://invent.kde.org/libraries/kreport/-/issues/21	piggz [2.4]	<{{{3}}}>
TO DO	INVALID Maybe use flakes, or create a report 'shape' that can be embedded elsewhere	piggz [2.4]	<{{{3}}}>
TO DO	INVALID(will come with python) Add more math functions?	piggz [2.4]	<{{{3}}}>
TO DO	Undo/Redo support https://invent.kde.org/libraries/kreport/-/issues/22	piggz [2.4]	<{{{3}}}>
TO DO	Custom page sizes [3] https://invent.kde.org/libraries/kreport/-/issues/23	[2.8]	<{{{3}}}>
DONE	Labels	piggz [2.4]
TO DO	INVALID(later) Table Item	piggz [2.4]	<{{{3}}}>
WISH	Create a flake based report designer https://invent.kde.org/libraries/kreport/-/issues/24	piggz [2.6]
DONE	Implement web browser element https://invent.kde.org/libraries/kreport/-/issues/25	Junior Job, Shreya Pandit [2.4]
DONE	Implement map browser element https://invent.kde.org/libraries/kreport/-/issues/26	Junior Job, Radek Wicik [2.4]
TO DO	Implement "Do you want to open" question after exporting report to Text/Spreadsheet/as Web Page https://invent.kde.org/libraries/kreport/-/issues/27		<{{{3}}}>

Database Support

Status	Description	Assigned To
DONE	Merge recent changes of KexiDB into KDb	jstaniek [2.3]
DONE	Port Kexi to KDb	jstaniek [3.0]
WISH	Publish tutorial about development with KDb https://invent.kde.org/libraries/kdb/-/issues/17	jstaniek [2.?]
IN PROGRESS	Add unit tests to KDb using QTestLib. Certain type of tests could be executed with several drivers. That would validate any change made in KDb against different drivers. Consider testing against different versions of backends. What we have currently is explained in comment #9 for bug #254188 https://invent.kde.org/libraries/kdb/-/issues/18	jstaniek [2.?]
WISH	Perform benchmarks using QTestLib (valging, callgrind) and cachegrind, and propose improvements. https://invent.kde.org/libraries/kdb/-/issues/19	? [2.?]
WISH	Export KDb API thought Python. https://invent.kde.org/libraries/kdb/-/issues/20	? [2.?]
WISH	Integrate one or more backends for Kexi with nexcloud https://invent.kde.org/office/kexi/-/issues/101	[2.?]

Migration

Status	Description	Assigned To
DONE	Add mdb driver to cmake	piggz [2.2]
DONE	Finish dialog for importing a table into the current database	piggz
DONE	Add ability to existing migration drivers to read a single table	piggz
WISH	Add kross script bindings to kexiscripting for migration https://invent.kde.org/office/kexi/-/issues/102	piggz [2.?]
TO DO	Porting to non-modal assistants https://invent.kde.org/office/kexi/-/issues/103	?? [2.?]	<{{{3}}}>

Import/Export

Status	Description	Assigned To
DONE	Fix "Export to CSV" dialog	piggz, jstaniek [2.3]
DONE	Port CSV Export wizard to KAssistantDialog	??? [2.?]
WISH	Add support for fixed width text export (Bug #254621) https://invent.kde.org/office/kexi/-/issues/104	jstaniek [2.?]

Printing

Status	Description	Assigned To
WISH	Reimplement simple printing using Kexi Reports https://invent.kde.org/office/kexi/-/issues/106	jstaniek [2.?]

Mobile

Status	Description	Assigned To
DONE	Abstract or disable features not used on mobile target (mostly done, merge branch kexi-mobile-adam_pigg with master, reviewed by jstaniek)	piggz [2.4]