vim.xlam: v0.6.0

Full Changelog: v0.5.4...v0.6.0

As the author, I’ve often found myself forgetting which key is bound to which command. So, in this update, I’ve added a command suggestion feature inspired by Neovim's which-key.nvim. Now, no more flipping through the README just to figure out which key does what!

Sample Screenshot:

BREAKING CHANGES:

• Changed the key assignment for PrintPreviewOfActiveSheet (:printpreview -> :preview)

Features:

• Implemented a extremely powerful command suggestion feature
  • For normal commands, suggestions are displayed after the time set in SuggestWait has elapsed
  • In command line mode, press the <Tab> key to display suggestions. This can be changed using cmap to change the key.
    • The access keys for suggestions are the characters set in SuggestLabels, in that order.
  • If prefix (./, ../, ~/, / and so on ...) is typed in the command argument portion, path suggestion is also available.
    • Combine with :e command to open files seamlessly
• Added the feature to lock and restrict row/column selections (rl/cl for lock, rL/cL for unlock)
  • This feature forces the selection back into the range if you select outside the locked range
  • When you want to edit only a specific row/column, it is recommended to use the lock and then search the header
• Added support for numpad keymap #46
• Added the function to increase/decrease values sequentially (g<C-a> / g<C-x>)
• Added the ToggleGridlines (gb)
• Added the ToggleHeadings (gh)
• Added half-page scroll left/right feature (, / ;)
• Added commands
  • SearchHelp: Find help for commands bound to keys (:help)
  • ReloadVim: Reload vim.xlam (:reload)
  • Sort: Sort rows (:sort for ascending, :sort! for descending)
  • RemoveDuplicates: Remove duplicates rows (:unique)
  • OpenActiveBookDir: Open file location (:opendir)
  • YankActiveBookPath: Copy full path to clipboard (:fullpath)
  • ShowVersion: Show vim.xlam version info (:version)

Changes:

• AddNumber/SubtractNumber now works with one empty cell selected
• AddNumber/SubtractNumber supports for prefixes/suffixes
  • e.g. works for "001. Intro", "Param005", "1. vim.xlam 101" (Italic text will be effected)
• The OpenWorkbook command now accepts a file path as an argument
  • e.g. :e ~/Downloads/sample.xlsx
• Worksheet-type operations support graph sheets

Fixes:

• Correct input by RepeatAction from Text to Formula after value input
• Fixed an issue with Shift key and specific key combinations not working

A new configuration template file is /config/_vimxlamrc

vim.xlam: nightly build

nightly

vim.xlam: v0.5.4

Full Changelog: v0.5.3...v0.5.4

Features:

• Added numeric increment/decrement functionality (Inspired by @windweaver828 )
• Added a feature to exit Excel when all workbooks are closed #44 (Thanks to @windweaver828 for the contribution!)
• Added the ability to swap sheet order in SheetPicker (J/K)

Changes:

• Changed the keybinding for UnhideColumns #42
• Modified to disable IME after the InputBox is closed
• Improved performance of loading default configuration

Fixes:

• Fixed an issue where the settings file would not load when the file path contained platform-specific characters #42 (Thanks to @sdys-box, @zhengye96 for the contribution!)
• Fixed an issue where hyperlinks set with the HYPERLINK function could not be followed correctly
• Fixed an error when changing sheet names in SheetPicker if an invalid sheet name was provided
• Fixed several minor issues

A new configuration template file is /config/_vimxlamrc

vim.xlam: v0.5.3

Full Changelog: v0.5.2...v0.5.3

Fixes:

• Fixed an issue that may not correctly retrieve the key status in 32-bit version of Excel #41 (Thanks @sdys-box)
• Fixed a bug that did not cancel Cmdline mode properly

vim.xlam: v0.5.2

Full Changelog: v0.5.1...v0.5.2

Fixes:

• Fixed an issue that ShapeInsert mode was not exiting properly #40
• ColorPicker is now centered even on multiple displays

vim.xlam: v0.5.1

Features:

• ColorPicker Enhancement

  • Added support for 5 custom colors with optional configuration.
  • ColorPicker size can now be optionally set.
  • Improved highlighting of selected colors.
  • Enhanced contrast for inactive elements.
  • Full support for theme color luminance changes.
  • Resolved screen shift and flickering issues.

  ColorPicker sample
  

Changes:

• Added more functions to support g:count.

Fixes:

• Corrected an issue where KeyStrokeWithoutKeyup did not work correctly.
• Fixed a bug occurring in cases where the command was executed and failed.
• Resolved an error occurring when saving to OneDrive.

vim.xlam: v0.5.0

Customization of settings is now available! 🎉
We've significantly revised the internal structure, aiming for speed improvements, optimizations, and enhanced extensibility.

BREAKING CHANGES

• Changed the key assignment for SwapVisualBase (o -> <C-.>)
• Significantly altered the internal structure

Features:

• Added the ability to customize settings

Changes:

• Enabled the description of key mappings in Vim style
• Introduced a separate command-line mode, allowing input in a text box

Fixes:

• Fixed a bug where ToRightOfCurrentRegionColumns was not functioning
• Addressed the issue of slowdown when g:count is provided during scrolling
• Fixed the problem where the position of the search box was fixed

vim.xlam: v0.4.1

Fixes:

• Fixed a bug in a getTargetRows function
• Dealing with overflow errors when a negative number of date type is input in a cell
• Scrolling is now correct even when merged cells exist
• Fixed a bug that Visual mode does not stop after changing sheets
• Fixed preview mode in the SheetPicker trying to preview a nonexistent sheet
• Fixed an issue with Excel 2019 that does not work left/right alignment

vim.xlam: v0.4.0

BREAKING CHANGES

• Changed default keymaps #38
  • increase/decrease font size: < / > → - / +
  • increment/decrement text: - / + → < / >
  • increase/decrease decimal: [ / ] → ( / )
  • special paste: P → gP
  • toggle read only: @a → ~
  • next/prev workbook: @n / @N → [b / ]b
  • toggle freeze window: @w → zf
  • toggle wrap text: @r → zw
  • merge/unmerge: @m → &
  • toggle function bar: @x → =v
  • show file info: @s → gs
  • set/unset print area: @p / @P → zp / zP

Features:

• Added yankAsPlaintext command #38
• Added applyCommaStyle command #38
• Added AutoSum related features (prefix: =) #38

Changes:

• Support for append/insert for row/column paste #38
• Changed behavior of union/except select cells #38

Fixes:

• Fixed a bug that some commands was not working with files on OneDrive and SharePoint
• Fixed scrolling behavior in visual mode

vim.xlam: v0.3.3

Changes:

• Improve behavior of functions related to rows/columns
• Add ZZ and ZQ for default keymap

Fixes:

• Fixed a bug when applying color to shapes with ColorPicker
• Fixed an issue with losing focus when scrolling while selecting a shape
• Fixed a bug when gExtendRange dying
• Addressed a case when the same name was given in a sheet renaming
• Improve error handling