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
01-02-2016, 05:46 PM, (This post was last modified: 02-02-2016, 07:32 AM by shaswin.)
#3
RE: Floating point issue from Excel or Clipboard to Ple4Win
(28-01-2016, 10:42 AM)P Herwig MSc Wrote: 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.

Nice to see that you are implementing the full the NumberFormat into Ple4Win.

If I use Cells(i, n).NumberFormat = "0.000000000" for all numbers the following error appears in Ple4Win when I import the Excel file, see screenshot below:

   

This issue happen because Ple4Win uses hardcoded integer number values. It happens also with hardcoded Single digit values (IEEE 32-bit, 4-byte). Numberformatting with a floating point with (double digit precision) are not always accepted when one imports from Excel from the Ple4Win menu.

I think. if a value can only be an Integer value/String value/Single digit value/Double digit value/etc then this should be mentioned in the Data description/conditions in the helpfile of the input tables.


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 shaswin - 01-02-2016, 05:46 PM
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)