Description: When copying the spreadsheet from January to February, in associated diagrams following is not correctly in the target spreadsheet - Column Legend - References to data going to the source spreadshett instead target (copied) spreadsheet Steps to Reproduce: 1. Copy spreadsheet 2. 3. Actual Results: When copying the spreadsheet from January to February, in associated diagrams following is not correctly in the target spreadsheet - Column Legend - References to data going to the source spreadshett instead target (copied) spreadsheet Expected Results: Correctly corrected spreadsheet Reproducible: Always User Profile Reset: No Additional Info: Version: 7.3.7.2 (x64) / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: CL
Created attachment 185126 [details] Visualize the problem
Created attachment 185133 [details] spreadsheet where problem occured
Maybe because Data Series ranges addresses of charts has an absolute reference to the sheet where they are, changing it (deleting the $ in front of ranges, lets to copy fine, but the resulting charts have again absolute addresses. *** This bug has been marked as a duplicate of bug 139188 ***