Bug 157190 - unable to INSERT ROW in BASE table
Summary: unable to INSERT ROW in BASE table
Status: RESOLVED DUPLICATE of bug 71224
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.5.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-11 14:27 UTC by kermit999
Modified: 2023-09-14 09:22 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
A small database file (59.09 KB, application/vnd.sun.xml.base)
2023-09-12 13:37 UTC, kermit999
Details

Note You need to log in before you can comment on or make changes to this bug.
Description kermit999 2023-09-11 14:27:11 UTC
Description:
In BASE edit on table, unable to INSERT ROW, or cut & paste to new position. Cannot find any way to arrange my fields once Entered on the table. Creating a new row, then cutting & pasting seems an obvious way, but no field is movable

Steps to Reproduce:
1.Choose INSERT ROWS in Table edit mode - nothing happens
2.- nothing -
3.- cut & paste does nothing

Actual Results:
Nothing

Expected Results:
a new row, in which I can cut and paste a field I wish to move to another position in the table


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Pretty self explanatory, a new line ?
Comment 1 m_a_riosv 2023-09-11 15:09:35 UTC
Please attach a sample file, and paste the information in Menu/Help/About LibreOffice, there is an icon to copy.
Comment 2 kermit999 2023-09-11 15:38:38 UTC
not sure what you mean sample file? - you want my database??
Comment 3 m_a_riosv 2023-09-11 19:20:39 UTC
Your database, obviously cleaned from private data, and reduced to only one table where the issue can be reproduced, or any other where the issue happens, and so knows about database type, etc. to allows someone analyze the possible bug.

BTW, please paste here the information on Menu/Help/About LibreOffce (There is an icon to copy)
Comment 4 Julien Nabet 2023-09-12 11:58:34 UTC
Also, what's the database type used? (HSQLDB embedded, Firebird embedded, MySql, MariaDB, Postgresql)
Comment 5 kermit999 2023-09-12 13:37:10 UTC
Created attachment 189518 [details]
A small database file

Hope this is what you were requesting.. although the fault happens on all the files I have tried
Comment 6 kermit999 2023-09-12 13:38:07 UTC
(In reply to Julien Nabet from comment #4)
> Also, what's the database type used? (HSQLDB embedded, Firebird embedded,
> MySql, MariaDB, Postgresql)

HSQLDB
Comment 7 Julien Nabet 2023-09-13 18:42:30 UTC
Thank you for your feedback.

On pc Debian x86-64 with master sources updated today, I could reproduce this.

We can add a field at the end but not at middle.

Since I could also reproduce this with LO Debian package 7.5.6, let's put version to 7.5.6
Comment 8 Alex Thurgood 2023-09-14 09:06:49 UTC
This has never worked, as far as I can remember, ever since that menu entry was added.

Pretty sure this has been reported before.
Comment 9 Alex Thurgood 2023-09-14 09:16:10 UTC
Looks very much like a DUP of bug 71224.
Comment 10 Alex Thurgood 2023-09-14 09:16:27 UTC

*** This bug has been marked as a duplicate of bug 71224 ***
Comment 11 Alex Thurgood 2023-09-14 09:20:26 UTC
@kermit999 : this bug was recognized 10 years ago, and nothing has happened since.

That should give you some idea of the relative lack of developer resources / interest available for the database part of the LO project.