Max Depth:

Bug 120062 depends on 364 open bugs:

view as bug list

•    120062: [META] Database related bugs and enhancements [NEW; assigned to libreoffice-bugs]
  •    97838: Date control - earliest year value written is 1600 [NEW; assigned to libreoffice-bugs]
  •    104790: [META] Database connectivity interfaces (ODBC, JDBC..) and external databases [NEW; assigned to libreoffice-bugs]
    •    44069: Request: Environment-variable like macros for ODBC/ADO/JDBC connection strings [NEW; assigned to libreoffice-bugs]
    •    46180: FILEOPEN - LO Base fails to connect to "*.DBF" files but connects OK to "*.dbf" [NEW; assigned to libreoffice-bugs]
    •    46187: Can't Connect Simultaneously Connect through Different JDBC Drivers [NEW; assigned to libreoffice-bugs]
    •    50747: JDBC connector with subforms do not work, when there is no value in mainform (PostgreSQL, MySQL ...) [REOPENED; assigned to libreoffice-bugs]
    •    51780: [META] Default to Firebird not HSQLDB in Base (for _new_ files) [NEW; assigned to libreoffice-bugs]
      •    105220: Firebird: Insert with direct SQL - RETURNING without values [NEW; assigned to libreoffice-bugs]
      •    112491: SDBC-mismatch on alter field-properties in embedded Firebird database when editing primary key [NEW; assigned to libreoffice-bugs]
      •    116935: Firebird: Support for collation in the UI [NEW; assigned to libreoffice-bugs]
      •    116936: Firebird SDBC should implement XRowUpdate interface [NEW; assigned to libreoffice-bugs]
      •    118094: Firebird: Support more XResultSet functions [NEW; assigned to libreoffice-bugs]
      •    120596: Firebird: Editing: Add support for UI data control update of Simple (updatable) views records. [NEW; assigned to libreoffice-bugs]
      •    120597: Firebird: Edit: Update Create View UI to support Firebird 'WITH CHECK OPTION' for Simple (updatable) Views [NEW; assigned to libreoffice-bugs]
      •    123412: Base: Unwanted disconnection from Firebird data source error message "connection shutdown caused by isc_service_attach" [UNCONFIRMED; assigned to libreoffice-bugs]
      •    123591: Firebird - Incorrect Pasting of Numeric Data [REOPENED; assigned to btomi96]
      •    124054: FIREBIRD: incorrect ASC order with varchar data [NEW; assigned to libreoffice-bugs]
      •    124340: Firebird: Autovalue inconsistency when inserting values into table via macro [NEW; assigned to libreoffice-bugs]
      •    126941: Date format with frontslashes (15/08/2019) will be changed to format with points (15.08.2019) when input data in a date-field of a tablecontrol of a form. [NEW; assigned to libreoffice-bugs]
      •    130345: FIREBIRD: Impossible to create an autovalue key when inserting a new table [NEW; assigned to libreoffice-bugs]
      •    132693: firebird - cannot execute multiple SQL commands in one go in Tools > SQL (driver does not implement sdbc::XMultipleResults) [NEW; assigned to libreoffice-bugs]
      •    132824: EDITING: SQL select statements that require dates to be converted to strings produce incorrect results for dates earlier than 15 OCT 1582 [NEW; assigned to libreoffice-bugs]
      •    135616: External text table assigned with SQL Statements is not visible in Firebird embedded server within Base [NEW; assigned to libreoffice-bugs]
      •    136637: Firebird: Entering the sql command will cause Libreoffice to hang [NEW; assigned to libreoffice-bugs]
      •    140339: CRASH: after closing firebird document [NEW; assigned to libreoffice-bugs]
      •    144256: Missing destruction of FirebirdDriver::~FirebirdDriver, OSDBCDriverManager::~OSDBCDriverManager, OPoolCollection::~OPoolCollection opening and closing an ODB [NEW; assigned to libreoffice-bugs]
      •    144619: FIREBIRD - support on disk structure for FB4 versions [NEW; assigned to libreoffice-bugs]
      •    145900: Firebird: copy records will copy row with max value AutoValue primarykey instead of inserted value before refreshing row [NEW; assigned to libreoffice-bugs]
      •    147893: Embedded firebird extends size of CHAR() data field beyond set boundaries and invokes error message [NEW; assigned to libreoffice-bugs]
      •    148096: EDITING: Aliases ignored in form with SQL command as data source in embedded Firebird [NEW; assigned to libreoffice-bugs]
      •    148186: Potentially confusing text label on Base Database Wizard when connecting to a Firebird file [NEW; assigned to libreoffice-bugs]
      •    148266: Firebird: entering several SQL commands directly with delimiter impossible [NEW; assigned to libreoffice-bugs]
      •    148663: Unable to insert an array in embedded firebird [NEW; assigned to libreoffice-bugs]
      •    151344: Firebird LIST function (aka GROUP_CONCAT) gives #NA when linked to sheet [NEW; assigned to libreoffice-bugs]
      •    152044: Deleted Firebird file is recreated when reopen Base file [NEW; assigned to libreoffice-bugs]
      •    152472: LO Base leaves orphaned temp files after running a report from a Firebird database (Win-only) [NEW; assigned to libreoffice-bugs]
      •    156464: FIREBIRD: AutoValue shows 0 for all new Entries in Query with Alias [NEW; assigned to libreoffice-bugs]
      •    156530: FIREBIRD: Copying a table from one database file to another gives wrong decimal numbers. [ASSIGNED; assigned to lionel]
    •    56234: RFE: please allow to link tables from different sources into one database file [NEW; assigned to libreoffice-bugs]
    •    57872: make JDBC access faster [NEW; assigned to libreoffice-bugs]
    •    67145: CRASH: ODBC - Firebird: Attempting to edit table definition causes abort [NEW; assigned to libreoffice-bugs]
    •    67649: Postgresql SDBC updatable views [NEW; assigned to libreoffice-bugs]
    •    68675: ODBC: support arbitrarily-sized bookmarks [NEW; assigned to libreoffice-bugs]
    •    68676: ODBC: optionally use W variants of ODBC calls [NEW; assigned to libreoffice-bugs]
    •    77428: EDITING: Link field is corrupted with H2 JDBC [NEW; assigned to libreoffice-bugs]
    •    80084: sort out ownership of resultset returned by "X(Prepared)?Statement::execute(Query|Update)?" [NEW; assigned to libreoffice-bugs]
    •    86621: direct SQLite open [NEW; assigned to libreoffice-bugs]
    •    88601: LO BASE: Failure to correctly interpret range for UNSIGNED integers from MySQL database (jdbc and native connectors) [summary in comment 9] [NEW; assigned to libreoffice-bugs]
    •    88796: Enhancement - Mysql native connector extension - add automatic reconnect to server capability in connector code after idle timeout [NEW; assigned to libreoffice-bugs]
    •    90520: Base crashes with Oracle ODBC driver when sorting/filtering [NEW; assigned to libreoffice-bugs]
    •    92880: CopyFromRecordset function not working since 4.x [NEW; assigned to libreoffice-bugs]
    •    92950: No support for sqlite relations via Relations menu [NEW; assigned to libreoffice-bugs]
    •    93849: Allow specifying the JDBC jar in the Database Wizard [NEW; assigned to libreoffice-bugs]
    •    96686: Insert data in temporary MySQL/MariaDB-Table through GUI impossible [NEW; assigned to libreoffice-bugs]
    •    100427: UI - Register database dialog should allow multiple files to be selected and registered [NEW; assigned to libreoffice-bugs]
    •    113372: [META] Microsoft Access connectivity bugs and enhancements [NEW; assigned to libreoffice-bugs]
      •    43187: EDITING - MSAccess 2007/2010 (.accdb) table data not editable/updatable - read only with 32 bit and 64bit LibreOffice [NEW; assigned to libreoffice-bugs]
      •    43227: FILEOPEN: UI to set workgroup (system DB) for opening MS Access (.mdb) files [ASSIGNED; assigned to adlair]
      •    53080: FILEOPEN: MS Access Template 'Unrecognized database format' [NEW; assigned to libreoffice-bugs]
      •    56904: Bundle Microsoft Access Database Engine 2010 Redistributable [NEW; assigned to libreoffice-bugs]
      •    83454: Aliases do not work in queries of a database connected to a *.mdb-file [NEW; assigned to libreoffice-bugs]
      •    91190: Import from Access-Databases: only tables imported [NEW; assigned to libreoffice-bugs]
      •    129988: Crash in: s_stub_releaseInterface [UNCONFIRMED; assigned to libreoffice-bugs]
    •    116253: With MariaDB JDBC connection & Filter property set, an empty Combo Box shows 'NULL' when record inserted [NEW; assigned to libreoffice-bugs]
    •    116878: "Password required" no longer available for existing spreadsheet connection [NEW; assigned to libreoffice-bugs]
    •    116968: [META] Migrating existing embedded HSQLDB databases to Firebird [NEW; assigned to libreoffice-bugs]
      •    117090: EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird [NEW; assigned to libreoffice-bugs]
      •    117120: Firebird Migration: Add 'Don't ask again' option to the migration dialog [NEW; assigned to libreoffice-bugs]
      •    117253: FIREBIRD: Migration: Migration routine does not import HSQL TEXT TABLES. [NEW; assigned to libreoffice-bugs]
      •    117352: Firebird: Migration: LibO does not fully release file when ODB file closed without saving after failed migration attempt until LibO session is closed. [NEW; assigned to libreoffice-bugs]
      •    117376: Firebird: Migration: Migration function should not mix the HSQLdb and Firebird schemas in the same altered ODB file [NEW; assigned to libreoffice-bugs]
      •    117510: Firebird: Migration: Data unavailable when migration is run against HSQL ODB opened in Beamer (from Writer or Calc) [NEW; assigned to libreoffice-bugs]
      •    117589: Firebird: set the "ParameterNameSubstitution" parameter at migration time [NEW; assigned to libreoffice-bugs]
      •    122815: HSQL to Firebird migration fails, but file open anyway [NEW; assigned to libreoffice-bugs]
      •    125162: SQL Syntax incorrect for LEFT / RIGHT JOIN when migrating from Base to Firebird [NEW; assigned to libreoffice-bugs]
      •    135239: FIREBIRD migration: Import of a specific table with a combined primary key fails [NEW; assigned to libreoffice-bugs]
    •    116970: [META] HSQLDB removal blockers [NEW; assigned to libreoffice-bugs]
      •    51780: [META] Default to Firebird not HSQLDB in Base (for _new_ files) [NEW; assigned to libreoffice-bugs] (*)
      •    116936: Firebird SDBC should implement XRowUpdate interface [NEW; assigned to libreoffice-bugs] (*)
      •    116968: [META] Migrating existing embedded HSQLDB databases to Firebird [NEW; assigned to libreoffice-bugs] (*)
    •    119135: Display of field type as TIMESTAMP set via UI for mysql table is systematically modified to DATETIME. [NEW; assigned to libreoffice-bugs]
    •    119139: Mysql timestamp fields, set as ON UPDATE CURRENT_TIMESTAMP, not displayed in table data entry mode with mysql jdbc-connector ConnectorJ 8.x [NEW; assigned to libreoffice-bugs]
    •    119431: External database jdbc hsqldb, Crash in the case of SELECT, SQL query, access to the database [NEW; assigned to libreoffice-bugs]
    •    119927: [META] MariaDB C API [NEW; assigned to libreoffice-bugs]
    •    124022: Unhardcode different driver default settings [NEW; assigned to libreoffice-bugs]
    •    124531: PostgreSQL Native Driver: Unable to create view through Base-GUI [NEW; assigned to libreoffice-bugs]
    •    130376: PostgreSQL JDBC and Direct Connection: Autoincrement doesn't return values in Queries with Alias [NEW; assigned to libreoffice-bugs]
    •    131238: SQLite/ODBC: LibreOffice fails Unicode compliance with multi-byte characters, such as emoji, for example 😂 [UNCONFIRMED; assigned to libreoffice-bugs]
    •    141579: Create Query in Design View Query Builder build SQL that aliases table name to itself causing some ODBC and JDBC database queries to fail [UNCONFIRMED; assigned to libreoffice-bugs]
    •    143317: Base crashes viewing / browsing mysql database table using direct mysql connector [NEEDINFO; assigned to libreoffice-bugs]
    •    147582: PostgreSQL JDBC: Form with Subform and SubSubform gives Parameter Error for SubSubForm [NEW; assigned to libreoffice-bugs]
    •    148186: Potentially confusing text label on Base Database Wizard when connecting to a Firebird file [NEW; assigned to libreoffice-bugs] (*)
    •    149284: LO Base freeze when using a form with macro to enter MySQL data [UNCONFIRMED; assigned to libreoffice-bugs]
    •    152370: MariaDB direct connection: Access through socket to separate instance of MariaDB impossible [NEW; assigned to libreoffice-bugs]
    •    153431: PostgreSQL native connector: Field Memo [Text] is filled with 0 instead of character content where postgres server version is greater than or equal to 13 [NEW; assigned to libreoffice-bugs]
    •    154464: PostgreSQL direct connection: Prepared statement with setArray leads to crash of LO [NEW; assigned to libreoffice-bugs]
    •    155183: FIREBIRD: Dialog User Administration won't change anything with Firebird [NEW; assigned to libreoffice-bugs]
    •    155529: MariaDB/MySQL direct connection: Trying to insert NULL in NOT NULL fields will automatically changed in empty text or 0 [NEW; assigned to libreoffice-bugs]
    •    158406: Calc: data connectors (ODBC, OLEDB....) and query builder just like Excel [NEW; assigned to libreoffice-bugs]
    •    160375: Base does not manage relationships outside the default catalog/schema [ASSIGNED; assigned to prrvchr]
  •    108440: [META] Database form bugs and enhancements [NEW; assigned to libreoffice-bugs]
    •    42120: optionally treat filter values as matching patterns [NEW; assigned to libreoffice-bugs]
    •    43928: EDITING Forms - tabstops in tablecontrols could not be changed [NEW; assigned to libreoffice-bugs]
    •    49145: EDITING: Form-Wizard should propose listfields for foreign keys in a table [NEW; assigned to libreoffice-bugs]
    •    49328: EDITING: Relations form-subform, suggested when editing forms, won't work right [NEW; assigned to libreoffice-bugs]
    •    50684: UI: Currency-fields in forms should get additional FORMATTING fields for Color, conditional formatting [NEW; assigned to libreoffice-bugs]
    •    50816: EDITING: Pictures in forms not deleted in the *.odb-file when deleted in forms [NEW; assigned to libreoffice-bugs]
    •    51727: EDITING: Tabstops for tablecontrols aren't set to "no" - only after switching to "yes" and then to "no" [NEW; assigned to libreoffice-bugs]
    •    51868: "Find Record": search through all subforms [NEW; assigned to libreoffice-bugs]
      •    44954: delegate search to the database [NEW; assigned to libreoffice-bugs]
    •    54021: EDITING: Fields in tablecontrols of a form could not be moved/sorted [NEW; assigned to libreoffice-bugs]
    •    56612: EDITING - Base problem with boolean field that defaults to unintended value [NEW; assigned to libreoffice-bugs]
    •    58586: EDITING : Autofilter complete ignored, when content is defined by a Subselect [NEW; assigned to libreoffice-bugs]
    •    61297: UI - Forms incorrectly switching from print to web layout and back [NEW; assigned to libreoffice-bugs]
    •    61949: EDITING: Form designer should make available property fetchSize [NEW; assigned to libreoffice-bugs]
    •    67741: EDITING: Date entry with numeric keypad [NEW; assigned to libreoffice-bugs]
    •    71275: Other: Enhancement - Number of all records should be shown in a form, not only 41* [NEW; assigned to libreoffice-bugs]
    •    71954: EDITING: drag and drop text into database form fields will not get stored [NEW; assigned to libreoffice-bugs]
    •    82318: Form editing repositioning of screen, away from control being edited [NEW; assigned to libreoffice-bugs]
    •    82320: Form properties should include static width, depth. [NEW; assigned to libreoffice-bugs]
    •    82411: Numeric fields are limited to Integer-Values in Tablecontrols and Databrowser of a Form [NEW; assigned to libreoffice-bugs]
    •    84069: LO BASE Forms: Contents of Unbound Field Improperly Reset When Advancing Row Cursor to Insert Row [NEW; assigned to libreoffice-bugs]
    •    84070: LO BASE Forms: On Unbound Form, List Is Disabled [NEW; assigned to libreoffice-bugs]
    •    88552: Event "Text modified" never happens in a combobox inside a tablecontrol [NEW; assigned to libreoffice-bugs]
    •    88560: Wrong Date-input in form gives different values, depended on fieldproperties [NEW; assigned to libreoffice-bugs]
    •    88704: possible regression introduced by "fdo#88551 no need to update content from field when activating grid cell" [NEW; assigned to libreoffice-bugs]
    •    91752: Libre base recommendation to load forms at startup [NEW; assigned to libreoffice-bugs]
    •    92588: BASE: please implement macro trigger with buttons in normal way [NEW; assigned to libreoffice-bugs]
    •    92617: Base is crashing frequently when EDITING data and switching Forms [REOPENED; assigned to libreoffice-bugs]
    •    92937: tab order in base form initially inactive [NEW; assigned to libreoffice-bugs]
    •    93287: Cannot TAB through all Controls on Form with Form window smaller than maximum surface occupied by controls [NEW; assigned to libreoffice-bugs]
    •    96056: Toggle form/datasheet in form [NEW; assigned to libreoffice-bugs]
    •    96190: Date in Form shows different values in Datefield and Formatted Field, if based on an integer Column [NEW; assigned to libreoffice-bugs]
    •    97840: EDITING: table's or field's name does'n get updated in the forms [NEW; assigned to libreoffice-bugs]
    •    98382: Listbox in a table of a form doesn't follow its alignment property [NEW; assigned to libreoffice-bugs]
    •    100367: Allow main form filtering by subform values with form-based filter [NEW; assigned to libreoffice-bugs]
    •    103557: Add syntax to reference form input boxes from queries (pass values) [NEW; assigned to libreoffice-bugs]
    •    103862: UI: Missing read-only option in form designer for check box [NEW; assigned to libreoffice-bugs]
    •    105051: Form Navigator: for "Forms" change properties title from "No control selected" to "No form selected" [NEW; assigned to libreoffice-bugs]
    •    107788: Easy means to clear a selection [NEW; assigned to libreoffice-bugs]
    •    108342: BASE, Editing: list field in table grid shows status row changed on opening form when it's first column [NEW; assigned to libreoffice-bugs]
    •    108471: In a Form Table Control the Default time is not working in Date/Time (time) fields. [NEW; assigned to libreoffice-bugs]
    •    108547: When moving to insert a new record, unbound controls should not get cleared [NEW; assigned to libreoffice-bugs]
    •    112059: Events fired by subform changed, when form is write-protected [NEW; assigned to libreoffice-bugs]
    •    112273: Add API method to reload a form with same parameter [NEW; assigned to libreoffice-bugs]
    •    114814: EDITING: Form Table control Field Copy disfunctional [NEW; assigned to libreoffice-bugs]
    •    115096: For a Pattern Field please reverse the order of the mask related properties [NEW; assigned to libreoffice-bugs]
    •    115099: Pattern Field: Improve property names related to the masking operation. [NEW; assigned to libreoffice-bugs]
    •    115619: Editing form size changes all form sizes [NEW; assigned to libreoffice-bugs]
    •    117792: Maximised windows for forms or reports in Base are reopened bigger than the actual window (Windows-only) [NEW; assigned to libreoffice-bugs]
    •    117793: Default fonts in Base form controls cannot be changed [NEW; assigned to libreoffice-bugs]
    •    121652: Option buttons in forms do not show current value if it is boolean [NEW; assigned to libreoffice-bugs]
    •    121995: Form preview shows content of the form very confused [NEW; assigned to libreoffice-bugs]
    •    141289: Usability : Base Form Label creation does not create label at the expected place when user only clicks [NEW; assigned to libreoffice-bugs]
    •    143389: PDF-Export: Content of a date field in a form won't be shown in exported document [NEW; assigned to libreoffice-bugs]
    •    143418: FORMCONTROL Date: No possibility to choose "Today" as default date [NEW; assigned to libreoffice-bugs]
    •    144436: LO Base nested forms exhibit incorrect navigation when using tab key (Windows-only) [NEW; assigned to libreoffice-bugs]
    •    148096: EDITING: Aliases ignored in form with SQL command as data source in embedded Firebird [NEW; assigned to libreoffice-bugs] (*)
    •    148344: Forms: Previews of a form won't be saved while creating a form [NEW; assigned to libreoffice-bugs]
    •    149725: Database Form Design Navigator is always repositioned at top left corner on French interface [NEW; assigned to libreoffice-bugs]
    •    151186: [UI] Create form wizard does not go back to subform screen (skips over it) [NEW; assigned to libreoffice-bugs]
    •    151861: Navigation bar of Forms: Standard Filter is missing - only Form Based Filters available [NEW; assigned to libreoffice-bugs]
    •    153057: Calc and Base can not filter time values [NEW; assigned to libreoffice-bugs]
    •    153157: Navigation in formular table control with tabulator: very slow and skips unexpected to subformular [NEW; assigned to libreoffice-bugs]
    •    155175: Forms: Buttons should support opening Forms, Reports, Tables and Queries [NEW; assigned to libreoffice-bugs]
    •    155401: Forms - Navigation: Moving by Tilde (Alt+…) only works with Tab Order = 0 for all fields [NEW; assigned to libreoffice-bugs]
    •    157039: Method to clear search text drop down list in Base form [NEW; assigned to libreoffice-bugs]
  •    108441: [META] Database table bugs and enhancements [NEW; assigned to libreoffice-bugs]
    •    42905: Wizard table: Remove autovalue from step2 which doesn't work since there's already autovalue in step3 which works. [NEW; assigned to libreoffice-bugs]
    •    43929: EDITING Tables: Changing of maximum value of binary-fields must be possible [NEW; assigned to libreoffice-bugs]
    •    45252: EDITING postgreSQL-SDBC Can not edit properties for existing table column [NEW; assigned to libreoffice-bugs]
    •    45257: EDITING Relation designer does not pick up all existing relationships [NEW; assigned to libreoffice-bugs]
    •    45508: color row of a table-control [NEW; assigned to libreoffice-bugs]
    •    45606: EDITING: Default-value in GUI doesn't work in SQL [NEW; assigned to libreoffice-bugs]
    •    45834: PgSQL: if no SELECT privilege on table at startup, auto increment field zero in new data [NEW; assigned to libreoffice-bugs]
    •    49054: EDITING: Table Design: changing column type does not reset length to default value [NEW; assigned to libreoffice-bugs]
    •    51605: Field add corrupts table [NEW; assigned to libreoffice-bugs]
    •    51872: Add menu for table import [NEW; assigned to libreoffice-bugs]
    •    51903: Add check-box for primary key in table import dialogue [NEW; assigned to libreoffice-bugs]
    •    56676: EDITING: Tables in databases based on calc are unwriteable - Form Properties show them as writable [NEW; assigned to libreoffice-bugs]
    •    57964: EDITING: copy columns from table control to clipboard [NEW; assigned to libreoffice-bugs]
    •    60643: EDITING - postgresql-SDBC GUI autoincrement setting not saved in Table Design mode [NEW; assigned to libreoffice-bugs]
    •    65766: UI: Wish: More details for tables (meta tags/properties displayed) [NEW; assigned to libreoffice-bugs]
    •    67608: QUERY/TABLE copy/paste a single column [NEW; assigned to libreoffice-bugs]
    •    69957: not possible to use memo fields for filtering [NEW; assigned to libreoffice-bugs]
    •    71224: Insert new fields between existing fields not working (ALTER TABLE ADD BEFORE/AFTER) [NEW; assigned to libreoffice-bugs]
    •    71414: take NUM_PREC_RADIX into account [NEW; assigned to libreoffice-bugs]
    •    72787: Allow Calculations Directly in Base Tables [NEW; assigned to libreoffice-bugs]
    •    73798: Allow export of tables from within LO Base to all file formats supported by Calc [NEW; assigned to libreoffice-bugs]
    •    75354: EDITING: Base TABLE Editor not updating table FIELDS properly when both FIELD NAME and FILED TYPE are changed [NEW; assigned to libreoffice-bugs]
    •    75509: Incorrect display of digits in default Numeric formatting of a field when language isn't English [NEW; assigned to libreoffice-bugs]
    •    83860: Allow to freeze column in LO Base table just like in Calc [NEW; assigned to libreoffice-bugs]
    •    84238: EDITING: Tables - Updating the line height is saved, but isn't read out of content.xml in the *.odb-file [NEW; assigned to libreoffice-bugs]
    •    88032: EDITING: Anomalies when copying field definition rows between tables in design view [NEW; assigned to libreoffice-bugs]
    •    88186: Enhancement Request: Drop Down lists in Base tables (like in Access) [NEW; assigned to libreoffice-bugs]
    •    97765: Feature Request: allow users to add comments to BASE relationships and tables [NEW; assigned to libreoffice-bugs]
    •    98150: Allow saving a relationship model as a separate file [NEW; assigned to libreoffice-bugs]
    •    102945: Base table: entering a default value for a date in the design view gives a wrong value in the table view [NEW; assigned to libreoffice-bugs]
    •    103482: VIEWING : In tables, automatic line return should be done (or as an option) when data overflows the cell [NEW; assigned to libreoffice-bugs]
    •    103497: FORMATTING: Fields in forms should be created with same format as defined in table. [NEW; assigned to libreoffice-bugs]
    •    104375: Table Default value for Date entered via UI cannot be modified using SQL [NEW; assigned to libreoffice-bugs]
    •    105648: Allow default date of "now" in table columns [NEW; assigned to libreoffice-bugs]
    •    106482: DISPLAY: MEMO field not showing all the content in tableview [NEW; assigned to libreoffice-bugs]
    •    107653: LO saves changes after you decline to save upon exiting Relation Design window [NEW; assigned to libreoffice-bugs]
    •    109293: add option "unique" to "Field Properties" gui [NEW; assigned to libreoffice-bugs]
    •    109294: table-edit-window: Modify order of the fields [NEW; assigned to libreoffice-bugs]
    •    112722: Issue on setting up Relationship [NEW; assigned to libreoffice-bugs]
    •    119564: [BASE] Copy/Paste problem with hidden column in Table [NEW; assigned to libreoffice-bugs]
    •    121209: TABLEWIZARD: Field type isn't correctly recognized for Integer and Boolean using automatic field type recognition [NEW; assigned to libreoffice-bugs]
    •    147282: Creating Tables: Field properties → Format Fields → Alignment → Default won't be saved [NEW; assigned to libreoffice-bugs]
    •    147408: EDIT Integer out of range overflows without message [NEW; assigned to libreoffice-bugs]
    •    147657: Default value of a table won't be saved right when formatted other than YYYY-MM-DD [NEW; assigned to libreoffice-bugs]
    •    154037: MySQL/MariaDB direct connection: Deleted tables won't be deleted in content.xml, when deleted directly in MySQL [NEW; assigned to libreoffice-bugs]
    •    155467: Paste Table by wizard - no table will be created if column has been renamed [NEW; assigned to libreoffice-bugs]
    •    156065: Can't insert new rows between field names when editing an existing database table [NEW; assigned to libreoffice-bugs]
    •    156645: Random Loss of Database columns' width and currency format [NEW; assigned to libreoffice-bugs]
  •    108443: [META] Database query bugs and enhancements [NEW; assigned to libreoffice-bugs]
    •    33239: RPT: "ORDER BY" clause dropped in "analyze sql: no" case when grouping is set in the report [NEW; assigned to libreoffice-bugs]
    •    33240: RPT: grouping/sorting silently ignored with "analyze sql: no" [NEW; assigned to libreoffice-bugs]
    •    42400: Query designer: numeric literal in condition on (VAR)CHAR column destructively transformed into string [NEW; assigned to libreoffice-bugs]
    •    42710: SQL parser: WHERE clause "colname" or "NOT colname" [NEW; assigned to libreoffice-bugs]
    •    42713: query design view loses SQL comments [NEW; assigned to libreoffice-bugs]
    •    46207: SQL parser: accept an expression instead of only literal where makes sense [NEW; assigned to libreoffice-bugs]
    •    46209: SQL parser: FROM clause in SELECT should be optional [NEW; assigned to libreoffice-bugs]
    •    46841: EDITING: SQL of queries looses returns when saving and reopening [NEW; assigned to libreoffice-bugs]
    •    49359: Add autocomplete for SQL commands to Query designer [NEW; assigned to libreoffice-bugs]
    •    50546: EDITING: Allow complex statements for parametrized queries [NEW; assigned to libreoffice-bugs]
    •    50626: EDITING: Query on Mac OS X Addressbook doesn't display data for fields other than CHAR datatype [NEW; assigned to libreoffice-bugs]
    •    51404: Libreoffice Base with Oracle - SYSDATE, ROWNUM don't work in query! [NEW; assigned to libreoffice-bugs]
    •    60539: FILESAVE: Column-width of a Query couldn't be saved [NEW; assigned to libreoffice-bugs]
    •    61831: QUERY support for "SELECT TOP n", "ROWID", ... ways of limiting the number of results [NEW; assigned to libreoffice-bugs]
    •    61871: EDITING: Query of a multiplication with fields of two tables don't refresh. [NEW; assigned to libreoffice-bugs]
    •    65685: constant in select list querying a spreadsheet yields blanks [NEW; assigned to libreoffice-bugs]
    •    67608: QUERY/TABLE copy/paste a single column [NEW; assigned to libreoffice-bugs] (*)
    •    67664: Query wizard in need of love [ASSIGNED; assigned to omkar.nikam.2026]
      •    56750: EDITING: Query wizard ignores relationships defined in database [NEW; assigned to libreoffice-bugs]
    •    68153: EDITING: Query input in foreignkey-field impossible, when two tables in the query. [NEW; assigned to libreoffice-bugs]
    •    68374: UI: Feature Enhancement: Query Design View: Select multiple columns at once [NEW; assigned to libreoffice-bugs]
    •    74487: UI: Enhancement: Keep whitespace in SQL Editor [NEW; assigned to libreoffice-bugs]
    •    75853: EDITING: Wrong timestamp in a table with date and time (except 00:00:00) before 1899-12-30 [NEW; assigned to libreoffice-bugs]
    •    77897: EDITING: Query in GUI-mode fails, when using a function in the field and a fieldname with special characters in criterion of the field [NEW; assigned to libreoffice-bugs]
    •    79433: Other: Uninformative error messages in sql queries [NEW; assigned to libreoffice-bugs]
    •    82323: query builder should provide visual representation of relationships one to many [NEW; assigned to libreoffice-bugs]
    •    82325: query builder should seek input concerning what table operation should be done first [NEW; assigned to libreoffice-bugs]
    •    82372: Base: Query builder deletes columns not visible that do not have constraint (unexpected loss of data) [NEW; assigned to libreoffice-bugs]
    •    83121: BASE QUERY EDITOR: silently changes one-to-many relationships in complex query, impossible to set reliable outer join relationships [NEW; assigned to libreoffice-bugs]
    •    83171: QUERY EDITOR: Adapt UI to fully handle views e.g. using function-created NULL values [NEW; assigned to libreoffice-bugs]
    •    86315: EDITING: Formatting of queries should be saved by base [NEW; assigned to libreoffice-bugs]
    •    87737: EDITING: Date-parameter in HSQLDB-queries don't work in UI-language, if parameter is only in subquery [NEW; assigned to libreoffice-bugs]
    •    90093: Enhancement request: SQL auto formatting for Base queries [NEW; assigned to libreoffice-bugs]
    •    91989: Query builder in UI doesn't parse GROUP_CONCAT with ORDER or SEPARATOR [NEW; assigned to libreoffice-bugs]
    •    95466: Field properties in query result cannot be set to Currency [NEW; assigned to libreoffice-bugs]
    •    96372: Filters do not work on Hsqldb subquery result when subquery has alias. [NEW; assigned to libreoffice-bugs]
    •    99619: query design segfault on redoing an undone table join creation [NEW; assigned to libreoffice-bugs]
    •    103557: Add syntax to reference form input boxes from queries (pass values) [NEW; assigned to libreoffice-bugs] (*)
    •    105112: Support aggregate functions EVERY, ANY, SOME, COLLECT, FUSION, INTERSECTION [NEW; assigned to libreoffice-bugs]
    •    112801: Improve LO SQL parser to allow GUI Query editor usage with more SQL connection varieties [NEW; assigned to libreoffice-bugs]
    •    128514: Query-GUI doesn't show any row with HSQLDB 2.5.0 / UNION-query - Tools > SQL will show the output [UNCONFIRMED; assigned to libreoffice-bugs]
    •    136637: Firebird: Entering the sql command will cause Libreoffice to hang [NEW; assigned to libreoffice-bugs] (*)
    •    150917: Access2Base. The Properties method crashes on Database, Table or Report objects [NEW; assigned to libreoffice-bugs]
    •    155751: dBase: BETWEEN won't include first and last value in queries [NEW; assigned to libreoffice-bugs]
  •    108444: [META] Database report bugs and enhancements [NEW; assigned to libreoffice-bugs]
    •    50132: Provide as-is order for groups in Reports [NEW; assigned to libreoffice-bugs]
    •    51807: No method to open a report from a macro with a filter [NEW; assigned to libreoffice-bugs]
    •    90321: EDITING: Changing group should reset the print repeated values [NEW; assigned to libreoffice-bugs]
    •    96616: FILESAVE: Generating a report as "Microsoft Word 2007-2013 XML" creates .odt with .docx extension [NEW; assigned to libreoffice-bugs]
    •    96720: FILESAVE: .odt report produces different ODF Validator Result than a copy saved from Writer (probably resulting in slow file load) [NEW; assigned to libreoffice-bugs]
    •    108745: [META] Report Builder bugs and enhancements [NEW; assigned to libreoffice-bugs]
      •    36107: ReportBuilder: Background other than "color" non-functional [NEW; assigned to libreoffice-bugs]
      •    44458: Report writer for base allows one to format (e.g., orientation landscape-> portrait) the FIRST page only??? [NEW; assigned to libreoffice-bugs]
      •    45338: EDITING ReportBuilder: 'Details - General Keep Together' without visible effect [NEW; assigned to libreoffice-bugs]
      •    50105: EDITING Content sized table cells via Reports builder [NEW; assigned to libreoffice-bugs]
      •    51452: EDITING: ReportBuilder - group with repeating area set automatically pagebreak before and after area [NEW; assigned to libreoffice-bugs]
      •    51453: EDITING: ReportBuilder - group with restarting pagecount impossible [NEW; assigned to libreoffice-bugs]
      •    51959: EDITING: Report-Builder - group-footer disappears when choosing "Repeat Section" [NEW; assigned to libreoffice-bugs]
      •    52430: EDITING: Report-Builder - conditional print expression won't work with repeated section [NEW; assigned to libreoffice-bugs]
      •    52486: EDITING: Report-Builder Show fields dependent on PageCount didn't work [NEW; assigned to libreoffice-bugs]
      •    52942: EDITING ReportBuilder: - allow embedded Pictures [NEW; assigned to libreoffice-bugs]
      •    52944: EDITING: Report-Builder - Edit column Header/Footer has no function [NEW; assigned to libreoffice-bugs]
      •    53253: REPORTBUILDER: Automatic page break destroys details group [NEW; assigned to libreoffice-bugs]
      •    54930: EDITING Report builder: mouse-resize control allows to move top of control to out of section [NEW; assigned to libreoffice-bugs]
        •    54933: EDITING Report builder: mouse-move control: gap between mouse position [NEW; assigned to libreoffice-bugs]
      •    55202: EDITING: Report-Builder - Vertical position of text with shapes in the background impossible [NEW; assigned to libreoffice-bugs]
        •    87430: REPORTBUILDER: fix placing of floats (shapes & charts) [NEW; assigned to libreoffice-bugs]
      •    58911: EDITING: Wizard for legacy Reports unreachable when Report-Builder is installed [NEW; assigned to libreoffice-bugs]
      •    60953: REPORTBUILDER: missing header and footer on first page when section "Detail" is set to Page-Break after Section [NEW; assigned to libreoffice-bugs]
      •    61950: Change Presentation Minimizer and Report Builder from bundled extensions to plain code [NEW; assigned to libreoffice-bugs]
      •    62248: REPORTBUILDER: multiple groupings on same field broken [NEW; assigned to libreoffice-bugs]
      •    67832: upgrade our jfreereport libraries [NEW; assigned to libreoffice-bugs]
      •    68619: REPORTBUILDER: Functions in fields were changed to user-defined-functions in properties of the field, if fieldnames have special characters [NEW; assigned to libreoffice-bugs]
      •    68781: FILEOPEN Report Builder produced chart-in-writer drops date values [NEW; assigned to libreoffice-bugs]
      •    73707: EDITING: Report-Builder - Conditional Print Expression isn't saved for Shapes [NEW; assigned to libreoffice-bugs]
        •    87430: REPORTBUILDER: fix placing of floats (shapes & charts) [NEW; assigned to libreoffice-bugs] (*)
      •    78814: Oracle Report Builder parameter "visible" not working [NEW; assigned to libreoffice-bugs]
      •    82097: REPORTBUILDER: Group Header keeps the values of the first group [NEW; assigned to libreoffice-bugs]
      •    83279: VIEWING: Scrollbar missing in report builder after closing properties panel [NEW; assigned to libreoffice-bugs]
      •    87012: REPORT-BUILDER: Charts without content if chart contain date or time [NEW; assigned to libreoffice-bugs]
        •    68663: ReportBuilder char: unsetting "Label in first column" has no effect [REOPENED; assigned to libreoffice-bugs]
      •    88254: FILESAVE: BASE Report builder doesn't save changes [NEW; assigned to libreoffice-bugs]
      •    96909: REPORT BUILDER: impossible to change souce data during report editing [NEW; assigned to libreoffice-bugs]
      •    97254: EDITING: Allow Base's report builder to use Calc conditional formatting features [NEW; assigned to libreoffice-bugs]
      •    100317: Report builder: text in textbox always centered with multi-line text regardless of Vert or Horiz setting [NEW; assigned to libreoffice-bugs]
      •    101016: REPORT BUILDER: Charts aren't shown when using grouped data from same datasource the report uses [NEW; assigned to libreoffice-bugs]
      •    104056: REPORTBUILDER - Conditional formatting settings not preserved on copy/paste [NEW; assigned to libreoffice-bugs]
      •    104057: REPORTBUILDER - Mouse over on scrolled down rules in conditional formatting dialog always brings back top rules in view [NEW; assigned to libreoffice-bugs]
      •    104058: REPORTBUILDER - Current setting not reflected in conditional formatting color widgets after close/reopen dialog [NEW; assigned to libreoffice-bugs]
      •    105732: More drawing toolbars should be available to Base Report Designer [NEW; assigned to libreoffice-bugs]
      •    107536: REPORTBUILDER: Pie chart colours revert to defaults in generated report [NEW; assigned to libreoffice-bugs]
      •    114062: Report-Builder: Enhancement request - Add subreports like subforms for other datasources than the main report. [NEW; assigned to libreoffice-bugs]
      •    115893: LO Base Report Builder Does Not Display CLOB (memo field) Data of External HSQLDB and Firebird (embedded / file) [NEW; assigned to libreoffice-bugs]
      •    118233: ReportBuilder: filter setting function inconsistent in use of aliases when report based on nested query [NEW; assigned to libreoffice-bugs]
      •    122058: REPORTBUILDER: Measurement unit couldn't be chosen, but point is used internal [NEW; assigned to libreoffice-bugs]
      •    150224: REPORTBUILDER: Imagecontrol won't change vertical alignment for an image [NEW; assigned to libreoffice-bugs]
      •    150225: REPORTBUILDER: Imagecontrol will change vertical alignment for labelcontrol, which touches the imagecontrol [NEW; assigned to libreoffice-bugs]
      •    154780: Multiple spaces are reduced to one in the Writer result of a Base report [NEW; assigned to libreoffice-bugs]
      •    156186: EDITING ReportBuilder: LO hangs when trying to create a function field in a group named with underscore (like "this_group") [NEW; assigned to libreoffice-bugs]
    •    117794: Add more options for some controls in Reports [NEW; assigned to libreoffice-bugs]
  •    108445: [META] Database import/open bugs and enhancements [NEW; assigned to libreoffice-bugs]
    •    34411: External and internal HSQLDB must be usable in different versions [NEW; assigned to libreoffice-bugs]
    •    43187: EDITING - MSAccess 2007/2010 (.accdb) table data not editable/updatable - read only with 32 bit and 64bit LibreOffice [NEW; assigned to libreoffice-bugs] (*)
    •    51779: support for SQL datatype INTERVAL [ASSIGNED; assigned to varshney.devansh614]
    •    53027: EDITING: dBase-Import-Wizard fails when trying to append DECIMAL(NUMERIC) and BOOLEAN data types [NEW; assigned to libreoffice-bugs]
    •    60166: FILEOPEN: BOM not ignored when using text file as database [NEW; assigned to libreoffice-bugs]
    •    61972: FILEOPEN: ENHANCEMENT - Support reference to document directory for back end database location [NEW; assigned to libreoffice-bugs]
    •    63713: FILEOPEN DB metadata: load lazily / in background / persistent cache file / limit by table filter [NEW; assigned to libreoffice-bugs]
    •    89509: Base import table from spreadsheet: glitch in type formatting screen [NEW; assigned to libreoffice-bugs]
    •    95224: Base: Support for ODB flat format [NEW; assigned to libreoffice-bugs]
    •    97330: Enable support for portable split databases in Base [NEW; assigned to libreoffice-bugs]
    •    121210: IMPORT: No possibility to set Auto Value to a Integer Primary Key when importing Calc range [NEW; assigned to libreoffice-bugs]
    •    121211: IMPORT: Calc range 'table definition only option selected' fails to create table [NEW; assigned to libreoffice-bugs]
    •    122295: When inserting a data from data source have a possibility to change the order of columns [NEW; assigned to libreoffice-bugs]
    •    125503: Changing database through "exchange database" doesn't allow to choose path for saved database-file [NEW; assigned to libreoffice-bugs]
    •    142735: Form field is not active unless save the document [NEW; assigned to libreoffice-bugs]
  •    113375: [META] Database wizard bugs and enhancements [NEW; assigned to libreoffice-bugs]
    •    83814: Port Database Wizard to python [NEW; assigned to libreoffice-bugs]
    •    88274: Wizard generated form fails in several ways; TAB focus in List box when List box is first control in sub form [NEW; assigned to libreoffice-bugs]
    •    93849: Allow specifying the JDBC jar in the Database Wizard [NEW; assigned to libreoffice-bugs] (*)
    •    106428: RFE: diagnose non-existent file earlier [NEW; assigned to libreoffice-bugs]
    •    114116: Dialog "assign datasource" in Writer doesn't display the source name in the list [NEW; assigned to libreoffice-bugs]
    •    121253: Database wizard opens when press CTRL+A inside the extension manager window [NEW; assigned to libreoffice-bugs]
    •    148192: Create a new option External Firebird file under Create new database [NEW; assigned to jcsanz]
    •    148495: Connect to an existing database drop-down list in Database Wizard should be alphabetically sorted [NEW; assigned to libreoffice-bugs]
    •    148499: Database Wizard UI looks inconsistent when you select Writer document item in Connect to an existing database list [NEW; assigned to libreoffice-bugs]
  •    114293: [META] Address Book Data Source bugs and enhancements [NEW; assigned to libreoffice-bugs]
    •    51969: Feature Request: Use CardDav as an address book source [NEW; assigned to libreoffice-bugs]
    •    55833: Lacking support for KDE 4.x addressbooks (akonadi) [NEW; assigned to libreoffice-bugs]
    •    70641: No connection to KDE address book possible (see comment 10) [NEW; assigned to libreoffice-bugs]
    •    109124: Change fields in Address Data/Book Source to be the same as in Mail Merge Wizard [NEW; assigned to libreoffice-bugs]
    •    116636: Address Data Source Wizard: incomplete list of tables for Thunderbird [NEW; assigned to libreoffice-bugs]
      •    138715: Thunderbird Addressbook no longer connectable [NEW; assigned to libreoffice-bugs]
    •    133845: Simplify Address Book Data Source Wizard [NEW; assigned to libreoffice-bugs]
    •    152530: Address Data Source: Wizard shows Thunderbird, but there is no connection available [NEW; assigned to libreoffice-bugs]
    •    152825: Tools - Address Book Source: warnings in console with debug LO [NEW; assigned to libreoffice-bugs]
    •    157806: Address from Evolution Address Book defined but not displayed [NEEDINFO; assigned to libreoffice-bugs]
  •    120060: [META] Data source view bugs and enhancements [NEW; assigned to libreoffice-bugs]
    •    117813: *.csv database: changing character set needs a disconnect, add function to drop and recreate default connection object after configuration change [NEW; assigned to libreoffice-bugs]
    •    128338: UI: Irregular icons for 'First Record/Previous Record/Next Record/Last Record' in Data Sources [NEW; assigned to libreoffice-bugs]
    •    147697: Wrong field or value inserted by drag and drop from 'Data Sources' when table preview needs to scroll [NEW; assigned to libreoffice-bugs]
  •    125502: Changing database through "exchange database" creates *.odb-files for unusable fileformats [NEW; assigned to libreoffice-bugs]
  •    137043: [META] HSQLDB database related bugs and enhancements [NEW; assigned to libreoffice-bugs]
    •    31398: RFE: LibreOffice Base should allow update/insert/drop query in sql-editor with hsqldb access controls [NEW; assigned to libreoffice-bugs]
    •    34411: External and internal HSQLDB must be usable in different versions [NEW; assigned to libreoffice-bugs] (*)
    •    36546: Internal HSQLDB 1.8 fails to cascade updates through multiple paths and deletions through some cyclic structures [NEW; assigned to libreoffice-bugs]
    •    53333: Using HSQLDB 2.3.0 for development [NEW; assigned to libreoffice-bugs]
    •    53473: Embedded HSQLDB calls flush (CHECKPOINT) too often [NEW; assigned to libreoffice-bugs]
    •    91814: Problem when copying large table with floating-point values from Calc to Base (HSQLDB) [NEW; assigned to libreoffice-bugs]
    •    92936: FILESAVE: HSQLDB:Inserting big image in a form destroys all input since last opening of *.odb-file [NEW; assigned to libreoffice-bugs]
    •    93478: HSQLDB doesn't support newlines in column name in a database connected to a spreadsheet [NEW; assigned to libreoffice-bugs]
    •    96387: deadlock in HSQLDB [NEW; assigned to libreoffice-bugs]
    •    98491: Split hsqldb Base application will not start under OSX10.11.x causes LO to freeze requiring force kill [NEW; assigned to libreoffice-bugs]
    •    105140: HSQLDB: Aggregate functions don't work - COLLECT, FUSION, INTERSECTION [NEW; assigned to libreoffice-bugs]
    •    116970: [META] HSQLDB removal blockers [NEW; assigned to libreoffice-bugs] (*)
    •    132095: Splitted HSQLDB 2.3.2: Decimal-fields are formatted as currency when table or view used in Calc [NEW; assigned to libreoffice-bugs]
    •    132195: Better integration of hsqldb 2.5.0 [UNCONFIRMED; assigned to libreoffice-bugs]
    •    143297: Saving Calc spreadsheet with many database queries injects spurious rows [FILESAVE,FORMATTING] [NEW; assigned to libreoffice-bugs]
  •    147110: Search in record not shown and not Cancel button [NEW; assigned to libreoffice-bugs]
  •    155308: Dialog Record Search in Base forms: Wrong activated button "Help" instead of "Search" [NEW; assigned to libreoffice-bugs]

Bug 120062 does not block any open bugs.

Max Depth:

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    [x]
  • | Forgot Password
    Login: [x]