Skip navigation

Copy + Paste more then one Cell = Values rounded

799 Views 13 Replies Latest reply: Feb 9, 2013 10:14 AM by Gary Scotland RSS
GrafikLVM Calculating status...
Currently Being Moderated
Feb 4, 2013 12:49 AM

Hello there,

 

i hope you can help me, i have a problem with keynote 09 (v5.3) on OSX 10.7.5

 

i have an excel-file with many different decimal-values, f.e. 14,8 in one row.

when i copy the whole row and paste it in the diagram-data-editor of keynote,

the keynote data-editor rounds my values! in my example 14,8 -> 15.

but when i copy every cell alone, the comma is correctly pasted!

 

i have tried many experiments with cell-formation, also in numbers. no change.

the problem is only, when i copy more then one cell from numbers/excel!

and only in the diagram-data-editor – in a keynote table, the formation ist correct!

 

please don't tell me, this is a keynote bug ;(

 

thank you for your help!

sincerly marco (germany)

iMac, Mac OS X (10.7.5)
  • Gary Scotland Level 5 Level 5 (7,555 points)
    Currently Being Moderated
    Feb 4, 2013 3:12 AM (in response to GrafikLVM)

    the problem is using a comma

    you must use a full stop for the decimal point

  • Gary Scotland Level 5 Level 5 (7,555 points)
    Currently Being Moderated
    Feb 4, 2013 4:35 AM (in response to GrafikLVM)

    if you use a spreadsheet application you will need to format the whole sheet as a number to two decimal plces

  • Gary Scotland Level 5 Level 5 (7,555 points)
    Currently Being Moderated
    Feb 4, 2013 6:20 AM (in response to GrafikLVM)

    from your spreadsheet cells,   you are still using commas

     

    my image below shows from the bottom:

     

    • spreadsheet from an Excel file,  cells formated to two decimal places in number format
    • copy and pasted into a Keynote table
    • copy and pasted into a graph

     

    all working correctly

     

    spreadsheet.png

  • Gary Scotland Level 5 Level 5 (7,555 points)
    Currently Being Moderated
    Feb 4, 2013 10:26 AM (in response to GrafikLVM)

    can you try entering data  in British English, which is what my region is?

     

     

    screen grabs as requested:

     

    1

    using Openoffice to enter data

    cells formatted as number & 2 decimal places, in form of 1234.12

     

    format cells.png

     

    2

     

    copy from Open office and pasted into Keynote chart data editor

     

    Kn chart.png

  • Gary Scotland Level 5 Level 5 (7,555 points)
    Currently Being Moderated
    Feb 5, 2013 5:45 AM (in response to GrafikLVM)

    If Keynote is causing this its well worth some software maintenance, you wont loose any projects doing this

     

    delete keynote from applications folder

    delete the file:  .com.apple.iwork.Keynote.plist      from:    users > home > library  > preferences

     

    shut down the mac

    restart and press shift key imediatly after the chime sound

    keep shift pressed until the apple logo appears

    let the mac run while on the gray screen, it is repairing the software and will take 10 mins or so

    when the desktop appears  go to applications > utilities > disc utility > first aid and repair permissions

     

    reboot normally

  • Gary Scotland Level 5 Level 5 (7,555 points)
    Currently Being Moderated
    Feb 6, 2013 7:51 AM (in response to GrafikLVM)

    1 - yes use app cleaner as you have it, ideally all Keynote files should be deleted so you can replace all Keynote files.

     

    2 -  empty  trash

     

    3 - perform this maintenance:

         shut down the mac

         restart and press shift key imediatly after the chime sound

         keep shift pressed until the apple logo appears

         let the mac run while on the gray screen, it is repairing the software and will take 10 mins or so

         when the desktop appears  go to applications > utilities > disc utility > first aid and repair permissions

     

    4 - reboot normally

     

     

    5  - then reinstall Keynote downloaded from from app store.

  • Gary Scotland Level 5 Level 5 (7,555 points)
    Currently Being Moderated
    Feb 9, 2013 10:14 AM (in response to GrafikLVM)

    I still cant replicate your problem, everything works for me.

     

    Send your test spreadsheet and I will try importing your data into Keynote.

    Email is in my profile

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.