Open any Base file. Copy a table. Right mouse click → Paste Dialog "Copy Wizard" appears. Set a new name for the table. Set Options → Definition and data (or: Definition) Press "Next". Choose columns → Next. Take one field an rename the field (Field name could be edited here). Press "Create". No table will be created. It seems to be impossible to create a table with renamed fields in this wizard. Two solutions: 1. Deactivate the input field for "Field name" - nothing should be changed. 2. Implement renaming "Field name". Note: There are drivers to different databases. Some drivers doesn't support renaming fields when a table has been created. So solution 2 will be needed for this databases. This bug appears in current versions like LO 7.4.7.2, also LO 7.6.0.0 alpha1. it doesn't appear in older versions like LO 6.3.5.2. First appears here with LO 6.4.0.3. Tested on OpenSuSE 15.4 64bit rpm Linux.
I'd like to confirm the buggy behaviour described above with LO version: Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2 CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
I can confirm with Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 3df90fbc24a650cf6b0767d00821753ed3d4f5f4 CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded It works for one column table, but doesn't works for table with two columns.
Bibisected with linux-64-6.4 repository to first bad commit be590fb8f670fef61b2b1d915604b39c0fbc8d24 which points to core commit: commit 8c66efa030e98cfdf5da20be368566d64e43c5d1 author Caolán McNamara <caolanm@redhat.com> Thu Sep 05 12:22:38 2019 +0100 committer Caolán McNamara <caolanm@redhat.com> Thu Sep 12 20:28:14 2019 +0200 weld OCopyTableWizard cluster Reviewed-on: https://gerrit.libreoffice.org/78751 I noticed that I could only reproduce when renaming a field that's not the first one. Caolán, can you please have a look?
Could confirm it works with a table, which has only one column (comment 2). But who will use such a table? Have tried to reproduce first field could be renamed without any problem (comment 3), but couldn't reproduce. Here, with internal HSQLDB, there won't be created any new table, if table has more than one column and I change name of a column in table import wizard.