BUG in Conn Kit

[bobkrohn]

Open Conn Kit
Bring up a Spreadsheet
Highlight a Range of Cells.
Copy
Open Excel Spreadsheet (or a ASCII text editor)
Paste
Works fine
(of course functions probably not recognized but I'm mainly thinking about number data)

Then Reverse

Open an existing Excel Spreadsheet (say just two columns of plain numbers)
Copy
Open Conn Kit
Bring up a Spreadsheet
Paste into Spreadsheet

Conn Kit crashes

very major problem

neither method works for a Matrix.

[Tim Wessman]

This is a known issue since the prior release. None of the connkit editors were touched at all for this revision.

[bobkrohn]

Yuck. What a revolting development that is.
As I get to looking at the User Guide maybe I'll see another way to transfer data, hopefully

[bobkrohn]

The obvious question is:

How does a MAJOR flaw like this even get into ANY release in the first place?
example: I bought a new car and the heater doesn't work.
Is there any testing done at all?
How long has it been known?
I've been playing with the machine for only a few weeks and have found many major problems.
Can I get paid as a Beta Tester?
I'm just flabbergasted.

[Mark Hardman]

(12-18-2014 02:46 PM)Tim Wessman Wrote:  This is a known issue since the prior release. None of the connkit editors were touched at all for this revision.

Tim,

I think I see the problem. When copying from an Excel spreadsheet, on the clipboard the contents of each cell is separated by a tab (0x09) and each row is separated by a CR/LF (0x0D/0x0A). The trailing CR/LF on the last row seems to cause the Connectivity Kit to crash.

If I copy the selection from the Excel spreadsheet into a text editor and manually remove the last CR/LF, I can then re-select the remaining text and copy and paste it into a Spreadsheet opened in the Connectivity Kit.

I doubt that this will be acceptable to the OP. However, for others, this might be a useful work-around.

[Tim Wessman]

(12-29-2014 08:07 PM)Mark Hardman Wrote:  I think I see the problem. When copying from an Excel spreadsheet, on the clipboard the contents of each cell is separated by a tab (0x09) and each row is separated by a CR/LF (0x0D/0x0A). The trailing CR/LF on the last row seems to cause the Connectivity Kit to crash.

Interesting. Thanks for that.

[bobkrohn]

I'll try it out. Thank You.
Maybe I can write a VB program for this simple task to make it as easy as possible.

[bobkrohn]

I just tried this workaround and was not successful.

Opened an Excel 2007 Spreadsheet.
Populated it with my typical data. Mostly numbers some Text.
Exported as a Tab Delimited Text file.
Opened it in Ultra Edit ASCII.
Lopped off the last two "characters" in the file.
Selected and Copied to Clipboard.
Pasted into the Spreadsheet App opened in Connectivity Kit.
It was there.
(BTW - using Ctrl V doesn't work. Have to use the Paste in Right Click Menu. Oi)
Closed the Spreadsheet and told it to Save Changes.
Reopened the Spreadsheet and of course nothing is there.

Am I missing something?
Should be an intuitively simple task.