Created attachment 123126 [details] Bug demo spreadsheet Copying a sheet with references to another sheet, will duplicate 2 columns unexpectedly. To reproduce on the attached file: 1) Right-click on tab "Dec 31, 2014" and select "Move/Copy Sheet" 2) Select action "Copy" 3) In "Insert Before" box select "- move to end position -" 4) Click OK You will now observe that columns L and M in the original tab (Dec 31, 2014) are duplicated in columns L, M and N, O in the copied sheet. Therefore columns L and M were copied twice. You will also notice that certain cells did not move with the extra 2 columns that were added, for example observe contents of cell Q13 is the same on both sheets.
Hi @sviatoslav, thanks for reporting. There is no bug. In 'Dec 31, 2014'.N1, you have the formula ='Dec 31, 2013'.L1 doing the copy in the new sheet you have ='Dec 31, 2014'.L1 But 'Dec 31, 2013'.L1 and 'Dec 31, 2014'.L1 have different text values. If you want to keep the sheet reference change the formula to =$'Dec 31, 2013'.L1
By the way, formatting the background color for whole column C, makes the sheet copy very slow.
Thank you very much for pointing these out, and I apologize for reporting as a bug when it's my error!
Do not worry, nobody is born knowing and usually is easier for other with a new look find a mistake. You can find the documentation: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide Sites where to ask: https://ask.libreoffice.org/en/questions/ Mailing list (several languages) http://nabble.documentfoundation.org/