Copying a table from Base into Calc rearranges columns headers (but not datas accordingly)

[dgiglio]

Hi to all,
I’ve copied a table content from Base into an empty Calc spreadsheet, but, as you can see from the attached image (fg base; bg calc), the columns headers and the data don’t match anymore. In Calc headers have been alphabetically sorted, while the column of data have mantained the original position.

Any clue?

[RobertG]

Never have seen such a behavior here.

Which system do you use?
Which version of LO do you use?
Could you upload a database with an example table - only one row with dummy content to reproduce the behavior?

[dgiglio]

LO is 7.4.6.2
The OS is WIN10 (b.19045)

But I have to underline that the DB is a connection to an old MDB file, non anymore supported by modern version of Access.

[RobertG]

Could you upload an example with one row dummy content?

Might be I can’t reproduce, because I have to connect through ucanaccess to the *.mdb-file. This is the only possibility for me here with Linux. But could be other people (with Windows) could help here.

[Longi]

Hi!
Same problem.
Windows 10. Libreoffice 7.5
HSQLDB divided. It doesn’t Matter if It is mono or multiuser.
It also occurs to me with an old .mdb database when I Connect It.

[RobertG]

@Longi : Could you also reproduce it with an internal HSQLDB? Then: Please attach an example file here.

Might be it is a problem with external databases, might also be it is a problem with WIN 10.

[mariosv]

It also happens when to update the database range?, Menu/Data/Refresh range, while in a cell in it or after selecting it (Menu/Data/Select range).
Verify the range is properly defined, Menu/Data/Define range – Options.