kjnh10 / excellikevim Goto Github PK

Security Policy Proposal

There should be a clear security policy which indicates that vimx will not access the internet. It has no reason to.

Has anyone looked into the code in files like gmail.py?

I'm just confused as to why there would need to be a file with comments such as this:

"""Send an email message from the user's account."""

What is the purpose of _Stash? This seems like a folder which should have been excluded via .gitignore.

These files raise some red flags. And, with all of the Japanese comments, I find the code to be very difficult to understand.

Proposal Summary

• Create a version without internet access.
• Creators and Maintainers of this project agree to follow a clear and concise security policy.

What a cool plugin!

I think that u does not work properly. When I delete a row with dd and then press u you'd expect it to undo the most recent delete. Is undo not implemented yet? Or do I really miss something basic here.

Cheers

Hi kjnh10,

Love the plugin!

I have an issue when initiating/activating the plugin. I cannot get pressing F3 to work. I have to re-add the add-in from the "Add-ins" menu each time I want to use it. It then asks me if I wish to replace the file (with the same file) and then, once i have pressed yes, it works like a charm. Let me know if you want to see any screenshots or outputs, I am happy to provide them.

This could be a me-problem but any help is appreciated as I absolutely adore this add-in as a vim-user and occasional excel-user!

All the best,
Ouilly

Plz translate the Japanese comment in your code into English. So we can understand them and contribute.

After installing and applying the add-in, I get the following error upon opening Excel:

It appears Udir is an invalid filepath, though I can't find where this path is defined.

I attempted to workaround by explicitly declaring mruDir to point to my installation directory. However, this opened up a whole other set of issues (unite not able to be found, other filepaths being broken).

Please advise. This project looks really cool and I'm dying to use it!

If you add this function, this plugin will be more powerful.
and we can use:
n dd
this kind of commands.

Downloaded the latest release (2.3.3). Trused VBA programs as stated in installation. I now see it listed in Add-Ins section of Options panel. The functionality has not changed; hjkl would simply add 'hjkl' to the currently selected cell. I was never able to get this to work. I do not see any error pop up either, but I am not sure how to troubleshoot since I'm not familiar with excel add-ins.

When using arrow keys to navigate rows and columns, it will skip hidden rows and columns by default.
But when using hjkl, it would not. It would just dive into the rows and columns that are hidden, which is kind of annoying.
Is it possible to make them act the same way?

Does this work on a Mac? I'm having issues getting it working on a Mac.

There are two closed issues that seem unresolved that are related to being unable to get this add-in working.

First, I'd like to say that I know very little about how add-ins work, MS Office, or windows programs in general. I'm forced to use windows at work, which is why I'm trying to use this "add-in."

I followed the instructions from the readme markdown file, and excel seems to recognize the add-in, (the checkmark for vimx is checked and excel seems to accept it without any issues) but then I can't use any vim keys. For example pressing "j" doesn't move the selected cell down one and instead just types "j" into the current cell.

I enabled the trust access to VBA in the Trust Center (before I did that, I would get a runtime error). I have not been able to set the MS DAO 3.6 Object Library model (and I'm not even sure I need to because I don't think I'm using an old version of excel) because it says that there is some sort of conflict (naming or otherwise) and prevents me from doing so.

But I feel like I'm missing something simple. Maybe the add-in is there, but I need to activate it with some keyboard shortcut or something? I haven't used "insert mode" (since I haven't got the add-in to work), but maybe I'm just stuck in that? I've tried pressing Esc, but that still didn't put me in normal mode so that I could start using vim keys.

Additionally, I tried using the sample user_config.bas from the readme markdown file and just copy/pasted that into the configure.bas file. Maybe I need to rename configure.bas to user_config.bas?

Something else that is strange is that in the images from both #10 and #8 there is a screenshot posted describing the VBAProject(vimx.xlam) project tree. That tree shows up with VBAProject(vimx.xlam) in the VisualBasic editor, but I have a bunch of individual files and no directory hierarchy as shown in the screenshots in the above issues?

Maybe I don't have the permissions necessary to run this add-in on the computer I'm using at work? Any idea on what I should try in order to get it to work?

Thanks a ton!

I installed the vimx plugin (it shows up under Options > Plugins) and tried the following:

1. Enable Trust Center Logging under Options > Trust Center
2. Set Microsoft DAO 3.6 Object Library under Tools > References under Microsoft Office VBA

When I press 'j', I simply edit the contents of the cell to be 'j' rather than move down a cell.

Could you look into fixing this issue? Much thanks for the help

I am using the Mac version of Microsoft Excel. Will this add-in work for me?
downloaded and unzipped the file. Then I went to Excel and went to Tools >> Excel Add-Ins
Then I clicked Browse and selected the vimx.xlam file.

This added Vimx as an available Add-In. So I check the box and click ok. I get a pop up window that says "Can't find project or library" I click ok and I get another pop up window titled References - VBAProject. I looked for DAO 3.6 but had no luck.

This may be an unsupported feature, but it appears this will not run on a Mac? When attempting install, it appears to be missing Microsoft Scripting Runtime and Access DB engine.

Any idea about how to make this work on a Mac? I would love to use your tool here but I don't think I'll be using a virtualizer to make it work. Thanks!

would really appreciate that! the program is amazing and would love to use it on my mac!

Hello,

Decided to give this a try since I've started wanting keybindings for everything, but there seems to be a problem when I first click a button (h,j,k or l) after installing and starting up:

Compile error:
User-defined type not defined

I've never worked with scripts like these before, but the error is happening in keyStrokeAsseser, on this line (can't fint a way to show line numbers):

Private Function NumberOfHits(stroke As String, context, modeOfVim) As Long '{{{

I didn't manage to find out exactly which type it disliked, but I would be happy to help trying to find out.

Some info:
Excel version: Microsoft Excel 2016 MSO (16.0.8730.2046) 32-bit
Office version: MS Office Professional Plus 2016
Windows: Windows 10 version 1709 (OS Build: 17025.1000)

Also, I managed to finally find the Stact Trace with some more debug info, but I'm not sure how much it helps really:

So I am using windows.

I created a user_configure.bas file in C:\Users\username\user_configure.bas. Is that correct?

Now i want to apply the changes i made so i go to excel and press F3. I get this error.

If I press End and try F3 again i get another error.

What am i doing wrong?

Thanks in advance!

rest of error message:

...the macro may not be available in this workbook or all macros may be disabled. "

The thing is, it works fine at first (since I have enabled macros and allowed trust center to do vba object access.) But, once it happens, it just keeps happening. I am on Excel 2013. I can overcome it temporarily sometimes by going to Developer > Add-ins > and then reload vimx.xlam. I use English input method. Does it work consistently for you on Excel 2013?