Home

Filters

Use ABC as a column filter to find rows containing "ABC"
Use =ABC to find rows with column values equal to "ABC"
Use !ABC to find rows without "ABC"
Use >N or <N to find rows with more or less N

How to use 64-bit plugin with 32-bit Office

The x64 plugin version requires x64 ODBC drivers. With Office x32 you need to install x64 drivers and overwrite NLS support files (\1033, \1049 and the same).

Install Microsoft Access Database Engine 2010 Redistributable or Microsoft Access Database Engine 2016 x64
```
accessdatabaseengine_X64.exe /quiet
```
The next steps are optional (if the plugin still doesn't work)
Run regedit32, go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\FilesPaths and remove mso.dll (16 if you have Office2016)
Copy all files from c:\Program Files\Common Files\microsoft shared\OFFICE16\1033\ into C:\Windows\System32 or %COMMANDER_PATH%.
Try to open xlsx files and try again on falling.

Check a discussion about it here (russian).

Hot keys

Key	Description
Ctrl + Mouse wheel	Change font size
Tab	Switch focus to the next control
Ctrl + Tab	Switch focus to the previous control
F1	Open Wiki
F11	Toggle full screen mode
Ctrl + C	Copy current value
Shift + C	Copy selected row(s)
Ctrl + Shift + C	Copy column
Ctrl + Column click	Hide column
Ctrl + Space	Restore all hidden columns
Alt + Cell click	Extract an url from the cell and open it in a browser
Ctrl + 1, Ctrl + 2, ...	Sort by column number
Ctrl + 0	Sort by current column

Settings

Settings are stored in odbc-wlx-section in c:\Users\%User%\AppData\Roaming\GHISLER\lsplugin.ini.
If the plugin folder contains odbc-wlx.ini then settings will be read from it.
Check default.ini in a distributive to get available options and their descriptions.

RGB colors are integer values. You can use Get Color Picker.

Performance cons

Because of ODBC doesn't support limit ... offset ...-clause, the full table read into memory each time and therefore the plugin is not supposed to be used for large tables (1KK+ rows).

Data Source Name files (*.dsn)

To create dsn file use ODBC Data Source Administrator (Win + R > odbcad32).
The dsn file is a simple ini-file like below

[ODBC]
DRIVER=Microsoft Access Driver (*.mdb, *.accdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=281
DefaultDir=D:\DBS
DBQ=D:\DBS\Example.mdb

You can create these files to any RDBMS if you have appropriate ODBC driver e.g. MySQL, PosgreSQL, Mongo to view remote DBMS.

How to build

del odbc-wlx.wlx
del odbc-wlx.wlx64

rem 32bit, mingw64
set PATH=c:\mingw64\mingw32\bin;%PATH%
gcc.exe -Wl,--kill-at -shared -static main.c -o odbc-wlx.wlx -m32 -s -Os -lgdi32 -lcomctl32 -lodbc32 -luxtheme

rem 64bit, mingw64
set PATH=c:\mingw64\mingw64\bin;%PATH%
gcc.exe -Wl,--kill-at -shared -static main.c -o odbc-wlx.wlx64 -m64 -s -Os -lgdi32 -lcomctl32 -lodbc32 -luxtheme

Navigation Menu