Page 1 of 1

Excel column order

Posted: Fri 18 Dec 2015 15:09
by paul_rodgers
I select a bunch of columns from an object, fech the data just fine.
But I want to re-order the columns in the spreadsheet, it will not let me insert a new column, and cut-paste an existing column into it.

If I come out of edit-mode, create a new column, give it the new column-header and put data into it, then delete the old column (the one with that header) now when I try to commit I get a message that its not a double-precision number.

Its as though the update mapping to the data source is strictly by column number, not by the header

Am I just missing something?

Re: Excel column order

Posted: Fri 18 Dec 2015 15:20
by paul_rodgers
found my own answer, have to write the sql query rather than use cut-paste to move excel columns around