Bug 74217 - FORMATTING: Chart results change after 'copy and paste' to any other LibO or MS Office applications
Summary: FORMATTING: Chart results change after 'copy and paste' to any other LibO or ...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected) release
Hardware: All All
: medium minor
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Chart Clipboard
  Show dependency treegraph
Reported: 2014-01-30 10:35 UTC by Diego Roncoroni
Modified: 2021-02-11 21:54 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

screenshots of the bug (178.06 KB, application/pdf)
2014-01-31 11:23 UTC, Diego Roncoroni
ods file with chart (61.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-31 15:02 UTC, Diego Roncoroni

Note You need to log in before you can comment on or make changes to this bug.
Description Diego Roncoroni 2014-01-30 10:35:54 UTC
Problem description: 

Steps to reproduce:
1. Produce a chart from spreadsheet datas with an empty second row. Selecting data series in row and first row as label. The program selects the area for categories using first AND SECOND ROW.
2. The chart is apparently ok but when copying to any other application you get wrong results

Hope is clear

Operating System: Windows 7
Version: release
Comment 1 tommy27 2014-01-31 04:57:55 UTC
please upload test files and screenshot if needed to show what exactly you mean are "wrong results"
Comment 2 Diego Roncoroni 2014-01-31 11:23:15 UTC
Created attachment 93124 [details]
screenshots of the bug
Comment 3 Diego Roncoroni 2014-01-31 11:24:13 UTC
See the attachement.
Hope it is clear now

Thanks and Ciao
Comment 4 tommy27 2014-01-31 12:26:08 UTC
nice and clear screenshot.
please attach also the original .ods sheet so we can retest and debug.
Comment 5 Diego Roncoroni 2014-01-31 15:02:49 UTC
Created attachment 93145 [details]
ods file with chart
Comment 6 tommy27 2014-01-31 18:08:44 UTC
issue confirmed on Win7 64bit with LibO 
Status: NEW
I Add Calc expert to CC list.
Comment 7 Joel Madero 2015-05-02 15:42:02 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2015-06-20 14:45:30 UTC

Win 7 Pro 64-bit Version:
Build ID: 3ecef8cedb215e49237a11607197edc91639bfcd
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-06-19_23:16:58
Locale: fi-FI (fi_FI)
Comment 9 QA Administrators 2016-09-20 10:11:20 UTC Comment hidden (obsolete)
Comment 10 Bodo Eggert 2018-11-19 21:16:42 UTC
Confirmed for LibreOffice
(Sorry for using Debian Oldstable == jessie.)

What I did:
I have a calc sheet with county data: Names, size, atheism
A different sheet has rates of murders.
On a separate sheet, I collect all the data in one row. Some countries have no match, so there will be n/a values (from the vlookup function):

Name        Inhabitants atheism murders
Examplistan 42.0        23           42
U.S.E.G.    23.1        12           #n/a
Thirdistan   8.38       99           44

I create a bubble graph, atheism = x axis, murder = y axis, county size = bubble size. In calc, these values will be ignored, as intended.

Then I copy/pasted the graph into writer. It looked similar, but not exactly:

»»»When there was a n/a value (at the y coordinate), it stopped copying the data in that column, a lot of values were missing.««« In the example above,the 44 would be missing.
Comment 11 Buovjaga 2018-11-20 08:47:08 UTC
(In reply to Bodo Eggert from comment #10)
> Confirmed for LibreOffice
> (Sorry for using Debian Oldstable == jessie.)

Please, there is no point re-testing with a release from 2014. You can use an appimage with an old distro: https://libreoffice.soluzioniopen.com/
Comment 12 QA Administrators 2020-12-27 03:37:46 UTC Comment hidden (obsolete)
Comment 14 Xisco Faulí 2021-02-11 21:54:35 UTC
(In reply to Xisco Faulí from comment #13)
> This issue got fixed by
> https://cgit.freedesktop.org/libreoffice/core/commit/
> ?id=4b4942224b550235da228655677b5c068a053254

actually most of it got fix... there are I couple of issue I'll report in a follow-up ticket...