Dear Brain;
Thank you very much for your kindness and help.
I follow your recommendation (2. (Recommended)). It works perfectly.
I will create my charts according to this recommendation from now on.
Have a nice day
All my best
Burak
Dr. Burak Omer Saracoglu
PhD in Graduate School of Science Engineering and Technology
MSc in Industrial Engineering
BSc in Naval Architecture and Marine Engineering
Visit Frontiers (Publications)
http://www.frontiersin.org/people/BurakSaracoglu/104045/publications
Visit ResearcherID (Publications)
http://www.researcherid.com/rid/G-5621-2013
Visit ResearchGate (Publications)
https://www.researchgate.net/profile/Burak_Saracoglu
> Date: Sat, 1 Aug 2015 03:04:12 +0100
> To: users@openoffice.apache.org
> From: b.m.bar...@btinternet.com
> Subject: Re: Chart Copy Paste X Axis Change Problem
>
> 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
>
