I have a grid that includes various different borders and cells with varying text color. When I copy a single cell and paste into the rest of the cells on a line [for example], the borders and format of the copied cell are copied as well into each individual pasted cell.
How do I copy data only without format and borders? Or copy data and format [like changng text color to that of source cell] without borders?
[Solved] Copy only data - not borders and format
[Solved] Copy only data - not borders and format
Last edited by dayrelton on Fri Sep 14, 2012 1:25 pm, edited 4 times in total.
OpenOffice 3.1 on Windows 7
Re: copy only data - not borders and format
I don't know for certain, but try /Edit /Paste Special.
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
Re: copy only data - not borders and format
Tried that, no selection for 'data only' at a minimum
OpenOffice 3.1 on Windows 7
-
Hagar Delest
- Moderator
- Posts: 33614
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: copy only data - not borders and format
Uncheck Paste All and keep only Text and Number.
Note that there is already a request for that, you can vote for it (2 votes per issue): Bug 9512 - Paste special as value.
Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.
Note that there is already a request for that, you can vote for it (2 votes per issue): Bug 9512 - Paste special as value.
Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.