Chart Copy Paste X Axis Change Problem
Dear Open Office Calc Users; 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. Does anyone know why? How can I fix or solve this problem? Thank you very much. Best Regards 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 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Chart Copy Paste X Axis Change Problem
At 14:53 31/07/2015 +, 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. 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
Fwd: Apache Office org
Please respond. Thanks. *CHERYL ALEXANDER* *MAXIM LLC* *CELL: 239.222.3322* *FAX:239.205.6945* -- Forwarded message -- From: Cheryl Alexander Date: Fri, Jul 31, 2015 at 12:00 PM Subject: Re: Apache Office org To: communityt...@sourceforge.net There is no such email address. *CHERYL ALEXANDER* *MAXIM LLC* *CELL: 239.222.3322 <239.222.3322>* *FAX:239.205.6945 <239.205.6945>* -- Forwarded message -- From: Cheryl Alexander Date: Fri, Jul 31, 2015 at 11:57 AM Subject: Apache Office org To: communityt...@sourceforge.net An investigator has traced malware in my computer directly attributed to the download that I did from your site. I have tried to delete your information to no avail. I have received several messages stating that my emails are being compromised and an unauthorized party is using my email accounts. Please remove this program from my computer. The investigator says that you are following my keystrokes and most likely have obtained all of my personal information. I will be contacting the authorities. *CHERYL ALEXANDER* *MAXIM LLC* *CELL: 239.222.3322 <239.222.3322>* *FAX:239.205.6945 <239.205.6945>*
Re: Chart Copy Paste X Axis Change Problem
At 18:21 31/07/2015 +0100, Brian Barker wrote: At 14:53 31/07/2015 +, 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
Thanks
I downloaded the old version of open office and I just love it. Thanks so much Sincerely, June Stepansky
Restrict other users to edit
Dear Team, How can I access a password protected shared excel file from open office ? Whenever I open password protected excel file from open office from open office, it will directly open without asking for password and locked for editing i.e. restrict other users from editing at that time. -- With Regards Avinash Kumar M.No. : 8976500068
RE: Chart Copy Paste X Axis Change Problem
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 +, 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 >
