This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Floating point issue from Excel or Clipboard to Ple4Win
28-01-2016, 10:42 AM,
#2
RE: Floating point issue from Excel or Clipboard to Ple4Win
Hi Shaswin,

On a manual copy fom Excel it is Excel that limits the significance uploaded to the clipboard based on the cell's number formatting.

If you would paste your value from Excel to - for example - Notepad, you will also observe only 10 significant figures are copied. In this case the Number format in Excel is set as 'General'. If you change the number format to 'Number' having 8 decimal places and retry the copy paste action, all 8 digits will be included.

In Ple4Win version 4.3.1 the Excel Import functionality uses the Excel number formatting information. From the upcoming release onwards, the Import functionality will take the full value regardless of the number formatting.


Messages In This Thread
RE: Floating point issue from Excel or Clipboard to Ple4Win - by P Herwig MSc - 28-01-2016, 10:42 AM
RE: Floating point issue from Excel or Clipboard to Ple4Win - by P Herwig MSc - 02-02-2016, 11:40 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)