Ask Your Question
0

Data copied from Base Table to Calc spreadsheet is incorrectly formatted

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

yofe2015 gravatar image

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

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
0

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

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

Stats

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

Seen: 72 times

Last updated: Sep 20