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
Issues importing Excel tables in Ple4Win
14-06-2016, 04:27 PM, (This post was last modified: 17-06-2016, 01:39 PM by shaswin.)
#1
Issues importing Excel tables in Ple4Win
Affected version: Ple4Win Professional v4.4.0 build 16050 revision May 26th, 2016

I have attached the Excel import file where some issues are occuring.

Issue 1:
When one imports input tables from Excel and some notes are written in Excel outside the Ple4Win input table range Ple4Win gives a warning (for example the ORIGIN table), see screenshot below. It shouldn't check for data values outside the fixed range of an input table.
   
This worked in earlier version of Ple4Win, somehow the behaviour is changed and a warning is now displayed, which is irritating and not relevant.

Issue 2:
Another is issue when there are a lot of texts outside the input range for example the SUBSIDE input table the data will not get imported. You will see that the SUBSIDE table is empty. You have to remove all your notes to make it work. This worked in earlier version of Ple4Win, somehow the behaviour is changed now.
When for example a formulae is written in column D and E in the SUBSIDE table a #REF warning will appear. Why doesn't PLE doesn't convert the data into a text value before importing?


Attached Files
.xlsx   Voorbereiding_Ple4Win import_BC4_opwarm_gesplitst_lang_SOILRB.xlsx (Size: 181.63 KB / Downloads: 9)
Reply


Messages In This Thread
Issues importing Excel tables in Ple4Win - by shaswin - 14-06-2016, 04:27 PM
RE: Issues importing Excel tables in Ple4Win - by P Herwig MSc - 15-06-2016, 10:28 PM
RE: Issues importing Excel tables in Ple4Win - by P Herwig MSc - 17-06-2016, 12:47 PM
RE: Issues importing Excel tables in Ple4Win - by P Herwig MSc - 17-06-2016, 01:52 PM
RE: Issues importing Excel tables in Ple4Win - by P Herwig MSc - 22-06-2016, 11:27 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)