posted on September 12, 2000 08:54:49 AM
When I try to Cut and Paste a record (a complete horizontal line from Excel which contains the complete required data for 1 listing) to another line somewhere else in that same spreadsheet, it copies just fine.
But if I cut and paste it to another list in another window where another Excel is running, my item description in column C gets truncated every time, and I am forced to go back and copy and paste column C by itself to get all the data.
Does anybody else have this problem and do you have a fix? The way it is now, moving listings from one list to another is a time-consuming pain and it should be a snap.
posted on September 14, 2000 07:18:46 PM
There are a couple of ways to do this. Here's one that's probably the easiest and most useful:
Click on the empty gray square in the upper left corner (between the "A" and the "1". This will highlight the entire spreadsheet.
Now, move your cursor to one of the divider lines between the column headings, i.e. the line between the gray "A" cell and the gray "B" cell. Your cursor will turn in to a vertical line. Then double click.
This should automatically horizontally reize all columns so that no data will be truncated.
Oh, another thing I just thought of... Be sure you are saving your spreadsheets in one of the native Microsoft formats, i.e. .xls. This is the default, so it shouldn't be a problem. But if you save in one of the other formats such as .dbf or .csv, you may lose data permanently if your cells are not the proper size.
posted on September 14, 2000 07:42:56 PM
I tried it without changing from the .csv file the bulk loader requires. Nothing much changed and Column C, which holds the most data (the item description) gets truncated once again.
Are you suggesting I save the file in default format, doo the copy and paste, then save it again in in .csv and I will have the same data stream required by the bulk loader?
posted on September 15, 2000 08:01:16 AM
Don't feel bad I tried again to set up the Bulk Loader, and I simply can't do it. I put in the description, and the whole thing goes hay wire!
I am hoping my better half can set it up for me. I don't know why I have such a mental block on this thing. Sometimes I wonder how someone like myself who is relatively computer savvy, has been selling on line quite successfully for over 5 years, writes all their own html, can't do a spread sheet, but I simply can't do it.
Oh well - guess if I could do the spread sheet, then I'd be perfect and no one could live with me!!!! LOL
posted on September 15, 2000 08:08:23 AM
What you need is a sample. Contact me (my email address is associated with this user name on Yahoo auctions) and I'll send you one. As i remember Yahoo Bulk loader help supplies one as well.
. This will highlight the entire spreadsheet.