Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Solve an iWork/Excel data paste and charting glitch' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Solve an iWork/Excel data paste and charting glitch
Authored by: robg on Mar 03, '05 11:03:21AM

I actually tried that first -- both formatting as text, and using the single quote.

The problem is that the clipboard itself doesn't retain any of that info. To the clipboard, data is data, whether it's a text or a number. So when Keynote/Pages gets the clipboard contents, it doesn't get it with any intelligence. They see a number in the first column, and they decide to add those numbers to the data portion of the chart.

So the only workaround is to make sure that the first value on the clipboard is truly text, and cannot be intrepreted as a value...

-rob.



[ Reply to This | # ]
Solve an iWork/Excel data paste and charting glitch
Authored by: osxpounder on Mar 07, '05 05:28:49PM

I never really paid attention to Keynote or Pages until I saw that nice chart image you posted, Rob. Now I've gotten iWork; Apple should thank you! I do.

---
--
osxpounder



[ Reply to This | # ]