Z
Z
zhekabboy2021-01-05 19:13:35
Google Sheets
zhekabboy, 2021-01-05 19:13:35

How to solve the problem when copying a cell from one Google spreadsheet to another?

There is a cell combined from two others. It has text. When you try to copy information to another table, the cell is split again. If you do this inside the table, copying to different sheets, there is no such problem, but when you transfer to another table, this problem appears. Those. the cell is either split or formatting changes (size, character orientation, font size). Is there a way to do this without copying?

One of the solutions that I had to resort to was to copy the entire sheet to another table, after which the copying happens without problems, but in my work this copying has to be done too often, so it takes too much time.

When I first started working with Google Spreadsheets, there was no such problem.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2021-01-06
@oshliaer

Hmm...
This is very strange, because. you should be able to copy everything except data validation and range protection.
At the moment, a bug is known with the loss of formatting of the borders of the upper left corner and alignment to the bottom. But as I see it, your Tables tend to unmerge cells and replace border formatting - this looks like a bug.
Unfortunately, I can't replicate this for myself. Add a description and how to repeat it. Send the Tables in which you do this.
If resetting cookies and incognito does not help, then create a topic here https://support.google.com/docs/community?hl=en and send me a link, I will try to open a bug. Write in Russian - it's not a problem.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question