[LOGic] Re: dxcc band mode totals
Scott Porter
n1sp at hotmail.com
Fri Jan 4 22:29:12 EST 2008
I am having similar problem except when I select the 3dlog tab and try to paste the data I copied to the clipboard from my log file (2 separate excel files) into DXCC BAND_MODE_TOTALS_K8ZT-3.XLS in cell J2, I get the same error, "CANNOT PASTE CUZ
COPY & PASTE AREAS ARE NOT SAME".
now cell J2 is MODE...and when I try to paste to cell H2 which is CALL, I also get "CANNOT PASTE CUZ
COPY & PASTE AREAS ARE NOT SAME".
I noticed that width of cells does not look the same in DXCC BAND_MODE_TOTALS_K8ZT-3.XLS and my 3dlog.xls file, i.e. the call cells do not match width, mode, band, state, dxcc, and userdata don't either, date looks close. is this why the error about not pasting?
now, I got the 3dlog file by exporting my log file log.dbf in LOGic 6 (yes six) to a excel file and opening that file in excel. I could not do the report in logic as logic 6 does not offer sending a report to excel or CSV when printing.
In DAN's post below I wonder if you saw the 3dlog tab in the lower left of your excel screen????????? It sends you to a different page of Anthony's DXCC BAND_MODE_TOTALS_K8ZT-3.XLS worksheet...
Help and thanks
scott
wa1ytw ex-n1sp
Still having trouble here...
D/L'd latest version, make it thru step 18 of your (excellent!)
instructions.
When I go to DXCC BAND_MODE_TOTALS_K8ZT-3.XLS, the instructions are still
there, so cell J2 is no longer relevant, but if I move to cell H2 and try to
paste the 7 columns (call, qso_date, mode, band, state, dxcc, userfields)
into either H2 (or H2 thru N2), Excel pukes with the error "CANNOT PASTE CUZ
COPY & PASTE AREAS ARE NOT SAME". I could, theoretically, drag down
thousands of cells, but did not try it cuz this is a real hit & miss
proposition when you have 1000's of QSO's!
I think I'm missing something basic, even maybe an Excel tidbit.
Can you assist?
Tnx
es 73
Dan
K0DAN
More information about the LOGic
mailing list