At 18:21 31/07/2015 +0100, Brian Barker wrote:
At 14:53 31/07/2015 +0000, Burak Omer Saracoglu wrote:
I draw a chart by Calc. Then I copy it and paste is. Years on x
axis automatically are changed. I copy it and paste to and image
software, years also are changed. Every attempt is same. Always
years are changed.
Computers are nothing if not consistent!
Does anyone know why? How can I fix or solve this problem?
I'm guessing here, but ...
Are your years genuine date values in the original data in the
spreadsheet? If so, remember that what you see in the cells is
controlled by the cell formatting as well as the actual values. When
you create a chart from these values, Calc inherits this formatting
by default into the chart labels. This inheritance is dynamic, so
that subsequent changes to the data cell formatting are carried
through to the chart. When you paste the chart into another product,
the connection with that formatting is apparently broken and the
labels relax into some default formatting. If this is your problem,
there appear to be two simple ways to solve it.
1. (Not recommended)
Enter your year values as text instead of genuine dates. Format the
cells as Text before entering the values. The values will be
incorporated into the chart as plain text and there should be no
change when you copy and paste the chart elsewhere.
2. (Recommended)
Format the year values explicitly in the chart instead of allowing
the formatting to be inherited from the data values.
o Keep your data as genuine dates. Don't worry too much about what
date format they have.
o Create the chart.
o Double-click the chart - so you see the grey border.
o Double-click the x-axis to bring up the x-Axis dialogue.
o Select the Numbers tab.
o Remove the tick from "Source format" to break the inheritance of
date formatting.
o Select your preferred format for your x-axis years.
o Copy the chart into your other application to test.
Now that I have seen your spreadsheet document, I can see what is
happening - though I don't know why it should. The solution is in any
case as above.
Your year values in the data cells are neither text nor dates (in the
spreadsheet sense) but numbers; there is nothing wrong with that. The
formatting in your original chart is inherited from that data. So far
so good. For reasons I don't understand, when you copy that chart -
and break the format inheritance - the numbers are reinterpreted as
if they are dates. Spreadsheet dates are saved as numbers of days
from a start date, which by default is 30 December 1899. So your
values of 2004 to 2015 (as numbers) are reinterpreted as
two-thousand-odd days after this date - that is, 26 June to 7 July
1905. As I say, I can see exactly what is happening but I don't know
why it should.
The solution, anyway, is easy: just break the inheritance of
formatting *in the original chart*, as described above. Remove the
tick from "Source format" and select Text formatting. Then your
revised chart will copy faithfully.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
