LO Calc cell comment comes when copy a range of LO Calc cells and paste for appending a LO Base table

[lonk]

It copied a range of cells and pasted to append a LO Base table. LO concatenated the comment of cell with cell data; and appended to field data.

Can you please help ?

[Ratslinger]

Hello,

In future please include LO version, OS and database used (ie: HSQLDB embedded, Firebird embedded etc). This is usually necessary information especially for Base questions.

[lonk]

Fedora 30 Workstation / Plasma KDE Desktop Environment / LibreOffice Version: 6.2.4.2 + Firebird embedded

[Ratslinger]

Hello,

Base doesn’t have a method to drop the comments. Best to Paste Special in a blank sheet dropping the comments. Then copy and paste result into Base table.