Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am copying the data in a Base table and pasting it into a Calc spreadsheet. This should just work, but I when I do it, each column from the table is spanning three columns in the spreadsheet.

I think it may have something to do with having Memo (longvarchar) fields in the table.

How can I stop this happening?

By the way, there are other format problems. Sometimes all data is formatted with strikethrough and underline, but I can sort that out by reformatting cells.

share|improve this question
On examining the spreadsheet further, only the first 35 data items span 3 columns each, taking up the first 105 spreadsheet columns from A to DA. Then from columns DB to DU there are a further 10 data items spanning 2 columns each. The other 81 data items are correctly allocated 1 column each, taking columns DV to GX. If correctly allocated the 126 data items take up columns A to DV. – Tony Jul 29 '12 at 16:15
up vote 0 down vote accepted

I have logged a bug for this see this link

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.