Dear All,
I'm trying to do data input from an existing Excel sheet,
two things are making my life difficult.
1: When entering the first element of SETDATA function, I cannot easily jump to a different Excel File.... it is possible to use Setdata an specify content on a different sheet as source, but it is not possible to specify a cell in a different file as a source.
2: I am not able to tell Paste View, where to put the output on my sheet.
I do not want pasteview to start in A1 cell of the sheet.
Am i missing something in the interface? .... Many excel tools allow the user to specify a target cell or cell range. This would be the new functionality in PasteView that would greatly help.
Dear JEDOX please please please add a "Target Cell" function to paste view.
My workaround is very manually time consuming, since I need to copy content out of the source data sheet, and paste it over to an empty Excel sheet in a different file, leaving enough area, so that when I put in the cells with Paste View I will have enough Space left over.
3. I cannot copy paste Palo.Data functions from one excel file to the other.
All I can do is paste from one sheet to the other. "Paste special..." does not allow me to copy-paste palo formulas between files, just between sheet.
Any workaround?
All comments welcome
Thank You
G.
