Interesting & Creative way of loading SpreadSheet from PC
|
02-11-2015, 08:25 AM
(This post was last modified: 02-11-2015 08:31 AM by Thomas_Sch.)
Post: #17
|
|||
|
|||
RE: Interesting & Creative way of loading SpreadSheet from PC
Hello Bob,
YEDERFs and HANs suggestions work very well, if you pre-populate the Spreadsheet in Prime and the Excel-Spreadsheet the same way. The basics, If you want to copy data from Excel to Prime: - all cells in Prime should have a content ith the rigth type, e.g. formula, number, or text as in Excel - Cells in Prime should not be empty prior to copying - Cells in Excel should be displayed as formula, like shown in the video - an editor is used as temporary storage. Excel -> Editor -> Conn.Kit - additionaly cells with text-type-content should be included in "" @ YEDERF: please correct me, if this description is faulty. If the corresponding cells match the type, copying will work. You're right, it's not really user-friendly, but it's working without program! HP should add this (or a better description) to the manuals. If users have problems with this way, publishing your routines here would help. |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: 2 Guest(s)