Bug 101653 - Add 3 options to special_paste for 3 different ways of copying charts & spreadsheets
Summary: Add 3 options to special_paste for 3 different ways of copying charts & sprea...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Chart Paste-Special
  Show dependency treegraph
Reported: 2016-08-22 08:48 UTC by chartcopyoptions
Modified: 2021-08-11 14:05 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description chartcopyoptions 2016-08-22 08:48:43 UTC
Chartcopyoptions request. From certain version has been introduced that operation chart copy&past means that copied chart is of unlinked values. Previously that was linked and data changing effected in chart change. The problem is that user can't decide what will be final effect of copy&paste of chart, and in different situations different effects are needed. BTW values only chart is not a copy, but effect of transformation of source object data(!) so this is not copy&paste but transformation&paste of data stuff. however this is also needed.  

There should be easy buttons/options/checkboxes during copy&special_paste when charts or spreadsheets are copied to allow use options: (1) copy exact copy without any changes (remains linked and alive when data changed) (2) copy „photo” transformation of chart with current values only unlinked (unlinked and not changed when source data changed). This is situation when operation is in frames of the same ods file, link is relative and local (in file). 

Also there are no possibility to choose 3rd option when (3) copy&past to another (new) ods file it should be possible to choose how pasted chart should be treated, as linked to original file source or to be linked locally to source data in destination file. 

This should be effective also when more then one chart is marked (in frames of area of spreadsheet marked/higlited) for copy and paste operation.

I suppose that the easiest way is to add all 3 of above options in  „paste_specially” (polish menu „wklej specjalnie”) menu (in contrary to normal paste command without menu ATM) eg.: 
[] paste chart (adequately spreadsheet) linked to data source, absolute – with link to original file name (dynamic chart, emended spreadsheet)
[] paste chart linked to data source, relative – relative, linked locally to data source in the same file, without pasting external file name (dynamic chart) 
[] paste chart/spreadsheet as unlinked photo of values (transformed to static chart) (comment: this option already exist as paste values only)

I think this should work globally in LibreOffice, also when pasting charts or spreadsheets to .odt documents, so it would determine if program is supposed to check and get data from external file if accessible at opening or not. Also manual recalculating would cause to get external data from linked file(s) if any and if they are accessible ATM. 

And in general settings for paste should be possible to choose and set one of above to be default behaviour when normal_paste is executed, so user can choose its preferred way including variants with the same and other files. 

Before normal_paste is executed there ought appear an info window showing which one of 3 options is to be executed, so user can be aware and avoid accidental mistakes. 

Severity of this report is set to major as current behaviour causes/enforces user to rewrite chart manually from sratch and it is impossible to copy charts in easy way. 

Tomasz Amborski
Comment 1 Xisco Faulí 2017-03-02 10:32:06 UTC
Dear Reporter,
Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 2 Heiko Tietze 2017-11-02 08:48:58 UTC
The enhancement request is to have a paste special option where a chart is being pasted from another document but taking the data from the actual sheet. Sounds reasonable.
Comment 3 Stéphane Guillou (stragu) 2021-08-11 14:05:00 UTC
Still not possible on a recent master build:

Version: / LibreOffice Community
Build ID: b2130ad3fda841c68a0436fbddf29bcedede0af5
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-08-09_13:03:07
Calc: threaded

Note that Bug 51984 is similar, but only asks for one of the enhancements listed here.