Hello,
I’m experiencing an issue with Onlyoffice Document Server 9.0.4.1 where formulas are not being copied between tables on different sheets. When I copy a range of cells containing formulas and paste them to another sheet, only the calculated values are pasted — the formulas themselves are lost.
However, if I copy 3 rows or fewer , the formulas are copied correctly to the other sheet.
Why does this happen with larger ranges, and how can I fix it?
Hello @Yuri
First of all, please note that you are using outdated version of Document Server. I did try to reproduce the described behavior on latest version (9.2.1 on the time of reply), but haven’t succeed.
Can you check if the same behavior occurs on latest version? If it does, please record a video demo for the reference or provide a sample file with formulas that fail to copy.
Thanks for the video reference. Please try using Paste Special to insert copied cells with Formula + number format option. The guide on using Paste Special is available here: Spreadsheet Editor - Cut/copy/paste data
By the way, we released new version 9.3 of Docs, I recommend checking out new version too.
Ваш совет не помог.
Thanks for the reply. As I can see, you are using Desktop Editors, is that correct? If so, please let me know which installation type is being used (EXE/MSI/Online Installer for Windows, DEB/RPM packages, snap, flatpack, etc. for Linux or macOS).
Also, is it possible to share the file itself? It appears to be a file-specific issue, because I did not manage to reproduce it.
I am using the web version of DocumentServer
test (1).xlsx (15.6 KB)
Thanks, I see what’s going on. I noticed that you have several rows hidden and the formula in one of the cells refers to the values in those hidden cells. In this case, when copying cells with formula that refers to those hidden cells, it actually cannot reference those numbers, because they are hidden for copying too, thus it results in a value only being pasted.
This is expected behavior for copying hidden cells. If you want to copy them properly, you need to show them first.
I tried this:
When a filter is applied to the table and several rows are hidden by that filter, but the formula doesn’t actually refer to those hidden rows —
when I copy the entire table to another sheet, the formula doesn’t get copied over at all, even though it doesn’t reference any empty cells.
Hey @Yuri, 
Thanks for the additional clarification and the extra testing.
As I understand it, the main issue occurs when there are hidden rows (either manually hidden or hidden by a filter) in the source range. In that case, copying formulas to another sheet often results in only values being pasted instead of the actual formulas.
The expected workaround is to first unhide those rows before copying. However, I’ve passed your specific case (“formulas are lost when copying a range between sheets even if the formula doesn’t reference the hidden rows”) to the development team as a potential bug.
I’ll keep you updated in this thread as soon as we have any news or a fix.
Thanks again for your patience and detailed reports — it really helps! 
Hey @Yuri,
Thanks again for the detailed testing!
We’ve now created a dedicated bug report for this behavior: №80806
The team will investigate it further. I’ll keep you updated in this thread as soon as there’s any progress or a fix.
Appreciate your patience and all the effort you put into reporting this!