You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/01/24 12:58:26 UTC
[Bug 124100] New: Copy and paste of charts in Calc changes axis
labels
https://issues.apache.org/ooo/show_bug.cgi?id=124100
Bug ID: 124100
Issue Type: DEFECT
Summary: Copy and paste of charts in Calc changes axis labels
Product: Calc
Version: 4.1.0-dev
Hardware: All
OS: All
Status: CONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: awf.aoo@googlemail.com
CC: issues@openoffice.apache.org
Created attachment 82383
--> https://issues.apache.org/ooo/attachment.cgi?id=82383&action=edit
Copy and paster either chart changes the x-axis labels.
Open the attached document and copy and paste either chart. The horizontal
axis is changed from labels, showing "1" and "2", to dates.
This is a followup of bug 124069. See its comments for an analysis of this
problem.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124100] Copy and paste of charts in Calc changes axis labels
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124100
--- Comment #3 from Oliver-Rainer Wittmann <or...@apache.org> ---
(In reply to Oliver-Rainer Wittmann from comment #2)
> (In reply to Oliver-Rainer Wittmann from comment #1)
> > I had a look at copy-and-paste of charts in OOo 3.4.0Beta, where everything
> > regarding copy-and-paste of charts look ok.
> > My observation is the following:
> > - copy one of the charts
> > - paste it into new text document (Writer)
> > --> chart looks good
> > - open the 'Chart Data Table'
> > --> category column used for the X-Axis shows date values
> > Note: this also happens when the same chart has been created on 'Sheet2' and
> > copied from 'Sheet2'
> >
> > Stay tuned my for investigation results in earlier OOo versions.
>
> Performing the same actions in OOo 3.3.0
> --> category column lost its data values; no values shown on X-Axis.
OOo 3.2.1 has the same defective behavior as OOo 3.3.0
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124100] Copy and paste of charts in Calc changes axis labels
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124100
Oliver-Rainer Wittmann <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |orw@apache.org
--- Comment #1 from Oliver-Rainer Wittmann <or...@apache.org> ---
I had a look at copy-and-paste of charts in OOo 3.4.0Beta, where everything
regarding copy-and-paste of charts look ok.
My observation is the following:
- copy one of the charts
- paste it into new text document (Writer)
--> chart looks good
- open the 'Chart Data Table'
--> category column used for the X-Axis shows date values
Note: this also happens when the same chart has been created on 'Sheet2' and
copied from 'Sheet2'
Stay tuned my for investigation results in earlier OOo versions.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124100] Copy and paste of charts in Calc changes axis labels
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124100
--- Comment #9 from Andre <aw...@googlemail.com> ---
The detection of the number format of the labels seems to be a mess:
- There is a general bias, based on heuristics, towards dates.
- Copy and paste creates an internal copy (InternalDataProvider) of the calc
data. This copy is a deep copy, not a reference.
- The copy seems to ignore the number format of the x-axis.
- The copy is created by streaming out to and then importing form a temporary
ODF document.
- With all the employed heuristics and different execution paths it is not
clear what the desired behavior really is.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124100] Copy and paste of charts in Calc changes axis labels
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124100
--- Comment #8 from Andre <aw...@googlemail.com> ---
And another observation: when I change values in the first column, the modified
value is displayed in the chart, but its position remains the same. The five
values are displayed at equidistant locations and are clearly treated as
strings, not numbers.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124100] Copy and paste of charts in Calc changes axis labels
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124100
--- Comment #5 from Oliver-Rainer Wittmann <or...@apache.org> ---
(In reply to Oliver-Rainer Wittmann from comment #4)
> (In reply to Oliver-Rainer Wittmann from comment #3)
> > (In reply to Oliver-Rainer Wittmann from comment #2)
> > > (In reply to Oliver-Rainer Wittmann from comment #1)
> > > > I had a look at copy-and-paste of charts in OOo 3.4.0Beta, where everything
> > > > regarding copy-and-paste of charts look ok.
> > > > My observation is the following:
> > > > - copy one of the charts
> > > > - paste it into new text document (Writer)
> > > > --> chart looks good
> > > > - open the 'Chart Data Table'
> > > > --> category column used for the X-Axis shows date values
> > > > Note: this also happens when the same chart has been created on 'Sheet2' and
> > > > copied from 'Sheet2'
> > > >
> > > > Stay tuned my for investigation results in earlier OOo versions.
> > >
> > > Performing the same actions in OOo 3.3.0
> > > --> category column lost its data values; no values shown on X-Axis.
> >
> > OOo 3.2.1 has the same defective behavior as OOo 3.3.0
>
> and OO 3.2.0 also as OOo 3.2.1 and OOo 3.3.0
>
> But I have made a further observation stay tuned.
When I am performing the above actions in OOo 3.2.0, OOo 3.2.0 and OOo 3.3.0,
but copy the chart a second time. Then the data values of the category column
are not lost and everything is fine. Thus the steps are:
- open document
- select a chart
- copy it
- copy it again
- new text document
- paste into text document
--> chart and its internal data is fine.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124100] Copy and paste of charts in Calc changes axis labels
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124100
--- Comment #4 from Oliver-Rainer Wittmann <or...@apache.org> ---
(In reply to Oliver-Rainer Wittmann from comment #3)
> (In reply to Oliver-Rainer Wittmann from comment #2)
> > (In reply to Oliver-Rainer Wittmann from comment #1)
> > > I had a look at copy-and-paste of charts in OOo 3.4.0Beta, where everything
> > > regarding copy-and-paste of charts look ok.
> > > My observation is the following:
> > > - copy one of the charts
> > > - paste it into new text document (Writer)
> > > --> chart looks good
> > > - open the 'Chart Data Table'
> > > --> category column used for the X-Axis shows date values
> > > Note: this also happens when the same chart has been created on 'Sheet2' and
> > > copied from 'Sheet2'
> > >
> > > Stay tuned my for investigation results in earlier OOo versions.
> >
> > Performing the same actions in OOo 3.3.0
> > --> category column lost its data values; no values shown on X-Axis.
>
> OOo 3.2.1 has the same defective behavior as OOo 3.3.0
and OO 3.2.0 also as OOo 3.2.1 and OOo 3.3.0
But I have made a further observation stay tuned.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124100] Copy and paste of charts in Calc changes axis labels
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124100
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
See Also| |https://issues.apache.org/o
| |oo/show_bug.cgi?id=122714
--- Comment #10 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
This one is at least related to "Bug 122714 - First column label values change
to calendar date when copy/paste chart to other AOO application", probably a
DUP.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124100] Copy and paste of charts in Calc changes axis labels
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124100
--- Comment #7 from Andre <aw...@googlemail.com> ---
Maybe converting the first column to text is not such a bad idea (see
https://issues.apache.org/ooo/show_bug.cgi?id=124069#c13). If I stretch the
original chart, then still only the five original values are displayed while in
the copy (with the dates on the horizontal axis) the free space is filled with
interpolated (and extrapolated) values.
The missing interpolation would have been my main argument against using
strings instead of numbers.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124100] Copy and paste of charts in Calc changes axis labels
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124100
--- Comment #6 from Oliver-Rainer Wittmann <or...@apache.org> ---
I have searched the history and found bug 25706. This is feature issue is about
the introduction of date axis for charts.
May be these changes gives us hints for a possible correction.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124100] Copy and paste of charts in Calc changes axis labels
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124100
--- Comment #2 from Oliver-Rainer Wittmann <or...@apache.org> ---
(In reply to Oliver-Rainer Wittmann from comment #1)
> I had a look at copy-and-paste of charts in OOo 3.4.0Beta, where everything
> regarding copy-and-paste of charts look ok.
> My observation is the following:
> - copy one of the charts
> - paste it into new text document (Writer)
> --> chart looks good
> - open the 'Chart Data Table'
> --> category column used for the X-Axis shows date values
> Note: this also happens when the same chart has been created on 'Sheet2' and
> copied from 'Sheet2'
>
> Stay tuned my for investigation results in earlier OOo versions.
Performing the same actions in OOo 3.3.0
--> category column lost its data values; no values shown on X-Axis.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.