Ask Your Question

Data copied from Base Table to Calc spreadsheet is incorrectly formatted

asked 2017-01-18 02:53:13 +0200

yofe2015 gravatar image

updated 2020-09-20 23:23:45 +0200

Alex Kemp gravatar image

If I copy a Base table and attempt to paste it into a blank Calc spreadsheet, all of the data is copied but the column headings are pasted in alphabetical order while the data is copied just as it appeared in the Base table. Thus, every column contains incorrect data totally unrelated to the heading.

How do I control the column headings so that the data contained therein is a duplicate of the Base table?

Thanks <removed email address>

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-18 04:20:28 +0200

Ratslinger gravatar image

Don't see the problem using LO v5.2.3.3 on Mint 18:

image description

You can also import from menu View->Data Sources (must be registered DB).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-18 02:53:13 +0200

Seen: 89 times

Last updated: Sep 20 '20