Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

What is going on when I copy directly from MS Excel and paste to dbase?

If I copy data from MS Excel (Mac version 16.16) and don't have the columns sized large enough, I can see errors in what appears in the resulting dbase table. A simple example is this simple spreadsheet. Copying its cells and pasting into a dbase file results in this dbase table. My Libre Office version is Mac 6.0.6.2.

I can avoid this problem by having the MS Excel columns sized large enough or by opening the MS Excel file with Calc and using Calc for the copy.

When I do the paste into a Calc spreadsheet, it appears as if an image of the copied cells is being pasted.

What is going on when I copy directly from MS Excel and paste to dbase?

If I copy data from MS Excel (Mac version 16.16) and don't have the columns sized large enough, I can see errors in what appears in the resulting dbase table. table after pasting that data. A simple example is this simple spreadsheet. Copying its cells and pasting into a dbase file results in this dbase table. My Libre Office version is Mac 6.0.6.2.

I can avoid this problem by having the MS Excel columns sized large enough or by opening the MS Excel file with Calc and using Calc for the copy.

When I do the paste into a Calc spreadsheet, it appears as if an image of the copied cells is being pasted.

What is going on when I copy directly from MS Excel and paste to dbase?

If I copy data from MS Excel (Mac version 16.16) and don't have the columns sized large enough, I can see errors in what appears in the resulting dbase base table after pasting that data. A simple example is this simple spreadsheet. Copying its cells and pasting into a dbase base file results in this dbase base table. My Libre Office version is Mac 6.0.6.2.

I can avoid this problem by having the MS Excel columns sized large enough or by opening the MS Excel file with Calc and using Calc for the copy.

When I do the paste into a Calc spreadsheet, it appears as if an image of the copied cells is being pasted.

If I do the paste as a special paste with formatted text (RTF) in base I avoid the problem.

If I do the paste as unformatted text into a Calc spreadsheet, then the Calc cells are populated as expected.

What is going on when I copy directly from MS Excel and paste to dbase?

If I copy data from MS Excel (Mac version 16.16) and don't have the columns sized large enough, I can see errors in what appears in the resulting base table after pasting that data. A simple example is this simple spreadsheet. Copying its cells and pasting into a base file results in this base table. My Libre Office version is Mac 6.0.6.2.

I can avoid this problem by having the MS Excel columns sized large enough or by opening the MS Excel file with Calc and using Calc for the copy.

When I do the paste into a Calc spreadsheet, it appears as if an image of the copied cells is being pasted.

If I do the paste as a special paste with formatted text (RTF) in base I avoid the problem.

If I do the paste as unformatted text into a Calc spreadsheet, then the Calc cells are populated as expected.