https://bugs.documentfoundation.org/show_bug.cgi?id=101653
Bug ID: 101653
Summary: Add 3 options to special_paste for 3 different ways of
copying charts & spreadsheets
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Chart
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
