I'm building an interactive application in PP to allow my users to schedule tests on a list of compounds pasted into an interactive reporting form. The pasted data would include compound ID, batch, and concentration, but not always all three - concentration may be omitted, or batch, or both. Currently, compound testing requests are in Excel, so ideally the chemists could copy their Excel-based compounds and the paste them into a grid on the interactive form, which would then pass the info to the next PP protocol with each column conserved as a property, array or otherwise. I can see one possible solution to this involving pasting comma-separated values into a textbox and parsing them at submit time, but pasting the data into an interactive or editable grid doesn't appear to be an option as the pasted Excel data all stays in the selected cell of the grid rather than being parsed to the rest of the rows and columns as it would in a typical Excel paste. Also, neither of these grids automatically expands to accept more rows or columns than are currently displayed. How would you handle this?
Chris
