If you copy only the text within one cell, the value pastes fine. It happens only when you copy a block of data with at least two cells or an entire cell. We've seen the problem only with the GEOMEAN() and EXP() functions, although it is possible others are affected as well. It happens only with results computed by certain Excel functions. It happens only with integers ending in zero. The problem does not occur with values you enter in Excel, but only with results calculated in Excel. Windows versions of Excel don't have this bug. The bug is only within Excel 2008 (as far as we know). ![]() This problem only occurs Prism Mac 5.0c and later. ![]() This means the data pasted into Prism may differ substantially from the data created in Excel. In rare cases, a trailing zero is dropped. What could be simpler? But there is a problem. ![]() Copy results calculated in Excel Mac 2008, and paste into a data table in Prism Mac 5.0c.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |