[Bug 10199] New: Office Excel Clipboard Translation

dfepstein at comcast.net dfepstein at comcast.net
Mon Apr 30 16:46:48 EDT 2012



Perhaps relevant to this thread is this problem I have found while copying in Excel, pasting in LC (actually an older version of Rev): 



When you zoom Excel's display, the number formatting changes. E.g., "442593" becomes "4E+05" if space is too tight, or "####" if space is really tight. This is not a problem while working in Excel, as the underlying data remains the same. But contrary to my expectation, if you select cells, copy, and paste to Rev you do not get those underlying values. You get only the displayed text. "####" at least tells you something is amiss; but "4E+05" is an unannounced but severe amendment from "442593." 

If you paste instead to Notepad, you do get the underlying values 

If you export the Excel sheet as tab delimited text, the results are also strange: in my test, values shown in scientific notation were exported as integers; but values displayed as "####" were exported in scientific notation. 



David Epstein


More information about the use-livecode mailing list