Ask Your Question

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

asked 2019-06-22 06:19:34 +0100

lonk gravatar image

updated 2019-06-22 06:31:20 +0100

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 ?

edit retag flag offensive close merge delete



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.

Ratslinger gravatar imageRatslinger ( 2019-06-22 06:49:09 +0100 )edit

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

lonk gravatar imagelonk ( 2019-06-22 07:27:10 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-06-22 06:47:08 +0100

Ratslinger gravatar image


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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-22 06:19:34 +0100

Seen: 16 times

Last updated: Jun 22