Apache OpenOffice (AOO) Bugzilla – Issue 106903
Data-loss when copying chart from calc and pasting into writer
Last modified: 2013-02-24 21:20:42 UTC
I'm having some trouble when copying charts out of a spreadsheet file into an open document text file in open office 3.1. Normally simple charts can be copied by ctrl+c and pasted by ctrl+v without problems into writer-files. If I'm constructing more complex charts from scientific data the charts somehow are broken in one or the other way. I have constructed a line-chart with 2 data-series, which looks perfectly right in calc but after copy-paste into writer one of the 2 data-series is inverted for no reason. To reproduce this issue use this sample-data in csv-Format: ,,,, "x1","y1",,"x2","y2" 13.1,0.13187,,58.9,0.05144 13.4,0.13199,,58.4,0.05185 13.9,0.13208,,57.6,0.05209 14.6,0.13185,,56.7,0.05214 15.3,0.13171,,55.8,0.05240 16.1,0.13174,,54.9,0.05252 16.8,0.13145,,54,0.05269 17.6,0.13149,,53.1,0.05309 18.4,0.13142,,52.2,0.05357 19.2,0.13112,,51.3,0.05408 20,0.13126,,50.5,0.05516 20.8,0.13103,,49.5,0.05640 21.7,0.13091,,48.6,0.05817 22.5,0.13086,,47.7,0.06010 23.3,0.13074,,46.8,0.06342 24.1,0.13036,,46.2,0.06566 25,0.13016,,45.6,0.06816 25.9,0.13010,,45.2,0.07100 26.7,0.12979,,44.7,0.07385 27.2,0.12976,,44.2,0.07716 27.6,0.12953,,43.7,0.08055 28.1,0.12943,,43.2,0.08418 28.6,0.12929,,42.7,0.08797 29.1,0.12920,,42.2,0.09172 29.5,0.12909,,41.8,0.09538 30,0.12880,,41.3,0.09914 30.5,0.12857,,40.9,0.10260 30.9,0.12837,,40.4,0.10606 31.4,0.12811,,39.9,0.10890 31.9,0.12764,,39.5,0.11172 32.3,0.12750,,39,0.11411 32.8,0.12701,,38.6,0.11613 33.3,0.12677,,38.1,0.11798 33.8,0.12627,,37.6,0.11977 34.3,0.12569,,37.1,0.12100 34.7,0.12524,,36.7,0.12263 35.2,0.12450,,36.2,0.12361 35.7,0.12393,,35.8,0.12468 36.2,0.12296,,35.4,0.12529 36.6,0.12190,,35,0.12610 37.1,0.12061,,34.5,0.12688 37.6,0.11948,,34.1,0.12730 38.1,0.11789,,33.7,0.12764 38.5,0.11586,,33.2,0.12831 39,0.11388,,32.8,0.12865 39.5,0.11145,,32.4,0.12885 39.9,0.10870,,32,0.12920 40.4,0.10548,,31.6,0.12961 40.9,0.10222,,31.2,0.12987 41.4,0.09875,,30.8,0.12987 41.8,0.09500,,30.4,0.13026 42.3,0.09125,,29.9,0.13037 42.8,0.08713,,29.5,0.13039 43.3,0.08322,,29.1,0.13071 43.7,0.07912,,28.7,0.13071 44.2,0.07556,,27.9,0.13147 44.7,0.07227,,27.1,0.13173 45.1,0.06905,,26.3,0.13214 45.6,0.06616,,25.5,0.13226 46.3,0.06212,,24.7,0.13249 47.2,0.05879,,23.9,0.13260 48.1,0.05620,,23.1,0.13280 49,0.05434,,22.3,0.13292 49.9,0.05318,,21.5,0.13321 50.9,0.05234,,20.7,0.13316 51.8,0.05157,,19.8,0.13319 52.7,0.05135,,19,0.13351 53.7,0.05080,,18.2,0.13359 54.6,0.05083,,17.4,0.13385 55.5,0.05077,,16.6,0.13402 56.4,0.05049,,15.8,0.13420 57.4,0.05086,,14.9,0.13411 58.3,0.05067,,14.1,0.13434 59.2,0.05098,,, Open this csv-file with calc, then copy the data into a new spreadsheet. Create a chart of the type xy-scatter using the chart button in calcs toolbar. Choose lines only, click next, ignore the field data range and click next. Click add to add a new data-series. Leave the name blank. Use the column x1 as x-values for data-series one. Use the column y1 as y-values for data-series one. Click add to add a new data-series. Leave the name blank. Use the column x2 as x-values for data-series two. Use the column y2 as y-values for data-series two. Click finish. Click anywhere in the spreasheet document to deselect the chart. Then click on the chart to select it again and press ctrl+c to copy it. Open a new writer document and paste the chart by pressing ctrl+v into it. The graph of data-series one will be inverted, which should not happen.
Created attachment 66107 [details] CSV-Data file to reproduce issue 106903 with calc and writer of open office v 3.1
Created attachment 66154 [details] example spreadsheet created from given csv data
I can reproduce the problem with OOo 3.1. It is fixed already with issue 102428 for OpenOffice.org 3.2. As long as you use OOo 3.1 you can work around the problem by deleting the last row containing the empty cells for the second series or just fill in some values there. The empty cells are not correctly handled in that version. Thanks for the report!
setting to duplicate of issue 102428 *** This issue has been marked as a duplicate of 102428 ***
closing issue as duplicate