RM and the KeyMap tab

Wheelie4 · Post by **Wheelie4** » Thu Feb 24, 2005 10:51 am

gfb107,

I know this isn't an important issue but is it possible to add a copy to clipboard button on the Keymap tab allowing the ability to copy the tabs contents into a spreadsheet like excel? Or atleast the ability to hilite and copy? Currently you can only print it out. I find it convienent putting the keymap info of two devices on one sheet of paper (in landscape) with only one column listing the remotes buttons. Currently I type all the info in excel manually.

ot04298 · Post by **ot04298** » Thu Feb 24, 2005 11:23 am

I second the motion - it would be nice to be able to manipulate this data.

Wheelie4 · Post by **Wheelie4** » Thu Mar 03, 2005 4:28 pm

@gfb107

Thx for the hilite and copy ability in v1.19.

gfb107 · Post by **gfb107** » Thu Mar 03, 2005 4:40 pm

Wheelie4,

I haven't done anything with this request. I guess Java provides built-in support for copying the selected parts of a table to the clipboard using Ctrl-c.

Wheelie4 · Post by **Wheelie4** » Fri Mar 04, 2005 9:54 am

I tried before v.1.19 but it wouldn't let me hilite multiple rows. Maybe I just did it wrong.

Atleast now I know it's possible.

johnsfine · Post by **johnsfine** » Fri Mar 04, 2005 10:16 am

I never tried this in the Key Map tab before.

I like to copy things over to Excel from various tabs in RM. I've had mixed results. I wish I had kept better notes.

I'm pretty sure multiple selection by dragging has usually failed for me (in the other RM tabs where I had tried it). Now it works fine in Functions, External Functions, and KeyMap. (No multiple select work in Buttons, but that isn't so important).

I've consistently been able to use multiple select in the Functions tab using click and shift click (on opposite corners of the area I want). That worked when drag didn't.

I can now get a correct paste into Excel from a copy from the KeyMap tab, even though that is three columns.

I can't get a correct paste into Excel of more than one column at a time from the Functions tab. At some point in the past this sometimes worked. Now I need to do it one column at a time.

Greg, is there a difference in clipboard format between copies from KeyMap and those from Functions, that would explain why Excel understands buttons is multiple columns but can't understand that from Functions.

Any lurking Excel experts, is there a way to make Excel understand the ascii tab character as a column delimiter in a paste? I also run into this problem pasting DecodeCCF output into Excel. It can use tab delimiters when opening a .txt file but I can't get it to use them when pasting txt.

gfb107 · Post by **gfb107** » Fri Mar 04, 2005 10:28 am

John,

I can succesfully copy'n'paste from the Functions panel into Excel '97.

There may be a difference in the format of the clipboard data. I coded the copy function for the Functions panel. The copy that occurs of the KeyMap panel is automatically provided by Java.

gfb107 · Post by **gfb107** » Fri Mar 04, 2005 10:39 am

Selection by drag works on the Functions panel as long as you keep the mouse pointer out the the "#" column. That's because dragging in that column is used for reordering.

Post by **ElizabethD** » Sun Mar 06, 2005 8:38 pm

johnsfine wrote:... is there a way to make Excel understand the ascii tab character as a column delimiter in a paste? I also run into this problem pasting DecodeCCF output into Excel. It can use tab delimiters when opening a .txt file but I can't get it to use them when pasting txt.

John, without an example, this answer may not be relevant.
Excel delimits by tabs automatically, which is why i suspect I'm not reading your question correctly.
If you paste text containing tabs, AND if it stays in one column (it won't if you used KM a short while back or if KM is open), then using Data menu, click on Text to columns and it should ask you how to control the split via tab, comma, semicolon, space, other -- you might be able to type in your own thing in other.
If this gets you nowhere, post some examples in diagnosis or send me email and tell me where the splits should be.
Just in case - what Excel version? I don't think it matters, really.

johnsfine · Post by **johnsfine** » Mon Mar 07, 2005 9:01 am

ElizabethD wrote:If you paste text containing tabs, AND if it stays in one column

Recently it always has. I think it used to sometimes work, but I'm not sure.
Recently when I get a text import dialog it always defaults to "," delimited and I need to change to tab delimited. It used to usually default to whatever I used recently and only rarely switch back to "," delimited.

ElizabethD wrote: (it won't if you used KM a short while back or if KM is open),

KM is almost always open. Starting now from KM, I
1) Click the new button to get a new workbook.
2) Run RM and open a recent rmdu file, and switch to functions tab.
3) Drag select Name, EFC and OBC of several rows.
4) Click the copy button
5) Click the title bar of my blank Excel work book
6) Type ^V, getting all the data into colunm A with tabs embedded in the text.
7) Select Text to Columns, and Next
8) As always on that dialog, check Tab, uncheck Comma, and change Text qualifier to {none}. There REALLY ought to be a way to save that as the default.
9) Click finish, and it's all fixed.

Thanks, I had never looked at Text to Columns before. That's a much easier work around than the one I've been using.

I'd still prefer if Excel could remember that those are the choices I always want on that dialog.

ElizabethD wrote:Just in case - what Excel version? I don't think it matters, really.

Microsoft Office Excel 2003 (11.6113.5703)

But I don't think it matters either, because I've had the same issues on other computers with different Excel versions.

Post by **ElizabethD** » Mon Mar 07, 2005 10:16 pm

johnsfine wrote:I'd still prefer if Excel could remember that those are the choices I always want on that dialog.

Double edged sword.
Couple items that might trip you, starting with above:
1. The setting of how to translate is quite persistent. I wish it were more volatile. Once you did it with one type of delimiter, next paste will do the same.
Example: after using a comma delimiter, perhaps new text should be parsed with spaces or tabs. But excel's looking for a comma and places all text and tabs in one cell.
Workaround: look at it in disbelief, then do the Text to columns on what got pasted asking for the tabs job. Can't blame it on KM, which I did long ago, so this is my public retraction

to Mark.

2. Watch out for a file which looks uniform but isn't, i.e. may have the delimiter character, someplace (unlikely with ccf). Excel will then split few cells and you don't notice that it overwrites other data.
Safety workaround: after initial pasting, enable the data autofilter on several adjacent columns and review dropdown lists. They should only contain blanks.
End of excel forum.