Win97 Copy/Paste Buglet?

[Mischief810]

I have a large EDACS trunked system I'm trying to put into my Pro-97. There are about 150 talk groups and I have the frequency data stored in a spreadsheet. The columns are lined up right (with Alpha Tag on the left, ID on the right).

Win97 will let me paste the first bank of Talkgroup data just fine. However, it will only let me paste the Alpha Tag data into each of the other banks. The ID's don't get pasted and all of them stay at 000. I'd rather not type these in manually, as they'll be changing over time.

Is this a known issue or an "undocumented feature?"

 

[fmon]

Mine works fine for all 5 sub-banks. In fact, Don, made life easier for Win96/97 users, the alpha tags can be copied from a spread sheet in this format

22592	87-WCO-DISP1  
22608	87-WCO-DISP2  
22624	87-WCE-C2C1

but will appear in Win97 in this format after selecting paste.

87-WCO-DISP1    	   22592	 
87-WCO-DISP2    	   22608	 
87-WCE-C2C1     	   22624

BTW, you must copy no more then 30 Talkgroups at a time for each sub-bank, then select the next sub-bank for the next copy (up to 30) etc.

Web Import will allow up to 150 TG's on one import, but not with copy/paste.

Edit: Did you have the bank set to EDACS prior to pasting?

 

[Mischief810]

I figured it out--it was a Spreadsheet <> Windows clipboard <> Win97 problem.

 

[Mischief810]

I figured it out--it was a Spreadsheet <> Windows clipboard <> Win97 problem.

More specifically: The EDACS Talkgroups require 4-digit decimal ID's. When cutting and pasting from a table (like RR's database), some applications will drop the leading zero as an insignificant digit and convert the text to numeric format.

Thus, an ID of 0209 will be converted to 209, which Win97 will not accept when pasted in.

Open Office's Calc does this. I don't use Excel anymore so I can't say whether it does so or not.

 

[fmon]

In Excel, if the ID number column is changed from general to text, the leading 0 will be applied after paste even though it is not in the column.