A while ago I found a bug in imagesloaded js where images failed to appear after loading. This seems to be attributed by the “fixed” timer used by imagesloaded js to detect if an image has completely loaded. Consequently larger images taking longer loading time exceeded the specified fixed time. To rectify this, the timer mechanism has to be fixed.
Ruby Rails: sqlite3 on Windows x64
Ruby 2.1 64-bit for Windows have problem with sqlite3 gem install where it can’t find the native library. You would get an “unable to find sqlite3_native.so” or “checking for sqlite3_libversion_number() in -lsqlite3… no”. To fix this:
- Download source file from sqlite.org and unzip to a directory. Eg. C:\sqlite3
- Download the 64-bit dll from here and replace the unzipped dll with this.
- Now run
gem install sqlite3 --platform=ruby -- --with-sqlite3-dir=C:\sqlite3 --with-sqlite3-include=C:\sqlite3 --with-sqlite3-lib=C:\sqlite3
Auto-generate HTML UL/LI Table from Excel
Writing UL/LI table in HTML is always a tedious task especially when the dataset is large. So I’ve created a very simple tool long ago that can auto generate UL/LI table. This is written in Excel VBA and can place the elements horizontally or vertically.
The added benefit for doing this in Excel is to be able to manipulate the dataset using Excel’s functions before converting them to table. Go to the download page and look for xlsToULTable.
To use the xlsToULTable Excel spreadsheet:
- Tabulate the spreadsheet.
- Select the entire tabulated dataset.
- Select Macro and run the “ToHTML” macro.
- A message box will ask if you want to generate the table horizontally (column based) or vertically (row based).